private function update($gameId, $player_name) { $st = new SqlHelper(); $sql = "UPDATE tbl_player SET player_name='{$player_name}',last_login_utc=UNIX_TIMESTAMP(NOW()), last_login_date = NOW() WHERE game_id={$gameId}"; $st->conn(); $result = $st->modify($sql); $st->close(); return $result; }
private function record2DB($openid, $qList) { $sql = "INSERT INTO tbl_feedback VALUES('{$openid}',NOW(),'{$qList['0']}','{$qList['1']}','{$qList['2']}','{$qList['3']}','{$qList['4']}','{$qList['5']}','{$qList['6']}','{$qList['7']}');"; $st = new SqlHelper(); $st->conn(); $result = $st->modify($sql); $st->close(); return $result; }
/** * 统计数据 * @param $params * @param $res */ public function statistic(&$params, &$res) { $content = mysql_escape_string($params->content); $sql = "INSERT INTO tbl_statistic(content, count) VALUES('%s', 1) ON DUPLICATE KEY UPDATE count = count + 1;"; $sql = sprintf($sql, $content); $sqlHelper = new SqlHelper(); $sqlHelper->conn(); $sqlHelper->modify($sql); }
<?php /** * Created by PhpStorm. * User: Jing * Date: 2015/4/8 * Time: 23:21 */ include './configs/define.php'; include "./utils/sql_helper.php"; $sqlHelper = new SqlHelper(); $sqlHelper->conn(); $result = $sqlHelper->query("SELECT * FROM tbl_statistic"); foreach ($result as $v) { echo $v["content"] . ':' . $v["count"] . "<br/>"; }
/** * 获取排行榜 * @param $params * @param $res */ public function get_rank(&$params, &$res) { $st = new SqlHelper(); $data = array(); $data['self'] = 1; $id = mysql_escape_string($params->id); $sql = "SELECT COUNT(*) AS position FROM tbl_user WHERE total_score > (SELECT total_score FROM tbl_user WHERE id = '%s')"; $sql = sprintf($sql, $id); $st->conn(); $result = $st->query($sql); $data['self'] = $result[0]['position']; $st->close(); $sql = "SELECT id,name,pic,total_score FROM tbl_user ORDER BY total_score DESC LIMIT 0,20"; $st->conn(); $result = $st->query($sql); $st->close(); $data['list'] = $result; $res['data'] = $data; return $result; }