getFilm.php

<?php
header('Content-Type: text/html; charset=utf-8');
include 'Functions.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
$cat = "http://m.ssphim.com/?os=a&clid=f008e69160a0c9a1&t=a0641f84c3e95d03e4f5f84a269d8619&q=l&id=0A&offset=0";

//exit;
$mang = Functions::LinkJsonToArray($cat);
//print_r($mang);
$payload = $mang['payload'];
$count = count($payload);
//echo $count;
for ($i=0;$i<$count;$i++){
    //$iPayload = $payload[$i];
    $id = addslashes($payload[$i]['id']);
    $category = addslashes($payload[$i]['category']);
    $views = addslashes($payload[$i]['views']);
    $name = addslashes($payload[$i]['name']);
    $ngayphathanh = addslashes($payload[$i]['ngayphathanh']);
    $diemimdb = addslashes($payload[$i]['diemimdb']);
    $daodien = addslashes($payload[$i]['daodien']);
    $kichban = addslashes($payload[$i]['kichban']);
    $dienvienchinh = addslashes($payload[$i]['dienvienchinh']);
    $quocgia = addslashes($payload[$i]['quocgia']);
    $theloai = addslashes($payload[$i]['theloai']);
    $thoiluong = addslashes($payload[$i]['thoiluong']);
    $hinhanh = addslashes($payload[$i]['hinhanh']);
    $phude = addslashes($payload[$i]['phude']);
    $filmURL = addslashes($payload[$i]['filmURL']);
    $imgFullURL = addslashes($payload[$i]['imgFullURL']);
    $imgThumbURL = addslashes($payload[$i]['imgThumbURL']);

    $sql = "
        INSERT INTO `appfilm`.`phim` (`id`, `category`, `views`, `name`, `ngayphathanh`,
        `diemimdb`, `daodien`, `kichban`, `dienvienchinh`, `quocgia`, `theloai`, `thoiluong`,
        `hinhanh`, `phude`, `filmURL`, `imgFullURL`, `imgThumbURL`)
        VALUES ('$id', '$category', '$views', '$name', '$ngayphathanh',
        '$diemimdb', '$daodien', '$kichban', '$dienvienchinh', '$quocgia', '$theloai', '$thoiluong',
        '$hinhanh', '$phude', '$filmURL', '$imgFullURL', '$imgThumbURL');
    ";
    echo "$i - $id --> $sql<br>";
    mysql_query($sql);
}