Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

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

0
flashjordan
Asked:
flashjordan
1 Solution
 
youssefomarCommented:
Hi,
you can use Ajax to call your php with out refreshing the page, and use <div> instead of iframe.

here is a good Ajax tutorial: http://www.w3schools.com/Ajax/Default.Asp
cheers
0
 
flashjordanAuthor Commented:
Thanks, I will look into the link you sent
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now