portfolio oop4 and oop5 page

Language: SQL
INSERT INTO `user_friends` (`user_friend_id`, `user_id`, `friend_id`) VALUES
(1, 1, 3),
(2, 1, 5),
(3, 2, 2),
(4, 2, 5),
(5, 3, 4),
(6, 3, 2),
(5, 4, 1),
(5, 4, 2),
(5, 5, 1),
(5, 5, 3);

Language: SQL
> INSERT INTO `user_friends` (`user_friend_id`,
> `user_id`, `friend_id`) VALUES
> (1, 1, 3),
> (2, 1, 5),
> (3, 2, 2),
> (4, 2, 5),
> (5, 3, 4),
> (6, 3, 2),
> (5, 4, 1),
> (5, 4, 2),
> (5, 5, 1),
> (5, 5, 3);
>

Language: HTML
<select >
       <option value="Peter Pan">Peter Pan</option>
</select>

Language: PHP
<?php
include(';user.php';);
	$con = mysql_connect("......") // you show this anyone can access your code!
		or die ("Could not connect to server");
	mysql_select_db("....)
		or die ("Could not select database");
 
?>		
<form action="user_find.php"method="post">
 
<select name="user">
 
 
<?php	
//tip: if form is submitted
		$query="SELECT full_name FROM users";
		$result=mysql_query($query);
			while($row=mysql_fetch_array($result))
				{
				$name=$row[full_name];
				echo "<option>
				$name
				</option>";
				}
?>
</select>
<input type="submit" value="Submit">
</form>
<?php
 echo "<p>User name: ".$_REQUEST["user"];
 ?>
 
 
<?php
	$user=new User();
	$user->getUserById($user_id);
	echo "<p>User known as: ".$user->getDisplayName()."</p>";
 
 
	$friends=$user->getFriends();
 
	echo "<p>Friends with: ".implode(';,';,$friends) . "</p>";
 
 
	.......
 
 
 
//tip: else show a form with the list of users as shown in the screenshot in oop4
 
 
?>
 
 
 
<?php
mysql_close($con);
?>

Language: PHP
<?php
class User
	{
	public function getUserById($user_id)
		{
 
		$sql ="SELECT first_name,last_name,display_name FROM users WHERE user_id=';$user_id';";
		$....
			}
 
	}
?>

Language: PHP
if($submit==';Submit';){
// manage the form input and show friends
}
else {
 
// show form
 
}

Language: PHP
if(isset($_REQUEST["users"])){
  $sql = ';SELECT * FROM users';;
  $results = mysql_query($sql) or die("Query failed: ". mysql_error());
  $row = mysql_fetch_array($results);
  $ID = $row[';user_id';];
  $user = new User();
  $user->getUserById($ID);

Language: PHP
<?php
if($_POST[';formSubmit';] == "Submit")
{	
 
$user=new User();
$user->getUserById($ID);
echo "<p>User known as: ".$user->getDisplayName()."</p>";
 
 
$friends=$user->getFriends();
echo "<p>Friends with: ".implode(';,';,$friends) . "</p>";
 
$user->getUserById($ID);
echo "<p>User known as: ".$user->getDisplayName()."</p>";

Language: PHP
public function getFriends(){
    $sql = ';SELECT users.first_name FROM users, user_friends WHERE user_friends.friend_id =';. $this->user_id;
    $results = mysql_query($sql) or die ("Query2 failed: ". mysql_error());

Language: PHP
public function showFriends($friendID){
    $sql = ';SELECT first_name FROM users WHERE user_id =';. $friendID;
    $results = mysql_query($sql) or die("Query3 failed: ". mysql_error());
    $friendNames = array();

Language: PHP
$results = mysql_query($sql) or die ("Query2 failed: ". mysql_error());  
while ($row = mysql_fetch_array($results)){                             
      echo "<tr><td>Friends with ". $row[';first_name';]. " ". $row[';last_name';]. "<br>";  
    }