MySQL PHP Search

mccrum · 24 Apr 2010 at 19:04

Hey, I have data stored in a MySQL Database and im looking to let a user be able to search the database. Using a text input and submit form.

I am a beginner to PHP so if anyone knows any tutorials or anything that would be great.

roid · 24 Apr 2010 at 19:07

http://www.php.net/manual/en/mysql.examples-basic.php

Should be enough to get you started.

mccrum · 24 Apr 2010 at 19:17

I can display the data fine, want to be able to search the data :-)

daz · 24 Apr 2010 at 20:00

select * from tblPeople where firstName like '%mccrum%'

Would search the tblPeople for the firstName column for rows containing 'mccrum'

UncleRuckus · 24 Apr 2010 at 20:37

daz said:
select * from tblPeople where firstName like '%mccrum%'

Would search the tblPeople for the firstName column for rows containing 'mccrum'

This.

I believe it also looks for names "like" mccrum so occrum should show up too, right? I forget what the percentage signs are for though.

roid · 24 Apr 2010 at 20:42

% is a wild card operator in sql:

http://www.brainbell.com/tutorials/MySQL/Using_The_LIKE_Operator.htm

RimBlock · 26 Apr 2010 at 03:52

mccrum said:
I can display the data fine, want to be able to search the data

Just to clarify, are you saying you want to pull the un filtered recordset back from the database and then search using PHP rather than searching on the database and bringing back only matching results ?

RB