Similar to the display_all.php file this script uses radio buttons to determine which field of data the user wishes to view.
The process is very similar to the display_all.php page the only difference is the amount of coding behind the process.
<?php
$first_name = "unchecked";
$last_name = "unchecked";
$user_name = "unchecked";
$password = "unchecked";
if (isset($_POST["submit"])){echo "<br />";
require_once ("mysql_connect.php");echo "<br />";
$selected_radio = $_POST["details"];
if ($selected_radio == "first_name"){$first_name = "checked";
echo "<h3>First name selected</h3>";
$result = mysql_query("SELECT first_name FROM users")or die(mysql_error());
while($row = mysql_fetch_array($result)){echo "<br /><p><b>First name:</b> ".$row["first_name"], "</p>";}
}
else if ($selected_radio == "last_name"){$last_name = "checked";
echo "<h3>Last name selected</h3>";
$result = mysql_query("SELECT last_name FROM users")or die(mysql_error());
while($row = mysql_fetch_array($result)){echo "<br /><p><b>Last name:</b> ".$row["last_name"], "</p>";}
}
else if ($selected_radio == "user_name"){$user_name = "checked";
echo "<h3>User name selected</h3>";
$result = mysql_query("SELECT user_name FROM users")or die(mysql_error());
while($row = mysql_fetch_array($result)){echo "<br /><p><b>User name:</b> ".$row["user_name"], "</p>";}
}
else if ($selected_radio == "password"){ $password = "checked";
echo "<h3>password selected</h3>";
$result = mysql_query("SELECT password FROM users")or die(mysql_error());
while($row = mysql_fetch_array($result)){echo "<br /><p><b>User name:</b> ".$row["password"], "</p>";}
}
}
?>
//Start PHP protocol
//Define if checked
//Define if checked
//Define if checked
//Define if checked
//When submit is clicked
//Print line break
//Connect to the database
//Print line break
//Post from name="details"
//If first_name is selected
//Define variable
//Print title
//Acumalate first_name data from database
//Or end
//Loop results
//Print first_name
//End if
//If last_name is selected
//Define variable
//Print title
//Acumalate last_name data from database
//Or end
//Loop results
//Print last name
//End if
//If user_name is selected
//Define variable
//Print title
//Acumalate user_name data from database
//Or end
//Loop results
//Print user_name
//End if
//If password is selected
//Define variable
//Print title
//Acumalate first_name data from database
//Or end
//Loop results
//Print first name
//End if
//End submit if
//End PHP protocol