public static function create($topic_name, $topic_desc, $resource_name, $resource_desc, $resource_uri, $resource_type)
{
require_once 'data.php';
$sql = "INSERT INTO resources (name, description, source_type_id, uri)\n\t\t\t\t\tVALUES ('" . $resource_name . "','" . $resource_desc . "'," . $resource_type . ", '" . $resource_uri . "');";
put_data($sql);
$sql = "INSERT INTO topics (name, description) \n\t\t\t\t\tVALUES ('" . $topic_name . "','" . $topic_desc . "');";
put_data($sql);
$sql = "INSERT INTO topic_resource (topic_id, resource_id)\n\t\t\t\t\tVALUES ((SELECT id from topics where name = '" . $topic_name . "'), (SELECT id from resources where name = '" . $resource_name . "'))";
put_data($sql);
#echo($sql);
}
<?php
//include('../header.html');
define('IN_CODE', true);
include 'functions_main.php';
include 'functions.php';
$id = request_var('esp_id', 0);
$chan = request_var('esp_channel', 0);
$zone = request_var('esp_zone', 0);
$loca = request_var('esp_location', '');
$level = request_var('esp_rx_level', 0);
$batt = request_var('esp_batt', '');
$actives = request_var('esp_actives', 0);
$arr = array('esp_id' => isset($id) ? $id : 0, 'esp_chan' => isset($chan) ? $chan : 0, 'esp_zone' => isset($zone) ? $zone : 0, 'esp_location' => isset($loca) ? $loca : '', 'esp_rx_level' => isset($level) ? $level : 0, 'esp_batt' => isset($batt) ? $batt : 0, 'esp_actives' => isset($actives) ? $actives : 0);
put_data($arr);
//include('../footer.html');
$filename = 'data-' . SM_COUNT . '-' . COUNTRY_COUNT . '.json';
on_the_fly($redis);
exit;
if (GEN_DATA_ON_FLY) {
$data = generate_data();
$json_str = json_encode($data);
file_put_contents($filename, $json_str);
} else {
$json_str = file_get_contents($filename);
$data = json_decode($json_str, true);
}
$start_write_time = microtime(true);
if (USE_FILTER) {
put_filter_data($data, $redis);
} else {
put_data($data, $redis);
}
$write_time = microtime(true) - $start_write_time;
$start_read_time = microtime(true);
if (USE_FILTER) {
get_filter_data($data, $redis);
} else {
get_data($data, $redis);
}
$read_time = microtime(true) - $start_read_time;
if (USE_EXT) {
$redis->close();
}
if (VISUAL_MODE) {
echo "Write time: {$write_time}, read time: {$read_time}, memory usage: " . memory_get_usage();
} else {
