Untitled

<?php

$hostname = ‘localhost’;
$user = ‘root’;
$password = ‘ ‘;
$mysql_database = ‘userinfo’;
$db = mysql_connect($hostname, $user, $password, $mysql_database);
mysql_select_db(“userinfo”,$db);


if(isset($_GET['Submit'])){

    // Retrieve data

    $id = $_GET['id'];

    $getid = "SELECT first_name, last_name, department, position, username, pass FROM users WHERE user_id = '$id'";
    $result = mysql_query($getid) or die('<pre>' . mysql_error() . '</pre>' );

    $num = mysql_numrows($result);

    $i = 0;

    while ($i < $num) {

        $first = mysql_result($result,$i,"first_name");
        $last = mysql_result($result,$i,"last_name");
        $department = mysql_result($result,$i,”department”);
        $position = mysql_result($result,$i,”position”);
        $username = mysql_result($result,$i,”username”);
        $pass = mysql_result($result,$i,”pass”);

        echo '<pre>';
        echo 'ID: ' . $id . '<br>First name: ' . $first . '<br>Surname: ' . $last. '<br>Department: ' . $department. '<br>Position: ' . $position. '<br>username: ' . $username. '<br>Password: ' . $pass;
        echo '</pre>';

        $i++;
    }
}
?>
<html>

<h1> User ID </h1>
	<form action=“#” method = “GET”>
	<input type = “text” name “id”>
	<input type = “submit” name = “Submit” value = “Submit”>
	</form>

</html>