mysql_fetch_array 报错_警告:mysql_fetch_array():提供的参数不是有效的MySQL结果...

警告:mysql_fetch_array():提供的参数不是有效的MySQL结果

我在尝试运行时遇到错误:

require_once('includes/DbConnector.php');

$connector = new DbConnector();

$result = $connector->query('SELECT title,content FROM staff_vacancies ORDER BY ordering LIMIT 0,100');

// Get an array containing the results.

// Loop for each item in that array

while ($row = $connector->fetchArray($result)){

echo $row['title'].'';

echo $row['content'];

}

?>

我有一个链接文件:DbConnector.php:

// Class: DbConnector

// Purpose: Connect to a database, MySQL version

///

require_once 'SystemComponent.php';

class DbConnector extends SystemComponent {

var $theQuery;

var $link;

//*** Function: DbConnector, Purpose: Connect to the database ***

function DbConnector(){

// Load settings from parent class

$settings = SystemComponent::getSettings();

// Get the main settings from the array we just loaded

$host = $settings['dbhost'];

$db = $settings['dbname'];

$user = $settings['dbusername'];

$pass = $settings['dbpassword'];

//the settings

$host = 'localhost';

$db = 'xxx';

$user = 'xxx';

$pass = 'xxx';

// Connect to the database

$this->link = mysql_connect($host, $user, $pass);

mysql_select_db($db);

register_shutdown_function(array(&$this, 'close'));

}

//*** Function: query, Purpose: Execute a database query ***

function query($query) {

$this->theQuery = $query;

return mysql_query($query, $this->link);

}

//*** Function: getQuery, Purpose: Returns the last database query, for debugging ***

function getQuery() {

return $this->theQuery;

}

//*** Function: getNumRows, Purpose: Return row count, MySQL version ***

function getNumRows($result) {

return mysql_num_rows($result);

}

//*** Function: fetchArray, Purpose: Get array of query results ***

function fetchArray($result) {

return mysql_fetch_array($result);

}

有谁知道问题是什么?

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值