select tid,molds,pid,classname,gourl,litpic,litpic1,title,keywords,description,orders,mrank,htmldir,htmlfile,mshow,enclassname from dy_classtype wheretid='1' and mshow='1'order by orders desc,tid
执行错误: 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 '='1' and mshow='1'order by orders desc,tid' at line 1
- /usr/home/qxu1649890337/htdocs/include/mysql.php on line 39
34.
$this->arrSql[] = $sql;
35.
if( $result = mysql_query($sql, $this->conn) ){
36.
return $result;
37.
}else{
38.
if(mysql_error()!=''){
39.
40.
syError("{$sql}<br />执行错误: " . mysql_error());
}else{
41.
return TRUE;
42.
}
43.
}
44.
}
- /usr/home/qxu1649890337/htdocs/include/mysql.php on line 8
3.
class db_mysql {
4.
public $conn;
5.
public $arrSql;
6.
public function getArray($sql)
7.
{
8.
9.
if( ! $result = $this->exec($sql) )return array();
if( ! mysql_num_rows($result) )return array();
10.
$rows = array();
11.
while($rows[] = mysql_fetch_array($result,MYSQL_ASSOC)){}
12.
mysql_free_result($result);
13.
array_pop($rows);
- /usr/home/qxu1649890337/htdocs/include/syModel.php on line 124
119.
return $this->update($conditions, array($field=>$value));
120.
}
121.
122.
public function findSql($sql)
123.
{
124.
125.
return $this->_db->getArray($sql);
}
126.
127.
public function runSql($sql)
128.
{
129.
return $this->_db->exec($sql);
- /usr/home/qxu1649890337/htdocs/include/cache/tpl/message_message.php on line 34
29.
<div class="nav">
30.
<div class="header">
31.
<div class="menu">
32.
<ul>
33.
<li class="top_menu home"><a href="/">Home</a></li>
34.
35.
<?php $vn=0;$tablev=syClass("syModel")->findSql("select tid,molds,pid,classname,gourl,litpic,litpic1,title,keywords,description,orders,mrank,htmldir,htmlfile,mshow,enclassname from dy_classtype wheretid='1' and mshow='1'order by orders desc,tid");foreach($tablev as $v){ $v["tid_leafid"]=$sy_class_type->leafid($v["tid"]);$v["n"]=$vn=$vn+1; $v["classname"]=stripslashes($v["classname"]);$v["description"]=stripslashes($v["description"]); $v["url"]=html_url("classtype",$v); ?>
<li class="top_menu"><a href="<?php echo disablewords($v['url']) ?>"><?php echo disablewords($v['classname']) ?></a>
36.
<ul class="son_menu">
37.
<?php $v1n=0;$tablev1=syClass("syModel")->findSql("select tid,molds,pid,classname,gourl,litpic,litpic1,title,keywords,description,orders,mrank,htmldir,htmlfile,mshow,enclassname from dy_classtype wherepid='".$v[tid]."'order by orders desc,tid");foreach($tablev1 as $v1){ $v1["tid_leafid"]=$sy_class_type->leafid($v1["tid"]);$v1["n"]=$v1n=$v1n+1; $v1["classname"]=stripslashes($v1["classname"]);$v1["description"]=stripslashes($v1["description"]); $v1["url"]=html_url("classtype",$v1); ?>
38.
<li><a href=" <?php echo disablewords($v1['url']) ?>"><?php echo disablewords($v1['classname']) ?></a></li>
39.
<?php } ?>
- /usr/home/qxu1649890337/htdocs/include/Template.php on line 69
64.
if( $enable_gzip==1 ){
65.
GLOBAL $__template_compression_level;
66.
$__template_compression_level=syExt('enable_gzip_level');
67.
ob_start('template_ob_gzip');
68.
}
69.
70.
include $template_tpl;
}
71.
72.
private function template_html($content){
73.
preg_match_all('/\{include=\"(.*?)\"\}/si',$content,$i);
74.
foreach($i[0] as $k=>$v){
- /usr/home/qxu1649890337/htdocs/include/syView.php on line 28
23.
{
24.
try {
25.
$this->addfuncs();
26.
$this->displayed = TRUE;
27.
if($GLOBALS['G_DY']['view']['debugging'] && SP_DEBUG)$this->engine->debugging = TRUE;
28.
29.
$this->engine->display($tplname);
} catch (Exception $e) {
30.
syError( $GLOBALS['G_DY']['view']['engine_name']. ' Error: '.$e->getMessage() );
31.
}
32.
}
33.
- /usr/home/qxu1649890337/htdocs/include/syController.php on line 30
25.
26.
public function display($tplname, $output = TRUE)
27.
{
28.
@ob_start();
29.
if(TRUE == $GLOBALS['G_DY']['view']['enabled']){
30.
31.
$this->v->display($tplname);
}else{
32.
extract($this->__template_vals);
33.
require($tplname);
34.
}
35.
if( TRUE != $output )return ob_get_clean();
- /usr/home/qxu1649890337/htdocs/source/message.php on line 53
48.
49.
$this->positions='<a href="'.$GLOBALS["WWW"].'">home</a>';
50.
foreach($this->sy_class_type->navi($this->syArgs('tid')) as $v){
51.
$this->positions.=' > '.$v['classname'];
52.
}
53.
54.
$this->display('message/'.$t);
}
55.
function add(){
56.
if($GLOBALS['G_DY']['vercode']==1){
57.
if(!$this->syArgs("vercode",1)||md5(strtolower($this->syArgs("vercode",1)))!=$_SESSION['doyo_verify'])message("验证码错误");
58.
}
- /usr/home/qxu1649890337/htdocs/index.php on line 5
1.
<?php
2.
require("config.php");
3.
$doyoConfig['view']['config']['template_dir'] = APP_PATH.'/template/'.$doyoConfig['ext']['view_themes'];
4.
require(DOYO_PATH."/sys.php");
5.
spRun();