Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //<< 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);
- //>> Ket noi DB
- $url="http://services.bongda.hay.la/ServiceMobiTV.svc/GetChiTietTranDau?tranDauID=1310229727";
- $json = file_get_contents($url);
- $data = json_decode($json, TRUE);
- // mang Feed
- $Feed = $data['Feed'];
- for ($i=0;$i<count($Feed);$i++){
- $iFeed = $Feed[$i];
- $ChiTietTranDauID = $iFeed['ChiTietTranDauID'];
- $DoiBong = $iFeed['DoiBong'];
- $HiepDau = $iFeed['HiepDau'];
- $MoTaChiTietID = $iFeed['MoTaChiTietID'];
- $Phut = $iFeed['Phut'];
- $TenCauThu = $iFeed['TenCauThu'];
- $TenCauThuChuyen = $iFeed['TenCauThuChuyen'];
- $TiSo = $iFeed['TiSo'];
- $TranDauID = $iFeed['TranDauID'];
- //echo ra man hinh
- echo "i= " . $i . "<br>";
- echo "1. ChiTietTranDauID $ChiTietTranDauID <br>";
- echo "2. DoiBong $DoiBong <br>";
- echo "3. HiepDau $HiepDau <br>";
- echo "4. MoTaChiTietID $MoTaChiTietID <br>";
- echo "5. Phut $Phut <br>";
- echo "6. TenCauThu $TenCauThu <br>";
- echo "7. TenCauThuChuyen $TenCauThuChuyen <br>";
- echo "8. TiSo $TiSo <br>";
- echo "9. TranDauID $TranDauID <br>";
- $sql2 = "INSERT INTO `tivi`.`ChiTietTranDau` (`ChiTietTranDauID`, `DoiBong`, `HiepDau`, `MoTaChiTietID`, `Phut`, `TenCauThu`, `TenCauThuChuyen`, `TiSo`, `TranDauID`)
- VALUES ('$ChiTietTranDauID', '$DoiBong', '$HiepDau', '$MoTaChiTietID', '$Phut', '$TenCauThu', '$TenCauThuChuyen', '$TiSo', '$TranDauID');";
- echo $sql2;
- mysql_query($sql2);
- echo "<br>-----------<br>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment