这篇会比较短,只给一个SAE中saemysql的例子,很简单。由于忽然改变主意,暂时不打算把这个应用在新浪微博上线,所以这个直播流程暂时到此为止。
首先要引用新浪提供的saemysql:
include_once('saemysql.php');
然后就可以像下面这样使用了:
$mysql = new SaeMysql(); $sql = "SELECT * FROM userdata where openid like " . "'" . $openid ."'"; $data = $mysql->getData( $sql ); if(is_null($data)) { $sql = "INSERT INTO userdata (openid,openkey) VALUES ( '".$openid."','" . $openkey . "'" . "')"; $mysql->runSql( $sql ); if( $mysql->errno() != 0 ) { die( "Error:" . $mysql->errmsg() ); } $sql = "SELECT * FROM userdata where openid like " . "'" . $openid ."'"; $data = $mysql->getData( $sql ); $row = $data[0]; $uid = $row['uid'] ; } else {
$uid = $row['uid'] ;
}$mysql->closeDb();
大体如此。反正我觉得挺简单的。