Search function

[mudmin]

So this is a pretty detailed walkthrough on how to make a search function....
http://www.webreference.com/programming/...index.html

The only real difference is that you have to combine it with the UserSpice db class.

On the second page where it says //connect to the database, you can just use

Code:

$db = DB::getInstance();

And you only have to do that once per page.

Then your query looks a little different. You do something like this...

Code:

$x=$_POST['x'];

Code:

$query = $db->query("SELECT * FROM users WHERE username = ?", array($x));

I can help you with the exact queries you need if you get stuck. The big difference is instead of doing

Code:

$sql =""

you do

Code:

$query = $db->query("")

I need to do some refomatting on the page, but you should definitely check out the instructions on the db class.
http://userspice.org/documentation-db-class-2/