query($sql) === TRUE) {$return_array = array(status=>1);
header('Content-type: text/json');
echo json_encode($return_array);
die();} else {echo json_encode(array(status=>"Error: " . $sql . "
" . $conn->error));}
?>
connect_error)
{
die("连接失败: " . $conn->connect_error);
}
return ($conn);
}
//fnct of get table row number::(data_cnnct var,table name) ::(row number)
function sql_rowNum($conn,$tableSql)
{
$row_count = $conn->query("SELECT COUNT(*) FROM $tableSql");
list($row_num) = $row_count->fetch_row();
return ($row_num);
}
//fnct of getting row data from database::(data_cnnct var, table name,column name, column value)::(row info)
function sql_data($conn,$table,$clmnName,$value)
{
$sql = "SELECT * FROM $table where $clmnName=$value";
$result = $conn->query($sql);
///禁止非法访问
if ($result->num_rows > 0) {}else{echo "";}
$row = $result->fetch_assoc();
return ($row);
}
function array_orderby()
{
$args = func_get_args();
$data = array_shift($args);
foreach ($args as $n => $field) {
if (is_string($field)) {
$tmp = array();
foreach ($data as $key => $row)
$tmp[$key] = $row[$field];
$args[$n] = $tmp;
}
}
$args[] = &$data;
call_user_func_array('array_multisort', $args);
return array_pop($args);
}
?>