SELECT * FROM vn_volunteer WHERE id = ORDER BY id LIMIT 1
执行错误: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY id LIMIT 1' at line 1
- /www/wwwroot/hlva.zgdshys.com/Comm/MyFrame/Drivers/mysql.php on line 62
57.
{
58.
$this->arrSql[] = $sql;
59.
if( $result = mysql_query($sql, $this->conn) ){
60.
return $result;
61.
}else{
62.
63.
spError("{$sql}<br />执行错误: " . mysql_error());
}
64.
}
65.
66.
/**
67.
* 返回影响行数
- /www/wwwroot/hlva.zgdshys.com/Comm/MyFrame/Drivers/mysql.php on line 26
21.
*
22.
* @param sql 执行的SQL语句
23.
*/
24.
public function getArray($sql)
25.
{
26.
27.
if( ! $result = $this->exec($sql) )return array();
if( ! mysql_num_rows($result) )return array();
28.
$rows = array();
29.
while($rows[] = mysql_fetch_array($result,MYSQL_ASSOC)){}
30.
mysql_free_result($result);
31.
array_pop($rows);
- /www/wwwroot/hlva.zgdshys.com/Comm/MyFrame/Core/spModel.php on line 103
98.
}else{
99.
$sort = "ORDER BY {$this->pk}";
100.
}
101.
$sql = "SELECT {$fields} FROM {$this->tbl_name} {$where} {$sort}";
102.
if(null != $limit)$sql = $this->_db->setlimit($sql, $limit);
103.
104.
return $this->_db->getArray($sql);
}
105.
/**
106.
* 过滤转义字符
107.
*
108.
* @param value 需要进行过滤的值
- /www/wwwroot/hlva.zgdshys.com/Comm/MyFrame/Core/spModel.php on line 65
60.
* @param sort 排序,等同于“ORDER BY ”
61.
* @param fields 返回的字段范围,默认为返回全部字段的值
62.
*/
63.
public function find($conditions = null, $sort = null, $fields = null)
64.
{
65.
66.
if( $record = $this->findAll($conditions, $sort, $fields, 1) ){
return array_pop($record);
67.
}else{
68.
return FALSE;
69.
}
70.
}
- /www/wwwroot/hlva.zgdshys.com/Comm/MyFrame/Core/spModel.php on line 770
765.
public function __call($func_name, $func_args){
766.
if( in_array( $func_name, $this->methods ) && FALSE != $this->enabled ){
767.
if( 'delete' == $func_name || 'deleteByPk' == $func_name )$maprecords = $this->prepare_delete($func_name, $func_args);
768.
if( null != $this->run_result ){
769.
$run_result = $this->run_result;
770.
771.
}elseif( !$run_result = call_user_func_array(array($this->model_obj, $func_name), $func_args) ){
if( 'update' != $func_name )return FALSE;
772.
}
773.
if( null != $this->model_obj->linker && is_array($this->model_obj->linker) ){
774.
foreach( $this->model_obj->linker as $linkey => $thelinker ){
775.
if( !isset($thelinker['map']) )$thelinker['map'] = $linkey;
- /www/wwwroot/hlva.zgdshys.com/Action/home.php on line 637
632.
if(!isset($_SESSION['user'])){
633.
echo '<script>alert("请先登录!");location.href="/userlogin.html";</script>';
634.
}
635.
$this->uid = 1;
636.
$condition = "id = ".$_SESSION['user']['id'];
637.
638.
$this->userinfo = spClass('m_user')->spLinker()->find($condition);
// $condition = "volunteer_id = ".$_SESSION['user']['id'];
639.
// $this->alltime = $bb = spClass('m_acvol')->findAll($condition);
640.
// $sum = 0;
641.
// for ($i = 0; $i < count($bb); $i++) {
642.
// $sum += $bb[$i]['ser_time'];
- /www/wwwroot/hlva.zgdshys.com/Action/home.php on line 637
632.
if(!isset($_SESSION['user'])){
633.
echo '<script>alert("请先登录!");location.href="/userlogin.html";</script>';
634.
}
635.
$this->uid = 1;
636.
$condition = "id = ".$_SESSION['user']['id'];
637.
638.
$this->userinfo = spClass('m_user')->spLinker()->find($condition);
// $condition = "volunteer_id = ".$_SESSION['user']['id'];
639.
// $this->alltime = $bb = spClass('m_acvol')->findAll($condition);
640.
// $sum = 0;
641.
// for ($i = 0; $i < count($bb); $i++) {
642.
// $sum += $bb[$i]['ser_time'];
- /www/wwwroot/hlva.zgdshys.com/Comm/MyFrame/spFunctions.php on line 32
27.
}else{
28.
spClass('m_conf')->update(array('id'=>1),array('yuefen'=>date('Y-m')));
29.
}
30.
}
31.
// 路由并执行用户代码
32.
33.
$handle_controller->$__action();
// 控制器程序运行完毕,进行模板的自动输出
34.
if(FALSE != $GLOBALS['G_SP']['view']['auto_display']){
35.
$__tplname = $__controller.$GLOBALS['G_SP']['view']['auto_display_sep'].
36.
$__action.$GLOBALS['G_SP']['view']['auto_display_suffix']; // 拼装模板路径
37.
$handle_controller->auto_display($__tplname);
- /www/wwwroot/hlva.zgdshys.com/index.php on line 13
8.
require('config.php');
9.
//加载框架核心
10.
require(SP_PATH.'/SpeedPHP.php');
11.
require('functions.php');
12.
//执行应用
13.
14.
spRun();
?>