thieumao

themChiTietTranDau.php

Mar 14th, 2014
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.59 KB | None | 0 0
  1. <?php
  2. //<< Ket noi DB
  3. include ('db_config.php');
  4. $conn = mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD) or die("Can't connect this database");
  5. mysql_select_db(DB_DATABASE, $conn);
  6. mysql_set_charset('utf8',$conn);
  7. //>> Ket noi DB
  8.  
  9. $url="http://services.bongda.hay.la/ServiceMobiTV.svc/GetChiTietTranDau?tranDauID=1310229727";
  10.  
  11. $json = file_get_contents($url);
  12. $data = json_decode($json, TRUE);
  13. // mang Feed
  14. $Feed = $data['Feed'];
  15. for ($i=0;$i<count($Feed);$i++){
  16.     $iFeed = $Feed[$i];
  17.     $ChiTietTranDauID = $iFeed['ChiTietTranDauID'];
  18.     $DoiBong = $iFeed['DoiBong'];
  19.     $HiepDau = $iFeed['HiepDau'];
  20.     $MoTaChiTietID = $iFeed['MoTaChiTietID'];
  21.     $Phut = $iFeed['Phut'];
  22.     $TenCauThu = $iFeed['TenCauThu'];
  23.     $TenCauThuChuyen = $iFeed['TenCauThuChuyen'];
  24.     $TiSo = $iFeed['TiSo'];
  25.     $TranDauID = $iFeed['TranDauID'];
  26.    
  27.     //echo ra man hinh 
  28.     echo "i= " . $i . "<br>";
  29.     echo "1. ChiTietTranDauID $ChiTietTranDauID <br>";
  30.     echo "2. DoiBong $DoiBong <br>";
  31.     echo "3. HiepDau $HiepDau <br>";
  32.     echo "4. MoTaChiTietID $MoTaChiTietID <br>";
  33.     echo "5. Phut $Phut <br>";
  34.     echo "6. TenCauThu $TenCauThu <br>";
  35.     echo "7. TenCauThuChuyen $TenCauThuChuyen <br>";
  36.     echo "8. TiSo $TiSo <br>";
  37.     echo "9. TranDauID $TranDauID <br>";   
  38.  
  39.     $sql2 = "INSERT INTO `tivi`.`ChiTietTranDau` (`ChiTietTranDauID`, `DoiBong`, `HiepDau`, `MoTaChiTietID`, `Phut`, `TenCauThu`, `TenCauThuChuyen`, `TiSo`, `TranDauID`)
  40.             VALUES ('$ChiTietTranDauID', '$DoiBong', '$HiepDau', '$MoTaChiTietID', '$Phut', '$TenCauThu', '$TenCauThuChuyen', '$TiSo', '$TranDauID');";
  41.     echo $sql2;
  42.     mysql_query($sql2);
  43.  
  44.     echo "<br>-----------<br>";
  45.        
  46. }
  47. ?>
Advertisement
Add Comment
Please, Sign In to add comment