error >> parameter 1 to be resource

vidz

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in F:\xampplite\htdocs\chem\search.php on line 191

while($row = mysql_fetch_array($result1))  //this is the line 191 
 { 
     echo "<tr>"; 
                echo '<td>'. $row['name'] . '</td>'; 
                echo '<td>' . $row['chemical_code'] . '</td>'; 
                echo '<td>' . $row['type'] . '</td>'; 
                echo '<td><a href="editchemical.php?id=' . $row['id'] . '">Edit</a></td>'; 
                echo '<td><a href="delete_chemical.php?id=' . $row['id'] . '">Delete</a></td>'; 
                echo '<td><a href="stock_chemical.php?id=' . $row['id'] . '">Stock</a></td>'; 
                echo "</tr>"; 
 }

This is the result output part of search.php page. When i enter search text to search it gives the correct results, but there is one extra page (in pagination) is shown. When we click on that there is no results only the above error is displaying. I am clueless of what is happening. I havent post my full code here. Because its a big code (😛 to me). And also there is no error in the query. Bcos i have ech it on php myadmin and its works correctly.

Bonesnap

There has to be an error in your query. I'm assuming $result1 is the result of a call to mysql_query(), no? In any case, $result1 is boolean false, which means if it came from a call to mysql_query() then there's an error with the query, because it returns false if it fails.

Either that or you're doing something to $result1 before using it in the loop.

Regardless, please post more of your code, specifically where you build your query and when you execute a call to mysql_query().

Weedpacket

Like all the other instances of this question (which a search would find), and as the manual implies in the page for [man]mysql_query[/man], this error means that the original query failed because it contained an error and MySQL returned an error instead of a result (and of course the error can be fetched by using [man]mysql_error[/man]).

And there is also the issue of the MySQL extension should not be used for new code, because it has been deprecated in favour of the MySQLi or PDO extensions.

vidz

<?php
      include("config.php");

 $find    = mysql_real_escape_string($_POST['find']);
 $field    = mysql_real_escape_string($_POST['field']); 
 $find = strtoupper($find); 
 $find = strip_tags($find); 
 $find = trim ($find); 



$tableName  = chemical;
$targetpage = "search.php"; 	
$limit      = 5; 

$query = "SELECT COUNT(*) as num FROM $tableName";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

$stages = 3;
$page = mysql_escape_string($_GET['page']);
if($page){
	$start = ($page - 1) * $limit; 
}else{
	$start = 0;	
	}	

// Get page data
$query1 = "SELECT * FROM $tableName WHERE upper($field) LIKE'%$find%' LIMIT $start, $limit";
$result1 = mysql_query($query1);

// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;	
$next = $page + 1;							
$lastpage = ceil($total_pages/$limit);		
$LastPagem1 = $lastpage - 1;					


$paginate = '';
if($lastpage > 1)
{	




	$paginate .= "<div class='paginate'>";
	// Previous
	if ($page > 1){
		$paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
	}else{
		$paginate.= "<span class='disabled'>previous</span>";	}



	// Pages	
	if ($lastpage < 7 + ($stages * 2))	// Not enough pages to breaking it up
	{	
		for ($counter = 1; $counter <= $lastpage; $counter++)
		{
			if ($counter == $page){
				$paginate.= "<span class='current'>$counter</span>";
			}else{
				$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
		}
	}
	elseif($lastpage > 5 + ($stages * 2))	// Enough pages to hide a few?
	{
		// Beginning only hide later pages
		if($page < 1 + ($stages * 2))		
		{
			for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";		
		}
		// Middle hide some front and some back
		elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
		{
			$paginate.= "<a href='$targetpage?page=1'>1</a>";
			$paginate.= "<a href='$targetpage?page=2'>2</a>";
			$paginate.= "...";
			for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
			}
			$paginate.= "...";
			$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
			$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";		
		}
		// End only hide early pages
		else
		{
			$paginate.= "<a href='$targetpage?page=1'>1</a>";
			$paginate.= "<a href='$targetpage?page=2'>2</a>";
			$paginate.= "...";
			for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
			{
				if ($counter == $page){
					$paginate.= "<span class='current'>$counter</span>";
				}else{
					$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}					
			}
		}
	}

			// Next
	if ($page < $counter - 1){ 
		$paginate.= "<a href='$targetpage?page=$next'>next</a>";
	}else{
		$paginate.= "<span class='disabled'>next</span>";
		}


$paginate.= "</div>";

}


// get results from database
     //   $result = mysql_query("SELECT * FROM members") 
       //         or die(mysql_error());  

    // display data in table 


// $data = mysql_query("SELECT * FROM chemical WHERE upper($field) LIKE'%$find%'")
 //or die(mysql_error()); 

 echo "<table id='table1'>";
  echo "<tr> <th>Chemical Name</th> <th>Chemical Code</th> <th>Type</th> <th>Edit</th><th>Delete</th><th>Stock</th>  </tr>";

while($row = mysql_fetch_array($result1)) 
 { 
                echo "<tr>";
                echo '<td>'. $row['name'] . '</td>';
                echo '<td>' . $row['chemical_code'] . '</td>';
                echo '<td>' . $row['type'] . '</td>';
				echo '<td><a href="editchemical.php?id=' . $row['id'] . '">Edit</a></td>';
				echo '<td><a href="delete_chemical.php?id=' . $row['id'] . '">Delete</a></td>';
				echo '<td><a href="stock_chemical.php?id=' . $row['id'] . '">Stock</a></td>';
                echo "</tr>";
 } 
  echo "</table>"; 
  echo $paginate;


?>

There isnt an error in query. It works in phpmyadmin :mad:

Weedpacket

What you're typing into phpmyadmin won't be the same thing you're using in the page. The thing you're using in the page has variables in it.

Do you have any error reporting turned on for development?

error_reporting(E_ALL);

if you haven't set it in php.ini

Did you know that there is a thread on debugging techniques that can help locate the causes of errors like this?

vidz

nope. I ddnt do anythng to php.ini. IT has its default values. Thanks for replying il turn on it and il go through the debugging techniques thread too.

vidz

Weedpacket;11005559 wrote:
Do you have any error reporting turned on for development?
error_reporting(E_ALL);
if you haven't set it in php.ini

did changes in php.ini. But then there are lot of errors shown in pagination pages.
Notice: Undefined index: page in F:\xampplite\htdocs\chem\search.php on line 70

Notice: Use of undefined constant chemical - assumed 'chemical' in F:\xampplite\htdocs\chem\search.php on line 61
.
.
.
.
.
.

those errors are shown even in other pages without errors (but with pagination)

Weedpacket

Notice: Undefined index: page in F:\xampplite\htdocs\chem\search.php on line 70

Means that on line 70 of search.php you're trying to use an array element with a key of 'page', but that array element does not exist. (Search these forums for "Undefined index")

Notice: Use of undefined constant chemical - assumed 'chemical' in F:\xampplite\htdocs\chem\search.php on line 61

Means that on line 61 of search.php you've forgotten to put quotes around one of your strings. (Search these forums for "Use of undefined constant").

vidz

Thank u so much Weedpacket
I like the way you solve 🙂 Still working on the script.