A8 : iMe

New Skills

Description

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.

Code

```
<?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
```