Tutor search

grahamgilbert (Graham Gilbert) — Wed, 05 Dec 2007 16:20:24 GMT

// Search results page - formatting html has been omited.





		// The basic SELECT statement

		$select = 'SELECT id, title, forename, surname, userlevel';

		$from = ' FROM users';

		$where = " WHERE userlevel='2'";



		$forename = $_POST['forename'];

		if ($forename !='') { //Forename was specified

		$where .= " AND forename LIKE '%$forename%'";



		$surname = $_POST['surname'];

		if ($surname !='') { //Surnamename was specified

		$where .= " AND surname LIKE '%$surname%'";

		}

		?>



		$users = @mysql_query($select . $from . $where);

	if (!$users) {

	exit ('Unable to abtain user list from the database');

	}



	?>

	



	while ($user = mysql_fetch_array($users)) {

	echo "\n";

	$id = $user['id'];

	$username = htmlspecialchars($user['username']);

	$title = htmlspecialchars($user['title']);

	$forename = htmlspecialchars($user['forename']);

	$surname = htmlspecialchars($user['surname']);


	echo "\n";

	echo "\n";

	echo "\n";

	}

	?>


	Username Title Forename Surname Options

	
$username $title $forename $surname Edit | Delete

DZone Snippets: Grahamgilbert's Code Snippets

Tutor search