search text field in database

[ratebuster]

hi,

m using mysql database with php 4.0.

problem is that, m making a form with a text field in it and i want user to enter text
so tht this text entry can be searched in the database, say a file name for example.

i do no how to do it 😕 😕

plz reply asap . thanks 🙂

[bretticus]

Searched "php search database" in google. Lots of results. Here's one.

[Ashley_Sheridan]

OK, do you have your database connection set up in PHP?

If not, this code should do it:

$dbhost = 'localhost';
$dbname = 'database_name';
$dbuser = 'root';
$dbpasswd = '';

// access MySQL
$dbc = mysql_connect ($dbhost, $dbuser, $dbpasswd);

// access the database
mysql_select_db ($dbname);

From here, you can call a query that searches a particular field in the database:

$query = "SELECT * FROM `table_name` WHERE `text_field`='%{$_REQUEST['search_text']}%'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
    // do something with the returned row data here
}

The % characters in the query tell MySQL that you want to perform a wildcard search (they work like the * in DOS or the Linux terminal)