PHP MySQL Search Script.

[JonW]

I am trying to write a php script that searches for given information in a database and returns the result in a variable. I have created an image that better explains what I am trying to accomplish. I appreciate the help!

http://mantisclan.com/mysql.jpg

[Alan]

Hmm looks like a phpBB3 table... So you want to pass in a username and return the associated user id?

Anyway, the following should work...

Assumptions:

the table name is 'user'
database details are already predefined in the following constants (DB_HOST, DB_USER, DB_PASS, DB_NAME)




function fetchUserID($username) {
// Establish a database connection
$db = new MySQLi(DB_HOST, DB_USER, DB_PASS, DB_NAME);
// Clean the input so it's not malicious
$username = $db->real_escape_string($username);
// Construct the SQL query
$sql = "SELECT user_id FROM users WHERE username = '$username'";
// Execute the query in the database
$result = $db->query($sql);
// If there was only one result returned, grab the user_id and return it, otherwise return false
if($result->num_rows == 1) {
$dataArray = $result->fetch_assoc();

return $dataArray['user_id'];
}

return false;
}

$user_id = fetchUserID('Admin');
echo $user_id; // Should print out "2"