Example #1
0
	$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("信息发送完成");
Example #2
0
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;
}