无语的出错,mysql_fetch_array()
代码如下,求帮忙看一下吧!
<?php<br />
class Conn{<br />
private $dbhost = ""; //服务器<br />
private $dbuser = ""; //mysql帐号<br />
private $dbpsw = ""; //mysql密码<br />
private $dbchar = ""; //数据库编码类型<br />
private $dbname = ""; //数据库名称<br />
private $tablepre = ""; //表前缀<br />
private $conn = NULL; //连接对象 <br />
<br />
/**<br />
* 数据库链接初始化<br />
*/<br />
public function __construct(){<br />
$this->getConn();<br />
}<br />
<br />
public function getConn(){<br />
$db = require_once 'config/config.php';<br />
$this->dbhost = $db['dbhost'];<br />
$this->dbuser = $db['dbuser'];<br />
$this->dbpsw = $db['dbpsw'];<br />
$this->dbchar = $db['dbchar'];<br />
$this->dbname = $db['dbname'];<br />
$this->tablepre = $db['tablepre'];<br />
$this->conn = mysql_connect($this->dbhost,$this->dbuser,$this->dbpsw) or die(mysql_error()."<br/>Mysql连接失败!");<br />
mysql_select_db($this->dbname,$this->conn) or die(mysql_error()."<br/>数据库访问出错");<br />
mysql_query("set names ".$this->dbchar,$this->conn);<br />
}<br />
<br />
/**<br />
* 执行sql<br />
*/<br />
public function query($sql){<br />
return mysql_query($sql,$this->conn) or die(mysql_error()."<br/>SQL执行出错:$sql");<br />
}<br />
<br />
/**<br />
* 返回多条记录<br />
*/<br />
public function getDataArrays($sql,$type = MYSQL_BOTH){<br />
$result = $this->query($sql);<br />
$refArr = array();<br />
<span style="color: #FF0000;">while ($row = mysql_fetch_array($result,$type)){</span><br />
$refArr[] = $row;<br />
}<br />
return $refArr;<br />
}<br />
<br />
<br />
/**<br />
* 关闭数据库链接<br />
*/<br />
public function closeConn(){<br />
mysql_close($this->conn);<br />
}<br />
}$conn = new Conn();<br /> $sql = "select * from qj_content";<br /> $contentList = $conn->getDataArrays($sql,MYSQL_ASSOC);<br /> $conn->closeConn();
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号