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); } } }
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(); }