Link to home
Start Free TrialLog in
Avatar of flashjordan
flashjordan

asked on

PHP Search return results within page no refresh

Hi,
I have a search in PHP for a MYSQL database that returns the results to an iframe. The problem is tha I need it to return the results not in an iframe and without refreshing the page. At the moment I am using the following form

<form id="searcher" name="searcher" method="post" action="dosearch.php" target="searchdisplay">
                                <tr>
                                  <td width="248">Search Innovente Products</td>
                                  <td width="27">&nbsp;</td>
                                  <td width="120">&nbsp;</td>
                                  <td align="right"><input name="search" type="text" id="search" size="35" />
                                    <label>
                                      <input type="submit" name="button" id="search" value="Search" />
                                    </label></td>
                                </tr>
                              </form>

With the code in the snippet below to do the search

Can the search be done and eturn the results without using an iframe and without refreshing the page?

Thanks for any help in advance
<?php
include 'admin/connect.php';
$search=mysql_real_escape_string(stripslashes($_POST['search']));
$res=mysql_query('SELECT id,tdstitle,subheading,supplier,dat,category,imageid FROM technicaldata WHERE MATCH(tdstitle,keywords,subheading) AGAINST("'.$search.'" IN BOOLEAN MODE)',$dbh) or die(mysql_error());
$num=mysql_num_rows($res);
for($run=0; $run<$num; $run++)
{
$val=mysql_fetch_row($res);
 
echo '<table width="800" border="0" cellspacing="0" cellpadding="0" bgcolor="'.$col.'">
<tr>
  <td height="40" align="right" valign="middle"><table width="800" height="22" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="263" align="left" class="mainTXT12LEFT"><a href="image.php?a='.$val[6].'"><span class="Formtitles13">'.$val[1].'</span></td>
      <td width="327" align="left" class="mainTXT12LEFT">'.$val[2].'</td>
      <td width="110" height="22" align="left"><span class="mainTXT12LEFT">'.$val[4].'</span></td>
      <td width="41" align="left"><a href="imagedownload.php?a='.$val[6].'"><img src="images/download.gif" alt="Download TDS" width="30" height="22" border="0"></a></td>
      <td width="39" align="center" class="maineleven_BK"><a href="image.php?a='.$val[6].'&TB_iframe=true&height=760&width=730" rel="sexylightbox" onClick="self.parent"><img src="images/tds.gif" alt="View TDS" width="30" height="22" border="0"></a></td>
	   </tr>
  </table></td>
</tr>
<tr>
      <td height="1" align="center" valign="top"><img src="images/greenspacer.gif" width="800" height="1"></td>
  </tr>
</table>';
}
?>

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of youssefomar
youssefomar
Flag of Libya image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of flashjordan
flashjordan

ASKER

Thanks, I will look into the link you sent