form textbox with search
| From: | Anthony Ritter | Date: | Wed, 21 Apr 2004 02:39:46 +0000 |
| Subject: | form textbox with search | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-184076@lists.php.net to get a copy of this message | ||
Greets,
The following code snippet receives data from a textbox named searchtext if
the user types in a word.
It then tries to match that word from the mysql database using:
$searchtext = $_POST['searchtext'];
if ($searchtext != '') { // Some search text was specified
$where .= " AND blurb LIKE '%$searchtext%'";
}
and adding on to the WHERE sql statement.
If the user clicks the submit _without_ inserting a word, the whole database
is output due to the basic select sql statement of:
$select = 'SELECT DISTINCT merch.ID, merch.blurb, merch.price';
$from = ' FROM merch';
$where = ' WHERE 1=1 ';
I am trying to work out a way to display a page that might say - "Please
enter a word" if the user fails to insert a word in the textbox.
Any help greatly appreciated.
TR
.................
<?php
$dbcnx = mysql_connect('localhost', 'root', 'mypass');
mysql_select_db('sitename');
// The basic SELECT statement
$select = 'SELECT DISTINCT merch.ID, merch.blurb, merch.price';
$from = ' FROM merch';
$where = ' WHERE 1=1 ';
$lid = $_REQUEST['lid'];
if ($lid != '') { // An lot is selected
$where .= " AND lid='$lid'";
}
$searchtext = $_POST['searchtext'];
if ($searchtext != '') { // Some search text was specified
$where .= " AND blurb LIKE '%$searchtext%'";
}
?>
<table border="1" align="center">
<tr><th>Click for
details</th><th>Description</th><th>Price</th><th>Edit</th><th>Delete</th><t
h>Photo</th></tr>
//etc.............