Page 1 of 1

How to put Control On Search Mechanism

Posted: Mon Dec 10, 2007 8:58 pm
by haseebmaqsood
I am able to search what ever i like but if the search get failed it means no relevent record available than i am not able to handle it.It generates errors mysql_array() or etc

Code is Here

Kindly Help m

***** PLEASE USE PHP/CODE TAGS *****

Code: Select all

<?
function pagination($query)
{
// Obtain The Required Page NO
	
	if (isset($_GET['pageno'])) {
	   $pageno = $_GET['pageno'];
	
			} else {
			   $pageno = 1;
			}
	
	$numrows=mysql_num_rows(mysql_query($query));
	
	// Calculate The Number Of Last Page
	$rows_per_page = 3;
	$lastpage      = ceil($numrows/$rows_per_page);
	$_SESSION['lastpage']=$lastpage;
	$pageno = (int)$pageno;
	
		if ($pageno < 1) {
				$pageno = 1;
						 }
		
			elseif ($pageno > $lastpage) {
					 $pageno = $lastpage;
										} 
					
					//Construction Limit Clause
					$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;
					
		return $limit;
}

if(isset($_POST['action']) || $_POST['actress_name']!="")
{
	
	$aname=$_POST["actress_name"];
	$query="select  * FROM stars s LEFT OUTER JOIN images i ON s.Star_ID =  i.Star_ID where s.First_Name like '%$aname%' ";
	
	
				$_SESSION['query']=$query;
				$limit=pagination($query);
				
}

		else if(isset($_SESSION['query']) && $_GET['value']=="searchActress")
		{
		$query=$_SESSION['query'];
		$limit=pagination($query);
		}
			else
			{
			$query="SELECT * FROM stars s LEFT OUTER JOIN images i On s.Star_ID=i.Star_ID WHERE i.status='Main'";	
			$limit=pagination($query);
			} 	
			$result=mysql_query($query.$limit);
				
?>
	
	<script language="javascript">
			function makeSure(id)
			{
				var conf=confirm("Are you sure you want to delete this Actress?");
			
					 
					 if(conf)
					 {
						var link="deleteActress.php?id="+id;
						document.location.href=link;
					 }
					else
						return false;
			
			}
			
	</script>	

		

		<table width='100%' align='center' cellspacing="5" cellpadding="5">
		 
		  <tr>
		  	<td class="heading1" colspan="4" align="center">
				
					<span class="heading">Hollywood Stars Biography</span>
			
			</td>
		 </tr>	 			
				
		 <tr>
		  	
			<td class="heading1" colspan="4" align="center">
			<? include("searchActress.php")?>	
			</td>
		 
		 </tr>
		 
		 <tr>
				<td colspan="4" align="center">
<?		 	
				echo "<table border='0' align='center'>";
				echo "<tr>";
				for ($i=1; $i<=$_SESSION['lastpage']; $i++)
					{ 
						if($_GET['value']=="searchActress" )
						{	
						echo "<td>";
						echo "<a href='controlPanel.php?pageno=$i&value=searchActress' class='paginationLink'>".$i."</a>";			
						echo "</td>";		
						}
						else if($_GET['value']=="viewActress")
						{
						echo "<td>";
						echo "<a href='controlPanel.php?pageno=$i&value=viewActress' class='paginationLink'>".$i."</a>";
						echo "</td>";
						}
					}	
				echo "</tr></table>";
?>			
			</td>
		 </tr>
		  
		  <tr>
		  	<td colspan="4" align="center">
<?				
				if($_GET[msg]=="added")
					{
						echo "<center><span class='confirmation'>Actress was successfully Added</span></center>";
					}

				else if($_GET[msg]=="deleted")
					{
						echo "<center><span class='confirmation'>Actress was successfully Deleted</span></center>";
					}
				else if($_GET[msg]=="edited")
					{
						echo "<center><span class='confirmation'>Actress was successfully Updated</span></center>";
					}
?>		
</br></br>
							
			</td>
		 </tr>	 		
		 		 	 
		 		 
		  <?		
						while($row = mysql_fetch_array($result))
								   
				{
		  ?>
		  <tr>
			
			<td align="center" valign="middle" width="20%" >				
            
			<a href='controlPanel.php?id=<?=$row[Star_ID]?>&value=editActress' class='pictureLink'><img src="<?=$row['Path'] ?>" width="100" height="100" border="0"></a> 
			
			</td>
			
			<td align="left" valign="middle" width="30%" >						
			
			<a href='editActress.php?id=<?=$row[Star_ID] ?>' class='textLink'>First Name:<? echo $row['First_Name']; ?></a>
			<br/>
			<span class="textDetail">Last Name:<? echo $row['Last_Name']; ?></span>
			<br/>
			<span class="textDetail">Date Of Birth:<? echo $row['DOB']; ?></span>
			<br/>
			<span class="textDetail">Place Of Birth:<? echo $row['POB'];  ?></span>
 			<br/>
			<span class="textDetail">Father Name:<? echo $row['Father_Name']; ?></span>
			<br/>
			<span class="textDetail">Mother Name:<? echo $row['Mother_Name']; ?></span>
			<br/>
			<span class="textDetail">Height:<? echo $row['Height']; ?></span>
			<br/>
			</td>
			
			<td align="left" valign="middle" width="25%">
	<?  echo "<a href='controlPanel.php?value=editActress&id=$row[Star_ID]'><img src='./MenuImages/Edit.jpg' border='0'></a>" ?>
			</td>
			
			<td align="left" valign="middle" width="25%">
	<?  echo "<a href='javascript::void(0);' onclick=\"makeSure($row[Star_ID]);\"><img src='./MenuImages/Delete.jpg' border='0'</a>" ?>		</td>
							  
		  </tr>
		 
		 <tr>
		 	<td colspan="4" align="left">
		 		<span class="textDesc"><? echo $row['Extra']; ?></span>
	 			<hr></hr>	 	
			</td>
		 </tr>
		 
		  <?		}		?>
		 		
		 <tr>
				<td colspan="4" align="center">
<?		 	
				echo "<table border='0' align='center'>";
				echo "<tr>";
				for ($i=1; $i<=$lastpage; $i++)
						
					{ 
						echo "<td bgcolor='#33CCFF'>";
						
						if($_GET['value']=="searchActress" )
						{	
						$aname=$_GET["actress_name"];
						echo "<a href='controlPanel.php?pageno=$i&value=searchActress' class='paginationLink'><strong>".$i."</strong></a>";			
						echo "</td>";		
						}
						else if($_GET['value']=="viewActress")
						{
						echo "<td bgcolor='#33CCFF'>";
						echo "<a href='controlPanel.php?pageno=$i&value=viewActress' class='paginationLink'><strong>".$i."</strong></a>";
						echo "</td>";
						}
					}	
				echo "</tr></table>";
?>			
			</td>
		 </tr>
		 
		  <tr>
				<td colspan="4" align="center">
<?		 	
				echo "<table border='0' align='center'>";
				echo "<tr>";
				for ($i=1; $i<=$_SESSION['lastpage']; $i++)
						
					{ 	
						if($_GET['value']=="searchActress" )
						{	
						echo "<td>";
						echo "<a href='controlPanel.php?pageno=$i&value=searchActress' class='paginationLink'>".$i."</a>";			
						echo "</td>";		
						}
						else if($_GET['value']=="viewActress")
						{
						echo "<td>";
						echo "<a href='controlPanel.php?pageno=$i&value=viewActress' class='paginationLink'>".$i."</a>";
						echo "</td>";
						}
					}	
				echo "</tr></table>";
?>			
			</td>
		 </tr>
		 		 	 	
</table>

Posted: Mon Dec 10, 2007 10:37 pm
by Christopher
Put an if (mysql_numrows() > 0) around your loop.

Posted: Tue Dec 11, 2007 1:16 am
by haseebmaqsood
arborint wrote:Put an if (mysql_numrows() > 0) around your loop.

Thanks

But there is a problem that when i gave argument variable to this function,it performs its functionality while it is true, mean getting records and not been able to perform any functionality when there is no record

So it generates error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\xampp\htdocs\StarsWorld\actress.php on