getLivescore.php

<?php
/*
 * TranDau: idTranDau, GiaiDau, BangDau, Ngay, TrangThai, TySo, Doi1, Doi2
 * ChiTietTySo:  idChiTietTySo, idTranDau, Phut, DoiBong, TenCauThu, TySo
 */
include('../simplehtmldom/simple_html_dom.php');
//<< 1- Ket noi DB
include ('db_config.php');
$conn = mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD) or die("Can't connect this database");
mysql_select_db(DB_DATABASE, $conn);
mysql_set_charset('utf8',$conn);
//>> 1- Ket noi DB

// << 2- Them vao bang trandaulivescore
$linkToday = "http://www.livescore.com";
$html = file_get_html($linkToday);
foreach($html->find('div[class="cal"]') as $e) {
    $strHtml=str_get_html($e->innertext);
    foreach($strHtml->find('a') as $e) {
        $Date = trim($e->plaintext);
        $Link = "http://www.livescore.com" . trim($e->href);
        if ($Date=="Today"){
            $linkToday = $Link;
            break;
        }
    }
    break;
}

$html = file_get_html($linkToday);

foreach($html->find('div[class="content"]') as $e) {
    $content=$e->innertext;
}

$strhtml=str_get_html($content);
$html = $strhtml;

$j=0;
$mangLink=array();
foreach($html->find('table[class="league-table"]') as $e) {
    $j++;
    echo "<br>j=$j------------------------------------------------<br>";
    $GiaiDau="";
    $BangDau="";
    $Ngay="";
    $arrTrangThai=array();
    $arrTySo=array();
    $arrLink=array();
    $arrDoi1=array();
    $arrDoi2=array();
    $chtml =  str_get_html($e->innertext);
    foreach($chtml->find('span[class="league"]') as $e) {
        $str = trim($e->plaintext);
        $arr = explode("-", $str);
        $GiaiDau=trim($arr[0]);
        $BangDau=trim($arr[1]);
        break;
    }

    foreach($chtml->find('td[class="fd"]') as $e) {
        $TrangThai = trim($e->plaintext);
        array_push($arrTrangThai,$TrangThai);
    }
    foreach($chtml->find('td[class="fs"]') as $e) {
        $TySo = trim($e->plaintext);
        array_push($arrTySo,$TySo);
        $flag=0;
        $a = $e->innertext;
        $ahtml = str_get_html($a);
        foreach($ahtml->find('a') as $ae) {
            $Link = "http://www.livescore.com" . trim($ae->href);
            array_push($arrLink,$Link);
            array_push($mangLink,$Link);
            $flag=1;
            break;
        }
        if($flag==0){
            $Link = "";
            array_push($arrLink,$Link);
        }
    }
    foreach($chtml->find('td[class="fh"]') as $e) {
        $Doi1 = trim($e->plaintext);
        array_push($arrDoi1,$Doi1);
    }
    foreach($chtml->find('td[class="fa"]') as $e) {
        $Doi2 = trim($e->plaintext);
        array_push($arrDoi2,$Doi2);
    }
    $count = count($arrTySo);
    $Ngay = str_replace("http://www.livescore.com/soccer/","",$linkToday);
    $Ngay = str_replace("/","",$Ngay);
    for ($i=0;$i<$count;$i++){
        $TrangThai = $arrTrangThai[$i];
        $TySo = $arrTySo[$i];
        $Link = $arrLink[$i];
        $Doi1 = $arrDoi1[$i];
        $Doi2 = $arrDoi2[$i];
        echo "$i: $GiaiDau - $BangDau - $Ngay - $TrangThai - $Doi1 - $TySo - $Doi2 -$Link<br>";

        $sqlSelectTranDau = "SELECT * FROM `trandaulivescore` WHERE
                            `GiaiDau`= '$GiaiDau' AND `BangDau`='$BangDau' AND `Doi1`='$Doi1' AND `Doi2`='$Doi2' AND `Ngay`='$Ngay';";
        $resultSelect = mysql_query($sqlSelectTranDau);
        if ($resultSelect) {
            $dem = 0; // = 0 la Insert, = 1 la Update
            while ($row = mysql_fetch_array($resultSelect)) {
                $dem = 1;
                $idTranDau   = $row["idTranDau"];
                $sqlUpdateTranDau = "UPDATE  `tivi`.`trandaulivescore` SET  `GiaiDau` =  '$GiaiDau',
                                     `BangDau` =  '$BangDau',
                                     `Doi1` =  '$Doi1',
                                     `Doi2` =  '$Doi2',
                                     `Ngay` =  '$Ngay',
                                     `TrangThai` =  '$TrangThai',
                                     `TySo` =  '$TySo',
                                     `Link` =  '$Link' WHERE  `trandaulivescore`.`idTranDau` =$idTranDau;";
                echo $sqlUpdateTranDau . "<br>";
                mysql_query($sqlUpdateTranDau);
            }
            if ($dem == 0){
                $sqlInsertTranDau = "INSERT INTO `tivi`.`trandaulivescore` (`GiaiDau`, `BangDau`, `Doi1`, `Doi2`, `Ngay`, `TrangThai`, `TySo`, `Link`)
                                                                    VALUES ('$GiaiDau', '$BangDau', '$Doi1', '$Doi2', '$Ngay', '$TrangThai', '$TySo', '$Link');";
                echo $sqlInsertTranDau . "<br>";
                mysql_query($sqlInsertTranDau);
            }
        } else {
            echo "<br>Sai cau lenh SQL<br>";
        }
    }
}
// >> 2- Them vao bang trandaulivescore

echo "<br>thieumao<br><br>-------------------------------------------------------------<br>";

$count = count($mangLink);
for ($m=0;$m<$count;$m++){
    echo $m . " : " . $mangLink[$m] . "<br>";
    $linkTySo = $mangLink[$m];
    //$linkTySo="http://www.livescore.com/soccer/england/blue-square-south/havant-and-w--vs-dover/1-1496036/";
    $html = file_get_html($linkTySo);
    $i=0;
    foreach($html->find('span[class="team"]') as $e) {
        $i++;
        if ($i==1){
            $Doi1 = trim($e->plaintext);
        }
        if ($i==2){
            $Doi2 = trim($e->plaintext);
            break;
        }
    }
    foreach($html->find('tr') as $e) {
        $chtml =  str_get_html($e->innertext);
        $Phut = "";
        $TySo = "";
        $leftname = "";
        $rightname = "";
        foreach($chtml->find('td[class="min"]') as $e) {
            $Phut = trim($e->plaintext);
            break;
        }
        foreach($chtml->find('td[class="sco"]') as $e) {
            $TySo = trim($e->plaintext);
            break;
        }
        foreach($chtml->find('span[class="left name"]') as $e) {
            $leftname = trim($e->plaintext);
            break;
        }
        foreach($chtml->find('span[class="right name"]') as $e) {
            $rightname = trim($e->plaintext);
            break;
        }
        if (strlen($Phut)>0 && strlen($TySo)>0){
            $TenCauThu = $leftname;
            $DoiBong = $Doi2;
            if (strlen($leftname) < strlen($rightname)){
                $TenCauThu = $rightname;
                $DoiBong = $Doi1;
            }
            $Link = $linkTySo;
            echo "Min=$Phut SCO=$TySo : $TenCauThu - $DoiBong - $Link<br>";
            // them vao bang chitiettysolivescore
            $conn = mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD) or die("Can't connect this database");
            mysql_select_db(DB_DATABASE, $conn);
            mysql_set_charset('utf8',$conn);
            $sqlSelectTySo = "SELECT * FROM `chitiettysolivescore` WHERE `Phut`='". addslashes($Phut)."' AND `DoiBong`='$DoiBong' AND `TenCauThu`='$TenCauThu' AND `TySo`='$TySo' AND `Link`='$Link';";
            echo "Lenh select: " . $sqlSelectTySo . "<br>";
            $resultSelectTySo = mysql_query($sqlSelectTySo);
            if ($resultSelectTySo) {
                $dem = 0; // = 0 la Insert, = 1 la Update
                while ($row = mysql_fetch_array($resultSelect)) {
                    $dem = 1;
                    $idChiTietTySo = $row['idChiTietTySo'];
                    $sqlUpdateTySo = "UPDATE  `tivi`.`chitiettysolivescore` SET
                                     `Phut` =  '". addslashes($Phut)."',
                                     `DoiBong` =  '$DoiBong',
                                     `TenCauThu` =  '$TenCauThu',
                                     `TySo` =  '$TySo',
                                     `Link` =  '$Link'
                                     WHERE  `trandaulivescore`.`idChiTietTySo` =$idChiTietTySo;";
                    echo $sqlUpdateTySo . "<br>";
                    mysql_query($sqlUpdateTySo);
                }
                if ($dem == 0){
                    $sqlInsertTySo = "INSERT INTO `tivi`.`chitiettysolivescore` (`Phut`, `DoiBong`, `TenCauThu`, `TySo`, `Link`) VALUES ('". addslashes($Phut)."', '$DoiBong', '$TenCauThu', '$TySo', '$Link');";
                    echo $sqlInsertTySo . "<br>";
                    mysql_query($sqlInsertTySo);
                }
            } else {
                echo "<br>Sai cau lenh SQL2<br>";
            }
        }
    }
}
?>