<html>
<head>
<title>search</title>
</head>
<body>
<form name="frmSearch" method="get" action="<?=$_SERVER['SCRIPT_NAME'];?>">
<table width="599" border="1">
<tr>
<th>Keyword
<input name="txtKeyword" type="text" id="txtKeyword" value="<?=$_GET["txtKeyword"];?>">
<input type="submit" value="Search"></th>
</tr>
</table>
</form>
<?
if($_GET["txtKeyword"] != "")
{
$objConnect = mysql_connect("localhost","lafamosa_kermis","lafamosa1980") or die(mysql_error());
$objDB = mysql_select_db("lafamosa_mystore");
// Search By Name or Email
$strSQL = "SELECT * FROM products WHERE (id LIKE '%".$_GET["txtKeyword"]."%' or details LIKE '%".$_GET["txtKeyword"]."%')";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);

$Per_Page = 2;

$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}

$Prev_Page = $Page-1;
$Next_Page = $Page+1;

$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}

$strSQL .=" order by id ASC LIMIT $Page_Start , $Per_Page";
$objQuery = mysql_query($strSQL);

?>
<table width="600" border="1">
<tr>
<th width="98"> <div align="center">id </div></th>
<th width="98"> <div align="center">product_name </div></th>
<th width="98"> <div align="center">price </div></th>
<th width="198"> <div align="center">details </div></th>
</tr>  
<?  
while($objResult = mysql_fetch_array($objQuery))  
{  
?>  
<tr>  

<td><div align="center"><?=$objResult["id"];?></td> 
<td><?=$objResult["product_name "];?></td>  
<td><?=$objResult["price"];?></td>  
<td><?=$objResult["details"];?></td> 
</tr>  
<?  
}  
?>  
</table>  
<br> 


Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
<?
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&txtKeyword=$_GET[txtKeyword]'><< Back</a> ";
}

for($i=1; $i<=$Num_Pages; $i++){
if($i != $Page)
{
echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i&txtKeyword=$_GET[txtKeyword]'>$i</a> ]";
}
else
{
echo "<b> $i </b>";
}
}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page&txtKeyword=$_GET[txtKeyword]'>Next>></a> ";
}

mysql_close($objConnect);
}
?>
</body>
</html>

i am new to php and how can i give link to http://www.blabla/product.php?id=4 from table

my database like this
id product_name price details

echo "<a href='product.php?id={$objResult['id']}'>{$objResult['product_name']}</a>";
<td><?=$objResult["product_name "];?>echo"<a href='product.php?id={$objResult['id']}'>{$objResult['product_name']}</a></td>

Thanks you answer but it gives error like above how should i write?

Show part of the code around where you put it, and paste the error here too.

i added the code to 69. and the result in attach files

Use this then:

<td><a href='product.php?id=<?=$objResult['id'];?>'><?=$objResult['product_name'];?></a></td>
<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<form name="frmSearch" method="get" action="<?=$_SERVER['SCRIPT_NAME'];?>">
<table width="599" border="1">
<tr>
<th>Keyword
<input name="txtKeyword" type="text" id="txtKeyword" value="<?=$_GET["txtKeyword"];?>">
<input type="submit" value="Search"></th>
</tr>
</table>
</form>
<?
if($_GET["txtKeyword"] != "")
{
$objConnect = mysql_connect("localhost","lafamosa_kermis","lafamosa1980") or die(mysql_error());
$objDB = mysql_select_db("lafamosa_mystore");
// Search By Name or Email
$strSQL = "SELECT * FROM products WHERE (id LIKE '%".$_GET["txtKeyword"]."%' or details LIKE '%".$_GET["txtKeyword"]."%')";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);

$Per_Page = 2;

$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}

$Prev_Page = $Page-1;
$Next_Page = $Page+1;

$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}

$strSQL .=" order by id ASC LIMIT $Page_Start , $Per_Page";
$objQuery = mysql_query($strSQL);

?>
<table width="600" border="1">
<tr>
<th width="98"> <div align="center">id </div></th>
<th width="98"><a href='product.php?id=<?=$objResult['id'];?>'><?=$objResult['product_name'];?>><td><a href='product.php?id=<?=$objResult['id'];?>'><?=$objResult['product_name'];?></a></td> <div align="center">product_name </div></th><td></a></td>
<th width="98"> <div align="center">price </div></th>
<th width="198"> <div align="center">details </div></th>
<th width="198"> <div align="center">product_name </div></th>

</tr>  
<?  
while($objResult = mysql_fetch_array($objQuery))  
{  
?>  
<tr>  

<td><div align="center"><?=$objResult["id"];?></td> 
<td><?=$objResult["product_name "];?></a></td>  
<td><?=$objResult["price"];?></td>  
<td><?=$objResult["details"];?></td> 

</tr>  
<?  
}  
?>  
</table>  
<br> 


Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
<?
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&txtKeyword=$_GET[txtKeyword]'><< Back</a> ";
}

for($i=1; $i<=$Num_Pages; $i++){
if($i != $Page)
{
echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i&txtKeyword=$_GET[txtKeyword]'>$i</a> ]";
}
else
{
echo "<b> $i </b>";
}
}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page&txtKeyword=$_GET[txtKeyword]'>Next>></a> ";
}

mysql_close($objConnect);
}
?>
</body>
</html>

now i give some error in attach files

my database design like this
id product_name details price
1 samsung tv 3d 1000

Are you just blindly adding my code somewhere ?

hey dude it works but now problems with header please look at thumbnail

<table width="600" border="1">
<tr>
<th width="98"> <div align="center">id </div></th>
<th width="98"> <div align="center">price </div></th>
<th width="198"> <div align="center">details </div></th>
<th width="198"> <div align="center">product_name </div></th>

</tr>  
<?  
while($objResult = mysql_fetch_array($objQuery))  
{  
?>  
<tr>  

<td><div align="center"><?=$objResult["id"];?></td> 
<td><?=$objResult["product_name "];?></td>  
<td><?=$objResult["price"];?><td>
<a href='product.php?id=<?=$objResult['id'];?>'><?=$objResult['product_name'];?></a></td></td>  
<td><?=$objResult["details"];?></td>

Line 17 should end with </td>, line 18 should start with <td> so check your HTML tags. You have 4 th's and 5 td's.

i think there is a little problem but i cant find it (in attachment)

<table width="600" border="1">
<tr>
<th width="98"> <div align="center">id </div></th>
<th width="98"> <div align="center">price </div></th>
<th width="198"> <div align="center">details </div></th>
<th width="198"> <div align="center">product_name </div></th>

</tr>  
<?  
while($objResult = mysql_fetch_array($objQuery))  
{  
?>  
<tr>  

<td><?=$objResult["id"];?></td> 
<td><?=$objResult["product_name "];?></td>  
<td><?=$objResult["price"];?></td>
<td><?=$objResult["details"];?></td> 
<td><a href='product.php?id=<?=$objResult['id'];?>'><?=$objResult['product_name'];?></a></td></td> 
</tr>  
<?  
}  
?>  
</table>  
<br>

See previous post.

i cant solve the problem
?>
<table width="600" border="1">
<tr>
<th width="98"> <div align="center">id</div></th>
<th width="98"> <div align="center">product_name </div></th>
<th width="98"> <div align="center">price </div></th>
<th width="98"> <div align="center">details </div></th>

</tr>

<?
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr>

<td><?=$objResult["id"];?></td>
<td><?=$objResult["product_name"];?><td><a href='product.php?id=<?=$objResult;?>'><?=$objResult;?></a></td></td>
<td><?=$objResult["price"];?></td>
<td><?=$objResult["details"];?></td>

</tr>
<?
}
?>
</table>

One th is missing. And your td's are nested.

hi , there is a new problem now when i search with product_name just a few record is shown while id is full shown (the latest code situation)

<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<form name="frmSearch" method="get" action="<?=$_SERVER['SCRIPT_NAME'];?>">
<table width="599" border="1">
<tr>
<th>Keyword
<input name="txtKeyword" type="text" id="txtKeyword" value="<?=$_GET["txtKeyword"];?>">
<input type="submit" value="Search"></th>
</tr>
</table>
</form>
<?
if($_GET["txtKeyword"] != "")
{
$objConnect = mysql_connect("localhost","lafamosa_kermis","lafamosa1980") or die(mysql_error());
$objDB = mysql_select_db("lafamosa_mystore");
// Search By Name or Email
$strSQL = "SELECT * FROM products WHERE (id LIKE '%".$_GET["txtKeyword"]."%' or details LIKE '%".$_GET["txtKeyword"]."%')";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);


$Per_Page = 2;

$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}

$Prev_Page = $Page-1;
$Next_Page = $Page+1;

$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}

$strSQL .=" order by id ASC LIMIT $Page_Start , $Per_Page";
$objQuery = mysql_query($strSQL);

?>
 <TABLE ALIGN="center" BORDER="0" 
    CELLSPACING="0" WIDTH="200" HEIGHT="200" BGCOLOR="green">
<table width="600" border="1">
<tr>
<TH VALIGN="middle">
<table align="center" border="0" width="50%"
      cellspacing="0" width="100" height="100"
      bgcolor="ivory">

<th width="98"> <div align="center">id</div></th>
<th width="98"> <div align="right">product_name </div></th>
<th width="98"> <div align="center">price </div></th>
<th width="98"> <div align="center">details </div></th>

</tr>  

<?  
while($objResult = mysql_fetch_array($objQuery))  
{  
?> 

<tr>  


<td><?=$objResult["id"];?></td>
<td align="left" width="100><?=$objResult['product.php'];?> <td align="left" width="100"><a href='product.php?id=<?=$objResult['id'];?>'><?=$objResult['product_name'];?></a></td></td>




<td><?=$objResult["price"];?></td>
<td><?=$objResult["details"];?></td> 
</tr> 
 
<?  
}  
?> 
</th>
</table>  
<br> 


Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
<?
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&txtKeyword=$_GET[txtKeyword]'><< Back</a> ";
}

for($i=1; $i<=$Num_Pages; $i++){
if($i != $Page)
{
echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i&txtKeyword=$_GET[txtKeyword]'>$i</a> ]";
}
else
{
echo "<b> $i </b>";
}
}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page&txtKeyword=$_GET[txtKeyword]'>Next>></a> ";
}

mysql_close($objConnect);
}
?>
</body>
</html>

snapshoot

Please explain your problem a bit clearer.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.