Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in

daimlerica · August 25, 2013

Hi, i need some help with this code..i cant handle it Im new in php.

I got this error: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in bla bla on line 653

653 -> 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;

}

fastsol · August 25, 2013

The issue is in your query, post that code and any code that relates to building the query string.

ryanmetzler3 · August 26, 2013

it means your query is failing because it is expecting to get some value and it is receiving nothing.

daimlerica · August 26, 2013

<?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;

}

?>

Sign In

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in

Recommended Posts

daimlerica

Link to comment

Share on other sites

fastsol

Link to comment

Share on other sites

ryanmetzler3

Link to comment

Share on other sites

daimlerica

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information