Database search engine

hi..
first of all i want to sorry about my bad english.
how do i make php script for searching in mysql database ?
i want to make a student search..
the field is student_number, name, address, and faculty.
what would the php script look like ?

Thanks

I'm not too clear on the details of what you're asking, but the script might look something like this.


First we need to define the query we'll be using:
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
<?
mysql_connect($mysqlServer,$mysqlUser,$mysqlPassword);
mysql_select_db($mysqlDB);
if($student_id){$searchResult=mysql_query("select * from tableName where student_id='$student_id'");}
elseif($name){$searchResult=mysql_query("select * from tableName where name like '%$name%'");}
elseif($address){$searchResult=mysql_query("select * from ...
?>
[/quote]

Then you need to read the information out:

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
<?
while($student=mysql_fetch_array($searchResult)){
echo "ID: $student[student_id]<br>";
echo "Name: $student[name]<br>";
echo "Address: $student[address]<br>";
echo "Faculty: $student[faculty]<br><br>";
}
?>
[/quote]

That may not be exactly what you want, but I hope it helps....

This is kind of on the same topic:

How do you cut up or format the variable before it the search begins?
For example, if the datebase has the student name as 'Steve Smith', but the user enters 'Smith, Steve' how can I split this string and search the whole database for all occurences of steve and smith?
thanks.
michael

If the bits are always going to be delimited by a comma, then one can split the string by the comma and then -

$command = "select * from table where
name like '%$name1%' or
name like '%name2%';";

then mysql_db_query.. etc.

chyrag.


[This message has been edited by chyrag (edited 07-27-99).]

Thanks.
What if there isn't a comma? What you have no control over how they enter it? How do you just dice up the string into individual complete words?
-michael

Michael,

There might be a function that will splice a string into each individual word. I'm not sure but explode comes to mind.

Or, you would have to develop a script that will read each character and build a word letter by letter and when a comma or space appears use it as a marker that the word ended.


Hope this helps.