function SaeMySQLSelectCell($SQL)
{
$result = mysql_query($SQL);
//2006和2013错误则重试一次
if (!$result && in_array(mysql_errno(), array(2006, 2013))) {
SaeMySQLDisconnect();
SaeMySQLConnect();
$result = mysql_query($SQL);
}
if (!$result) {
return false;
}
$row = mysql_fetch_row($result);
if (!$row) {
return false;
}
ResultTransform($row);
$row = $row[0];
return $row;
}
$value = array(array("order_id"=>$order_id,"information"=>$information,"stamp"=>$stamp,"time"=>$time));
if(SaeMemcacheSet($key,$value)===false){
MyError("Memcache写入失败");
}
}
else{
$value[] = array("order_id"=>$order_id,"information"=>$information,"stamp"=>$stamp,"time"=>$time);
if(SaeMemcacheSet($key,$value)===false){
MyError("Memcache写入失败");
}
}
*/
//写法2：
$value = array(array("order_id" => $order_id, "information" => $information, "stamp" => $stamp, "time" => $time));
if (SaeMemcacheAdd($key, $value) === false) {
$value = array("order_id" => $order_id, "information" => $information, "stamp" => $stamp, "time" => $time);
if (SaeMemcacheAppendArray($key, $value) === false) {
MyError("Memcache写入失败");
}
}
$login_stamp = time();
$login_time = "'" . date("Y-m-d H:i:s", $login_stamp) . "'";
if (SaeMySQLConnect() === false) {
MyError("数据库连接失败");
}
$SQL = "UPDATE `user_info`\nSET `user_info`.`last_login_time` = {$login_time}, `user_info`.`last_login_stamp` = {$login_stamp}\nWHERE `user_info`.`id` = {$user_id}\n";
if (SaeMySQLTryUpdate($SQL) === false) {
MyError("数据库更新失败");
}
SaeMySQLDisconnect();
MySuccess("信息发送完成");
<?php
//示例（创建数据库表）
include '../SaeMySQL.php';
header('Content-Type:text/html;charset=utf-8');
if (SaeMySQLConnect()) {
echo '数据库连接成功……<br />';
} else {
echo '数据库连接失败，错误代码：' . mysql_errno() . ' 错误原因：' . mysql_error() . '<br />';
}
$tableName = "user_info";
$SQL = "create table " . $tableName . "(\nid int unsigned not null auto_increment primary key,\nname char(60) not null unique,\npassword char(60) not null,\nregister_time datetime not null,\nlast_login_time datetime not null,\nlast_login_stamp int unsigned not null,\nindex (password),\nindex (register_time),\nindex (last_login_time),\nindex (last_login_stamp)\n)";
$tableName .= "【用户信息】";
if (SaeMySQLCreateTable($SQL)) {
echo "数据表" . $tableName . "创建成功……<br />";
} else {
if (mysql_errno() == "1050") {
echo "数据表" . $tableName . "已经存在……<br />";
} else {
echo "创建数据表" . $tableName . "失败，错误代码：" . mysql_errno() . " 错误原因：" . mysql_error() . "<br />";
}
}
SaeMySQLDisconnect();
