Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\vote\db.php on line 41Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\vote\db.php on line 45
<?php
//定义数据库操作类include_once("config.inc.php");class db{
private static $dbhost;
private static $dbuser;
private static $password;
private static $dbname;
private static $instance=NULL; private function __construct($host,$user,$pass,$db){
self::$dbhost = $host;
self::$dbuser = $user;
self::$password = $pass;
self::$dbname = $db;
self::createcon();
} public static function getInstance(){
if(self::$instance == NULL){
self::$instance = new db(DB_HOST, DB_USER, DB_PASS, DB_NAME);
}
return self::$instance;
} public static function createcon(){
mysql_connect(self::$dbhost,self::$dbuser,self::$password);//conect mysql
mysql_select_db(self::$dbname);//select
} public function fetch_array($aql){//根据SQL语句获取结果集
$result=$this->query($sql);//调用内部方法执行SQL语句
$rs = mysql_fetch_array($result);//从结果集获取数组
return $rs;
} public function query($sql){
mysql_query("set names 'gb2312'");
return mysql_fetch_array($sql);//返回结果值 41行
} public function loop_query($result){
return mysql_fetch_array($result);//从结果集return数组 45行 } public function close(){
return mysql_close();
}
}
?>
解决方案 »
- 刚从JAVA转行到PHP学习中,学习kohana3框架有点问题,请各位大侠关照。
- PHP 做计算题
- 用PHP作为服务端,向客户端推送信息如:新浪加粉的提示
- 安装下载的PHP源码 无法运行 求高手来帮忙 谢谢!
- 急,急,急,PHP 5.3.10上面Zend Optimizer无法安装成功
- php的小问题请高手来回答!
- 大家都用过什么开源邮件系统,请推荐一个!
- 关于 ecshop2.7的导航条问题
- thinkphp phpexcel无法导出文件,返回乱码
- SSL证书 APACHE 报错403
- php中的Fatal error: Call to undefined function ssh2_connect()问题!!!
- 大家在用哪款PHP框架?
我后面的调用是这样的:
$query1="select choice from vote_title where id=".$_GET["id"];
$result1=$db->query($query1);
$row1=$db->loop_query($result1);
public function query($sql){
mysql_query("set names 'gb2312'");
return mysql_query($sql); //修改为这样
}还有你的loop_query()函数缺少判断。如果结果集大于一条你是不是得循环啊?
mysql_query("set names gb2312");
$result = mysql_query($sql);
return mysql_fetch_array($result);