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"> </td>
<td width="120"> </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
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"> </td>
<td width="120"> </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>';
}
?>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER