<?php
$con = mysql_connect("127.0.0.1", "root", "htjxo2o168");
if (!$con) die('Could not connect: ' . mysql_error());
mysql_set_charset('utf8', $con);
mysql_select_db("drivingschool", $con);
function db_query($sql) {
$table = array();
$result = mysql_query($sql);
if ($result) {
while($row = mysql_fetch_assoc($result)) {
$table[] = $row;
}
}
return $table;
}
function db_insert($table, $dbArr) {
$sql = "insert into " . $table . "(" . implode(", ", array_keys($dbArr)) . ") values('" . implode("', '", array_values($dbArr)) . "')";
log_text($sql);
mysql_query($sql);
}
function db_update($table, $id, $dbArr) {
$sql_con = '';
while (list($key, $val) = each($dbArr)) {
if (!empty($val)) {
if (strpos($val, $key) === false) {
//在赋的值中没有找到键名
$sql_con .= ", " . $key . " = '" . $val . "'";
} else {
//统计字段,字段自增或自减,不加单引号
$sql_con .= ", " . $key . " = " . $val;
}
}
}
$sql = "update " . $table . " set " . substr($sql_con, 2) . " where id = '$id'"; log_text($sql);
mysql_query($sql);
}
/**
* 写日志,方便测试(看网站需求,也可以改成把记录存入数据库)
* 注意:服务器需要开通fopen配置
* @param $word 要写入日志里的文本内容 默认值:空值
*/
function log_text($word='') {
$fp = fopen("log.txt","a");
flock($fp, LOCK_EX) ;
fwrite($fp,"执行日期:".strftime("%Y%m%d%H%M%S",time())."\n".$word."\n");
flock($fp, LOCK_UN);
fclose($fp);
}
// 以下两个函数处理json_encode中文乱码问题
function arrayRecursive(&$array) {
foreach ($array as $key => $value) {
if (is_array($value)) {
arrayRecursive($array[$key]); //如果是数组就进行递归操作
} else {
if(is_string($value)){
$temp1 = addslashes($value);
$array[$key] = urlencode($temp1); //如果是字符串就urlencode
} else {
$array[$key] = $value;
}
}
}
}
function JSON($array) {
arrayRecursive($array); //先将类型为字符串的数据进行 urlencode
$json = json_encode($array); //再将数组转成JSON
return urldecode($json); //最后将JSON字符串进行urldecode
}
?>
$con = mysql_connect("127.0.0.1", "root", "htjxo2o168");
if (!$con) die('Could not connect: ' . mysql_error());
mysql_set_charset('utf8', $con);
mysql_select_db("drivingschool", $con);
function db_query($sql) {
$table = array();
$result = mysql_query($sql);
if ($result) {
while($row = mysql_fetch_assoc($result)) {
$table[] = $row;
}
}
return $table;
}
function db_insert($table, $dbArr) {
$sql = "insert into " . $table . "(" . implode(", ", array_keys($dbArr)) . ") values('" . implode("', '", array_values($dbArr)) . "')";
log_text($sql);
mysql_query($sql);
}
function db_update($table, $id, $dbArr) {
$sql_con = '';
while (list($key, $val) = each($dbArr)) {
if (!empty($val)) {
if (strpos($val, $key) === false) {
//在赋的值中没有找到键名
$sql_con .= ", " . $key . " = '" . $val . "'";
} else {
//统计字段,字段自增或自减,不加单引号
$sql_con .= ", " . $key . " = " . $val;
}
}
}
$sql = "update " . $table . " set " . substr($sql_con, 2) . " where id = '$id'"; log_text($sql);
mysql_query($sql);
}
/**
* 写日志,方便测试(看网站需求,也可以改成把记录存入数据库)
* 注意:服务器需要开通fopen配置
* @param $word 要写入日志里的文本内容 默认值:空值
*/
function log_text($word='') {
$fp = fopen("log.txt","a");
flock($fp, LOCK_EX) ;
fwrite($fp,"执行日期:".strftime("%Y%m%d%H%M%S",time())."\n".$word."\n");
flock($fp, LOCK_UN);
fclose($fp);
}
// 以下两个函数处理json_encode中文乱码问题
function arrayRecursive(&$array) {
foreach ($array as $key => $value) {
if (is_array($value)) {
arrayRecursive($array[$key]); //如果是数组就进行递归操作
} else {
if(is_string($value)){
$temp1 = addslashes($value);
$array[$key] = urlencode($temp1); //如果是字符串就urlencode
} else {
$array[$key] = $value;
}
}
}
}
function JSON($array) {
arrayRecursive($array); //先将类型为字符串的数据进行 urlencode
$json = json_encode($array); //再将数组转成JSON
return urldecode($json); //最后将JSON字符串进行urldecode
}
?>