PHP load_json_to_db示例

示例#1

文件： utils.php 项目： rokity/mashape-api

function find_for_tags()
{
    $response = check_table_exist(strtolower($_GET['parameter']));
    if ($response == "FALSE") {
        $array = parse('https://www.mashape.com/explore' . switch_type($_GET['type']) . $_GET['parameter']);
        create_table(strtolower($_GET['parameter']), $array);
        echo json_encode($array);
    } else {
        $date = date("Y/m/d");
        $diff = get_count_days(strtolower($_GET['parameter']), $date);
        //  echo "diff".$diff;
        if ($diff > 6) {
            $array = parse('https://www.mashape.com/explore' . switch_type($_GET['type']) . $_GET['parameter']);
            $table = $_GET['parameter'];
            load_json_to_db($table, $array);
            echo json_encode($array);
        } else {
            $array = read_from_cache(strtolower($_GET['parameter']));
            echo json_encode($array);
        }
    }
}

示例#2

文件： configure.php 项目： rokity/mashape-api

function create_table($tag, $array)
{
    $servername = "mysql4.000webhost.com";
    $username = "******";
    $password = "******";
    $dbname = "a2124875_cache";
    $conn = new mysqli($servername, $username, $password, $dbname);
    $sql = "CREATE TABLE " . $tag . " (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,name LONGTEXT NOT NULL,owner LONGTEXT NOT NULL,image_owner LONGTEXT NOT NULL,image_api LONGTEXT NOT NULL,description LONGTEXT NOT NULL,prices LONGTEXT NOT NULL,links LONGTEXT NOT NULL,data LONGTEXT NOT NULL)";
    if ($conn->query($sql) === TRUE) {
        //  echo "Table MyGuests created successfully";
    } else {
        echo "Error creating table: " . $conn->error;
    }
    load_json_to_db($tag, $array);
    $conn->close();
}