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);
}
}
}
<html>
<head></head>
<body>
<?php
#create database and table;
header("content-type:text/html; charset=utf-8");
$connection = mysql_connect("localhost", "root", "szxy8426");
if (!$connection) {
die('Could not connect' . mysql_error());
}
if (!check_database_exist("nutrition")) {
mysql_query("create database nutrition", $connection);
}
$j = mysql_select_db("nutrition", $connection);
if (!check_table_exist("nutrition")) {
if (!$j) {
die("select db failed " . mysql_error());
}
$i = mysql_query("create table nutrition(type char(40),description varchar(120) ,per char(30),barcode char(15),energykj float(10,3),energykc float(10,3),protein float(10,3),carb float(10,3),sugar float(10,3),fat float(10,3),saturates float(10,3),fibre float(10,3),sodium float(10,3),hydrodised char(5))", $connection);
if (!$i) {
die("create failed " . mysql_error());
}
}
#read from .csv;
$file = fopen("./data/nutrition.csv", "r");
if (!$file) {
die('file open error');
}
$fieldname = fgetcsv($file);
$time = 0;
$temp = '';
