本文整理匯總了PHP中SqlHelper::conn方法的典型用法代碼示例。如果您正苦於以下問題：PHP SqlHelper::conn方法的具體用法？PHP SqlHelper::conn怎麽用？PHP SqlHelper::conn使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類SqlHelper的用法示例。
在下文中一共展示了SqlHelper::conn方法的5個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: update
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;
}示例2: record2DB
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;
}示例3: statistic
/**
* 統計數據
* @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);
}示例4: SqlHelper
<?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/>";
}示例5: get_rank
/**
* 獲取排行榜
* @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;
}