Jump to content

Simple search nooby help


BUX

Recommended Posts

I will post here the code of a page which lists items found in one of my dbs.

I would like to enter e search feature. I have inserted the form and set a variable for the entered word, also tried following a few tutorials but it got a bit complicated.

I would like the page to display all the items at first and the searched items if a search is done.

Could anyone help me recode this?

 

Thanks in advance.

 

<html>
<TITLE>Data List Page</TITLE>
<body>
<?php

$username="XXXXX";
$password="XXXXX";
$database="XXXXX";
$var = @$_GET['word'] ;
$trimmed = trim($var); 

mysql_connect('192.168.0.1',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM filez 
	ORDER BY name ASC";

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>

<table width="835" border="1" align="center">
<tr>
<th width="311"><font face="Arial, Helvetica, sans-serif">Name</font></th>
<th width="417"><font face="Arial, Helvetica, sans-serif">File</font></th>
<th width="85"><font face="Arial, Helvetica, sans-serif">Download</font></th>
</tr>
</table>

<form name="form" action="search.php" method="get">
<table width="835" border="0" align="center">
  <tr bgcolor="#FFFFFF">
    <td width="146" ><input type="text" name="word" /></td>
    <td width="679"><input type="submit" name="submit" value="Search" /></td>
</tr>
</table>
</form>
<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"name");
$f2=mysql_result($result,$i,"file");
?>
<table width="835" border="0" align="center">
<tr bgcolor="#66FFFF">
<td width="311"><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td width="417"><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td width="85"><font face="Arial, Helvetica, sans-serif"><a href="http://www.inducedvision.com/XXXX/<?php echo $f2; ?>" title="DOWNLOAD FILE" target="_self">Link</a></font></td>
</tr>
</table>

<?php
$i++;
}
?> 
</body>
</html>

Link to comment
https://forums.phpfreaks.com/topic/180700-simple-search-nooby-help/
Share on other sites

Thank you for the fast reply, indeed this is a tutorial showing a search engine, but it seemns quite complicated for me to blend it into my page (i have read it b4), i have a found an 'easier' version of a search engine here http://www.spoono.com/php/tutorials/tutorial.php?id=12 but although this includes less code im having trouble inserting it into my page, and mainly having the page display all the items at first and the searched ones after a search is done.

 

Am I supposed to enter an if loop containing the html which displays the fields, corresponding to the $search or sometihng like that?

 

 

here is my updated code

 

<html>
<TITLE>Data List Page</TITLE>
<body>
<?php

$username="XXXXX";
$password="XXXXX";
$database="XXXXX";
$search=@$_GET['word'] ;

mysql_connect('192.168.0.1',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM filez 
	ORDER BY name ASC";

$result=mysql_query($query);
$resultsearch=mysql_query("SELECT * FROM filez WHERE name LIKE '%$search%' ORDER BY name ASC");

$num=mysql_numrows($result);

mysql_close();
?>

<table width="835" border="1" align="center">
<tr>
<th width="311"><font face="Arial, Helvetica, sans-serif">Name</font></th>
<th width="417"><font face="Arial, Helvetica, sans-serif">File</font></th>
<th width="85"><font face="Arial, Helvetica, sans-serif">Download</font></th>
</tr>
</table>

<form action="search.php" method="gett">
<table width="835" border="0" align="center">
  <tr bgcolor="#FFFFFF">
    <td width="146" ><input type="text" name="word" /></td>
    <td width="679"><input type="submit" name="submit" value="Search" /></td>
</tr>
</table>
</form>
<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"name");
$f2=mysql_result($result,$i,"file");
$f3=mysql_result($resultsearch,$i,"name");
$f4=mysql_result($resultsearch,$i,"file");
?>
<table width="835" border="0" align="center">
<tr bgcolor="#66FFFF">
<td width="311"><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td width="417"><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td width="85"><font face="Arial, Helvetica, sans-serif"><a href="http://www.inducedvision.com/XXXX/<?php echo $f2; ?>" title="DOWNLOAD FILE" target="_self">Link</a></font></td>
</tr>
</table>

<?php
$i++;
}
?> 
</body>
</html>

the loop in the link I showed you is verifying how many results there is going to be. Without the loop it would display everything in your database. To display a close search, you might want to try and create your own boolean system that displays keywords in the text and compare it to the database. Mentioning the closest results first. I personally cannot recall a boolean operator function, but I'm sure there is one.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.