Here is my test2.php File this is all the code im using and after the code i have pasted a sample of what my Table Looks like.
No mater what i search for it will allways return all of the data that i have in the table but if i just use a select line like this.
----------
$sql = "SELECT * FROM coffee_inventory WHERE roast_type LIKE '%$sbox%'";
----------
It works perfectly but i need it to search each field for what the user entered. i have tried to make the script do multipul querys but that will result in doubles of items
Any help is greatly Appreciated
Thanks, Robert
---( Test2.php )---
<head><title>Digital Playground - PHP Database Gateway</title></head>
<body bgcolor=#000000 text=#FFFFFF>
<img src=http://www.phpbuilder.com/images/title.jpg>
<br><hr><p>
<center>
<table>
<tr><td width=800>
<?php
if (!$submit)
{
echo "<center><form method=get action=index.php>
<INPUT TYPE=TEXT NAME=sbox MAXLENGTH=100 SIZE=40 VALUE= >
<INPUT TYPE=submit NAME=submit VALUE= search >
</form>
<p><font face=arial,helvetica size=-1>
Enter <B>one or more words</B> to search for. If you want to specify more than one word,
use a space as a separator. Example : <I>death dismemberment</I> for all topics dealing
with both death and dismemberment.</font></center>";
}
?>
<?php
if ($submit)
{
$xcount = 0;
$connection = mysql_connect("localhost","user","pass");
if (!$connection) { echo "Couldn't make a connection!"; exit; }
$db = mysql_select_db("myDB", $connection);
if (!$db) { echo "Couldn't select database!"; exit; }
$sql = "SELECT * FROM coffee_inventory WHERE roast_type OR coffee_name OR quantity OR link LIKE '%$sbox%'";
$sql_result = mysql_query($sql,$connection);
echo "<CENTER><TABLE BORDER=1 width=640>";
echo "<TR><TH>Coffee Name</TH><TH>Roast Type</TH><TH>Quantity</TH><TH>Links</TH>";
while ($row = mysql_fetch_array($sql_result))
{
$coffee_name = $row["coffee_name"];
$roast_type = $row["roast_type"];
$quantity = $row["quantity"];
$link = $row["link"];
echo "<TR><TD> $coffee_name </TD><TD> $roast_type </TD><TD> $quantity </TD><TD><CENTER> $link </CENTER></TD></TR>";
$xcount = $xcount + 1;
}
echo "<P><b>$xcount Results found for:</b> $sbox";
echo "</TABLE></CENTER>";
echo "<p><center><a href=http://www.phpbuilder.com/board/archive/index.php/javascript:history.go(-1)>Return to Main Search Page</a></center>";
mysql_free_result($sql_result);
mysql_close($connection);
}
?>
</td></tr>
</table>
</center>
</body>
---( END Test2.php )---
Here is what my database looks like:
DB: myDB
Table: Coffee_Inventory
Fields:
Coffee_Name, Roast_type, Quantity, Link
Data:
coffee1 dark 36 <!-- w --><a class="postlink" href="http://www.coffee1.com">www.coffee1.com</a><!-- w -->
coffee2 medium 31 <!-- w --><a class="postlink" href="http://www.coffee2.com">www.coffee2.com</a><!-- w -->
coffee3 dark 56 <!-- w --><a class="postlink" href="http://www.coffee3.com">www.coffee3.com</a><!-- w -->
coffee4 light 12 <!-- w --><a class="postlink" href="http://www.coffee4.com">www.coffee4.com</a><!-- w -->
coffee5 dark 26 <!-- w --><a class="postlink" href="http://www.coffee5.com">www.coffee5.com</a><!-- w -->
coffee6 medium 41 <!-- w --><a class="postlink" href="http://www.coffee6.com">www.coffee6.com</a><!-- w -->
coffee7 light 23 <!-- w --><a class="postlink" href="http://www.coffee7.com">www.coffee7.com</a><!-- w -->
And as far as Setting things as Primary or Indexed or things like that i have no clue what they are so i dident use them
I hope this will help you help me.
No mater what i search for it will allways return all of the data that i have in the table but if i just use a select line like this.
----------
$sql = "SELECT * FROM coffee_inventory WHERE roast_type LIKE '%$sbox%'";
----------
It works perfectly but i need it to search each field for what the user entered. i have tried to make the script do multipul querys but that will result in doubles of items
Any help is greatly Appreciated
Thanks, Robert
---( Test2.php )---
<head><title>Digital Playground - PHP Database Gateway</title></head>
<body bgcolor=#000000 text=#FFFFFF>
<img src=http://www.phpbuilder.com/images/title.jpg>
<br><hr><p>
<center>
<table>
<tr><td width=800>
<?php
if (!$submit)
{
echo "<center><form method=get action=index.php>
<INPUT TYPE=TEXT NAME=sbox MAXLENGTH=100 SIZE=40 VALUE= >
<INPUT TYPE=submit NAME=submit VALUE= search >
</form>
<p><font face=arial,helvetica size=-1>
Enter <B>one or more words</B> to search for. If you want to specify more than one word,
use a space as a separator. Example : <I>death dismemberment</I> for all topics dealing
with both death and dismemberment.</font></center>";
}
?>
<?php
if ($submit)
{
$xcount = 0;
$connection = mysql_connect("localhost","user","pass");
if (!$connection) { echo "Couldn't make a connection!"; exit; }
$db = mysql_select_db("myDB", $connection);
if (!$db) { echo "Couldn't select database!"; exit; }
$sql = "SELECT * FROM coffee_inventory WHERE roast_type OR coffee_name OR quantity OR link LIKE '%$sbox%'";
$sql_result = mysql_query($sql,$connection);
echo "<CENTER><TABLE BORDER=1 width=640>";
echo "<TR><TH>Coffee Name</TH><TH>Roast Type</TH><TH>Quantity</TH><TH>Links</TH>";
while ($row = mysql_fetch_array($sql_result))
{
$coffee_name = $row["coffee_name"];
$roast_type = $row["roast_type"];
$quantity = $row["quantity"];
$link = $row["link"];
echo "<TR><TD> $coffee_name </TD><TD> $roast_type </TD><TD> $quantity </TD><TD><CENTER> $link </CENTER></TD></TR>";
$xcount = $xcount + 1;
}
echo "<P><b>$xcount Results found for:</b> $sbox";
echo "</TABLE></CENTER>";
echo "<p><center><a href=http://www.phpbuilder.com/board/archive/index.php/javascript:history.go(-1)>Return to Main Search Page</a></center>";
mysql_free_result($sql_result);
mysql_close($connection);
}
?>
</td></tr>
</table>
</center>
</body>
---( END Test2.php )---
Here is what my database looks like:
DB: myDB
Table: Coffee_Inventory
Fields:
Coffee_Name, Roast_type, Quantity, Link
Data:
coffee1 dark 36 <!-- w --><a class="postlink" href="http://www.coffee1.com">www.coffee1.com</a><!-- w -->
coffee2 medium 31 <!-- w --><a class="postlink" href="http://www.coffee2.com">www.coffee2.com</a><!-- w -->
coffee3 dark 56 <!-- w --><a class="postlink" href="http://www.coffee3.com">www.coffee3.com</a><!-- w -->
coffee4 light 12 <!-- w --><a class="postlink" href="http://www.coffee4.com">www.coffee4.com</a><!-- w -->
coffee5 dark 26 <!-- w --><a class="postlink" href="http://www.coffee5.com">www.coffee5.com</a><!-- w -->
coffee6 medium 41 <!-- w --><a class="postlink" href="http://www.coffee6.com">www.coffee6.com</a><!-- w -->
coffee7 light 23 <!-- w --><a class="postlink" href="http://www.coffee7.com">www.coffee7.com</a><!-- w -->
And as far as Setting things as Primary or Indexed or things like that i have no clue what they are so i dident use them
I hope this will help you help me.