update.php

<?php
include('../simplehtmldom/simple_html_dom.php');


function GetDataXSMB($strLink) {

// -----------------------------------------------------------------------------

// Retrieve the DOM from a given URL
$html = file_get_html($strLink);

$i=0;
$timeupdate = array();
foreach($html->find('span[style="font-size:14px; color:#fff; "]') as $e) {
$timeupdate[$i++] = $e->innertext;
}

$i=0;
$product = array();
foreach($html->find('td[class="number_kq"]') as $e) {
$product[$i++] = $e->innertext;
}

$response["products"] = array();
for ($i=4; $i >= 0; $i--) {
$kqmb["Time"]=$timeupdate[$i];
//$j=$i*9;
$j=$i*8;

$kqmb["DB"]=$product[$j++];
$kqmb["G1"]=$product[$j++];
$kqmb["G2"]=$product[$j++];
$kqmb["G3"]=$product[$j++];
$kqmb["G4"]=$product[$j++];
$kqmb["G5"]=$product[$j++];
$kqmb["G6"]=$product[$j++];
$kqmb["G7"]=$product[$j++];
//$kqmb["G8"]=$product[$j++];

array_push($response["products"], $kqmb);

$ketqua = $kqmb["DB"] . "," . $kqmb["G1"] . "," . $kqmb["G2"] . "," . $kqmb["G3"] . "," . $kqmb["G4"] . "," . $kqmb["G5"]  . "," . $kqmb["G6"] . "," . $kqmb["G7"];// . "," . $kqmb["G8"];
$thoigian = $kqmb["Time"];

$thoigian = trim($thoigian);
$tg = explode(" ", $thoigian);
$thoigian = $tg[1];

//echo  $thoigian . "   " . $ketqua . "<br/>";


$conn=mysql_connect("localhost","root","") or die("can't connect this database");
mysql_select_db("appxoso",$conn);
// mysql inserting a new row
$ketqua = str_replace(" ","",$ketqua);
$thoigian = str_replace(" ","",$thoigian);
if ( (strlen($ketqua) > 130) && (strlen($thoigian) == 10) ) {
    $sql="SELECT * FROM xosomienbac WHERE thoigian='$thoigian'";
    $query=mysql_query($sql);
    if(mysql_num_rows($query) == 0) {
        $result = mysql_query("INSERT INTO xosomienbac(ketqua, thoigian) VALUES('$ketqua', '$thoigian')");
        //sleep(1);
    }
} else {
    echo " KhongInsert ";
}

}
}

function GetData($strLink, $strBang){
// Retrieve the DOM from a given URL
$html = file_get_html($strLink);

$i=0;
$timeupdate = array();
foreach($html->find('span[style="font-size:14px; color:#fff; "]') as $e){
$timeupdate[$i++] = $e->innertext;
}

$i=0;
$product = array();
foreach($html->find('td[class="number_kq"]') as $e) {
$product[$i++] = $e->innertext;
}

$response["products"] = array();
for ($i=4; $i >= 0; $i--) {
$kqmb["Time"]=$timeupdate[$i];
$j=$i*9;

$kqmb["DB"]=$product[$j++];
$kqmb["G1"]=$product[$j++];
$kqmb["G2"]=$product[$j++];
$kqmb["G3"]=$product[$j++];
$kqmb["G4"]=$product[$j++];
$kqmb["G5"]=$product[$j++];
$kqmb["G6"]=$product[$j++];
$kqmb["G7"]=$product[$j++];
$kqmb["G8"]=$product[$j++];

array_push($response["products"], $kqmb);

$ketqua = $kqmb["DB"] . "," . $kqmb["G1"] . "," . $kqmb["G2"] . "," . $kqmb["G3"] . "," . $kqmb["G4"] . "," . $kqmb["G5"]  . "," . $kqmb["G6"] . "," . $kqmb["G7"] . "," . $kqmb["G8"];
$thoigian = $kqmb["Time"];

$thoigian = trim($thoigian);
$tg = explode(" ", $thoigian);
$thoigian = $tg[1];


$conn=mysql_connect("localhost","root","") or die("can't connect this database");
mysql_select_db("appxoso",$conn);
// mysql inserting a new row
$ketqua = str_replace(" ","",$ketqua);
$thoigian = str_replace(" ","",$thoigian);
if ( (strlen($ketqua) > 97) && (strlen($thoigian) == 10) ) {
    $sql="SELECT * FROM " . $strBang . " WHERE thoigian='$thoigian'";
    $query=mysql_query($sql);
    if(mysql_num_rows($query) == 0) {
        $result = mysql_query("INSERT INTO " . $strBang . "(ketqua, thoigian) VALUES('$ketqua', '$thoigian')");
        //sleep(1);
    }
} else {
    echo " KhongInsert ";
}

}
}
$mangxoso = array(
"xo-so-binh-duong",
"xo-so-tp-ho-chi-minh",
"xo-so-binh-thuan",
"xo-so-ca-mau",
"xo-so-dong-thap",
"xo-so-bac-lieu",
"xo-so-ben-tre",
"xo-so-dong-nai",
"xo-so-soc-trang",
"xo-so-can-tho",
"xo-so-an-giang",
"xo-so-vung-tau",
"xo-so-binh-phuoc",
"xo-so-hau-giang",
"xo-so-kien-giang",
"xo-so-lam-dong",
"xo-so-tay-ninh",
"xo-so-tra-vinh",
"xo-so-vinh-long",
"xo-so-tien-giang",
"xo-so-long-an",
"xo-so-da-nang",
"xo-so-quang-nam",
"xo-so-khanh-hoa",
"xo-so-dac-lac",
"xo-so-binh-dinh",
"xo-so-dac-nong",
"xo-so-gia-lai",
"xo-so-kon-tum",
"xo-so-ninh-thuan",
"xo-so-phu-yen",
"xo-so-quang-binh",
"xo-so-quang-ngai",
"xo-so-quang-tri",
"xo-so-thua-thien-hue"
);

GetDataXSMB("http://ketquaxoso.24h.com.vn/xo-so-mien-bac/page1");
for ($i=0; $i<count($mangxoso); $i++){
    $bang = $mangxoso[$i];
    $j=$i+1;
    $link = "http://ketquaxoso.24h.com.vn/" . $bang . "/page1";
    $bang = str_replace("-","",$bang);
    //echo $bang . " - " . $link . "</br>";
    GetData($link,$bang);
}

echo "Update finish"
?>