Warning: mysql_fetch_array() error

daimlerica · August 27, 2013

Hi, anyone can help me with this error?

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in...on line 653

Line 653: while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {

Whole code:

<?php

if (!defined('AFFREE'))

{

die('You cannot access this page directly!');

}

class db {

var $cnn_id;

var $db_type;

var $dir;

var $name;

var $filename;

var $fso;

var $sql;

var $cnn;

var $db;

var $ttl;

var $data_ts;

var $server;

var $log;

var $rows_affected;

var $last_id;

/*

The class constructor. You can set some defaults here if desired.

*/

function db($cnn_id=0) {

$this->log = "initialize db() called ";

$this->cnn_id = $cnn_id;

$this->dir = "/cache/acache/"; //Default to current dir.

$this->ttl = 0;

$this->data_ts = 0;

}

/*

connect() method makes the actual server connection and selects a database

only if needed. This saves database connections. Multiple database types are

supported. Enter your connection credentials in the switch statement below.

This is a private function, but it is at the top of the class because you need

to enter your connections.

*/

function connect() {

$this->log .= "connect() called ";

switch($this->cnn_id) {

/*

You can define all the database connections you need in this

switch statement.

*/

case 0:

$this->db_type = "mysql";

$this->server = SERVER_NAME;

$user = USER_NAME;

$pwd = PASSWORD;

$this->db = DB_NAME;

break;

case 1:

$this->db_type = "mysql";

$this->server = "";

$user = "";

$pwd = "";

$this->db = "";

break;

case 2:

$this->db_type = "postgres";

$this->server = "";

$user = "";

$pwd = "";

$this->db = "";

break;

case 3:

$this->db_type = "mssql";

$this->server = "";

$user = "";

$pwd = "";

$this->db = "";

break;

}

switch($this->db_type) {

case "mysql":

if (!$this->cnn = mysql_connect($this->server,$user,$pwd )) {

$this->log .= "mysql_connect() failed ";

$this->log .= mysql_error()." ";

return false;

}

if (!mysql_select_db($this->db,$this->cnn)) {

$this->log .= "Could not select database named ".$this->db." ";

$this->log .= mysql_error()." ";

return false;

}

break;

case "postgres":

if (!$this->cnn = pg_connect("host=$this->server dbname=$this->dbuser=$user password=$pwd")) {

$this->log .= "pg_connect() failed ";

$this->log .= pg_last_error()." ";

return false;

}

break;

case "mssql":

if (!$this->cnn = mssql_connect($this->server,$user,$pwd )) {

$this->log .= "mssql_connect() failed ";

$this->log .= mssql_error()." ";

return false;

}

if (!mssql_select_db($this->db,$this->cnn)) {

$this->log .= "Could not select database named ".$this->db." ";

$this->log .= mssql_error()." ";

return false;

}

break;

}

return true;

}

/*

fetch() is used to retrieve a dataaset. fetch() determines whether to use the

cache or not, and queries either the database or the cache file accordingly.

*/

function fetch($sql="",$ttl=0,$name="") {

$this->log .= "--------------------------------- fetch() called ";

$this->rows_affected = 0;

if (!$sql) {

$this->log .= "OOPS: You need to pass a SQL statement! ";

return false;

}

$this->sql = $sql;

$this->ttl = $ttl;

$this->name = $name;

$this->log .= "SQL: ".$this->sql." ";

$data = "";

if ($this->ttl == "0") {

return $data = $this->getFromDB();

} else {

if (strlen(trim($this->name)) == 0) { $this->name = MD5($this->sql); }

$this->filename = $this->dir."db_".$this->name;

$this->log .= "Filename: ".$this->filename." ";

$this->getFile_ts();

if ($this->ttl == "daily") {

if (date('Y-m-d',$this->data_ts) != date('Y-m-d',time())) {

$this->log .= "cache has expired ";

if (!$data = $this->getFromDB()) { return false; }

if (!$this->saveToCache($data)) { return false; }

return $data;

} else {

return $data = $this->getFromCache();

}

} else {

if ((time() - $this->data_ts) >= $this->ttl) {

$this->log .= "cache has expired ";

if (!$data = $this->getFromDB()) { return false; }

if (!$this->saveToCache($data)) { return false; }

return $data;

} else {

return $data = $this->getFromCache();

}

/*

Use exec() to execute INSERT, UPDATE, DELETE statements.

*/

function exec($sql="") {

$this->log .= "--------------------------------- exec() called ";

$this->rows_affected = 0;

if (!$sql) {

$this->log .= "OOPS: You need to pass a SQL statement! ";

return false;

}

$this->sql = $sql;

$this->log .= "SQL: ".$this->sql." ";

if (!$this->cnn) { if (!$this->connect()) { return false; } }

switch($this->db_type) {

case "mysql":

if (!$res = @mysql_query($this->sql, $this->cnn)) {

$this->log .= "Query execution failed. ";

$this->log .= mysql_error()." ";

return false;

}

break;

case "postgres":

if (!$res = @pg_query($this->cnn, $this->sql)) {

$this->log .= "Query execution failed. ";

$this->log .= pg_last_error()." ";

return false;

}

break;

case "mssql":

if (!$res = @mssql_query($this->sql, $this->cnn)) {

$this->log .= "Query execution failed. ";

$this->log .= mssql_error()." ";

return false;

}

break;

}

/*

Set last_id property (only applicable for INSERTS), and return

number of rows affected by INSERT, UPDATE, DELETE.

*/

switch($this->db_type) {

case "mysql":

$this->last_id = mysql_insert_id();

$this->rows_affected = mysql_affected_rows($this->cnn);

$this->log .= $this->rows_affected." rows affected ";

return $this->rows_affected;

case "postgres":

$this->last_id = pg_last_oid($res);

$this->rows_affected = pg_affected_rows($res);

$this->log .= $this->rows_affected." rows affected ";

return $this->rows_affected;

case "mssql":

$this->last_id = @mssql_result(@mysql_query("select SCOPE_IDENTITY()"),0,0);

$this->rows_affected = mssql_rows_affected($this->cnn);

$this->log .= $this->rows_affected." rows affected ";

return $this->rows_affected;

}

/*

fmt() is a helper function for formatting SQL statement strings.

For strings values, it will escape embedded single ticks, replace emptry

strings with 'NULL', and properly wrap the value in quotes. For numeric types,

it will replace empty values with zero.

val : value to format

dtype : 0 = string, 1 = numeric

*/

function fmt($val,$dtype) {

switch($dtype) {

case 0:

if(! $val && $val != "0") {

$tmp = "null";

} else {

$tmp = "'".str_replace("'","''",$val)."'";

}

break;

case 1:

if(! $val) {

$tmp = "0";

} else {

$tmp = $val;

}

break;

}

return $tmp;

}

/*

fmt2() is the same as fmt() except it inserts a comma at the beginning

of the return value and a space at the end. Useful in building SQL statements

with multiple values.

*/

function fmt2($val,$dtype) {

switch($dtype) {

case 0:

if(! $val && $val != "0") {

$tmp = ",null ";

} else {

$tmp = ",'".str_replace("'","''",$val)."' ";

}

break;

case 1:

if(! $val) {

$tmp = ",0";

} else {

$tmp = ",".$val." ";

}

break;

}

return $tmp;

}

/*

dump() produces an HTML table of the data. It is useful for debugging.

This is also a good example of how to work with the data array.

*/

function dump($data) {

$this->log .= "dump() called ";

if (!$data) {

$this->log .= "dump(): no rows exist ";

return false;

}

echo "<style>table.dump { font-family:Arial; font-size:8pt; }</style>";

echo "<table class=\"dump\" border=\"1\" cellpadding=\"1\" cellspacing=\"0\">\n";

echo "<tr>";

echo "<th>#</th>";

foreach($data[0] as $key=>$val) {

echo "<th>";

echo $key;

echo "</th>";

}

echo "</tr>\n";

$row_cnt = 0;

foreach($data as $row) {

$row_cnt++;

echo "<tr align='center'>";

echo "<td>".$row_cnt."</td>";

foreach($row as $val) {

echo "<td>";

echo $val;

echo "</td>";

}

echo"</tr>\n";

}

echo "</table>\n";

}

/*

PRIVATE FUNCTIONS BELOW THIS POINT

------------------------------------------------------------------------------

*/

function getFromDB() {

$this->log .= "getFromDB() called ";

if (!$this->cnn) {

if (!$this->connect()) {

$this->log .= "Database connection failed. ";

return false;

}

switch($this->db_type) {

case "mysql":

if (!$res = @mysql_query($this->sql, $this->cnn)) {

$this->log .= "Query execution failed. ";

$this->log .= mysql_error()." ";

return false;

}

while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {

$data[] = $row;

}

break;

case "postgres":

if (!$res = @pg_query($this->cnn, $this->sql)) {

$this->log .= "Query execution failed. ";

$this->log .= pg_last_error()." ";

return false;

}

if (!$data = @pg_fetch_all($res)) {

$this->log .= "getFromDB() failed ";

return false;

}

break;

case "mssql":

if (!$res = @mssql_query($this->sql, $this->cnn)) {

$this->log .= "Query execution failed. ";

$this->log .= mssql_error()." ";

return false;

}

while ($row = mssql_fetch_array($res)) {

$data[] = $row;

}

break;

}

return $data;

}

function getFromCache() {

$this->log .= "getFromCache() called ";

if (!$x = @file_get_contents($this->filename)) {

$this->log .= "Could not read ".$this->filename." ";

return false;

}

if (!$data = unserialize($x)) {

$this->log .= "getFromCache() failed ";

return false;

}

return $data;

}

function saveToCache($data) {

$this->log .= "saveToCache() called ";

//create file pointer

if (!$fp=@fopen($this->filename,"w")) {

$this->log .= "Could not open ".$this->filename." ";

return false;

}

//write to file

if (!@fwrite($fp,serialize($data))) {

$this->log .= "Could not write to ".$this->filename." ";

fclose($fp);

return false;

}

//close file pointer

fclose($fp);

return true;

}

function getFile_ts() {

$this->log .= "getFile_ts() called ";

if (!file_exists($this->filename)) {

$this->data_ts = 0;

$this->log .= $this->filename." does not exist ";

return false;

}

$this->data_ts = filemtime($this->filename);

return true;

}

?>

PravinS · August 27, 2013

check your sql query

Muddy_Funster · August 27, 2013

Use Code Tags.

Only Post Relevant Code.

Try Searching Before Posting.

Read All Stickies In A Forum Section BEFORE Posting.

daimlerica · August 27, 2013

PravinS how can i check my SQL query ?

Muddy_Funster · August 27, 2013

if you fix how you have posted your code the rest of us will actually bother to have a look at it and may even be able to tell you what the problem is. If you want to alienate the majority of the community by ignoring the forum rules though - you go right ahead, far be it from me to hold you back.

mac_gyver · August 27, 2013

you also already have a current thread for this, don't start another thread for the same problem.

daimlerica · August 27, 2013

How can i edit my post ? damn, sorry guys

Muddy_Funster · August 27, 2013

there is a short time period after a post is made where you can edit it, after this that's it - it's stuck like that untill freaks close their servers. A moderator or admin has the power to edit existing posts at any time, but other than that your best option is to repost the code inside the code tags and we'll take it from there.

Sign In

Warning: mysql_fetch_array() error

Recommended Posts

daimlerica

Link to comment

Share on other sites

PravinS

Link to comment

Share on other sites

Muddy_Funster

Link to comment

Share on other sites

daimlerica

Link to comment

Share on other sites

Muddy_Funster

Link to comment

Share on other sites

mac_gyver

Link to comment

Share on other sites

daimlerica

Link to comment

Share on other sites

Muddy_Funster

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information