Online PHP editor | perf for cRfE1

<?php //************************************************************* // place $req_status any where it will show the button/msg etc //************************************************************* //$user_email = email@example.com // get id by matching email address $result = mysql_query("SELECT id FROM tbluser WHERE email = '$user_email'"); if (!$result) { echo 'Could not run query'; } $row = mysql_fetch_assoc($result); $user_id = $row['id']; // id of the user //logged in. I assumed that you have the user id and profile id as follows. //$_SESSION['user_id'] = $user_id; if($_GET['fid']){ // ---------------------------------------------------- $friend_id = $_GET['fid']; // profile user id. // it shows "Friends" if user is friend. or "Add friend" or "Request pending" $query1="SELECT * FROM friends WHERE (user_id = '$user_id' AND friend_id = '$friend_id') OR (friend_id = '$friend_id' AND user_id = '$user_id')"; $result = mysql_query($query1); $row = mysql_num_rows($result); if ($row == 1) { // exist, whether it's active or not while($row = mysql_fetch_assoc($result)) { if ($row['status'] == 1) { echo "Friends"; } elseif ($row['status'] == 0) { if($row['user_id'] == $user_id){ $req_status = "Request pending"; //echo "Request pending"; } elseif($user_id == $row['friend_id'] { $req_status = "<a href='add_friend.php?fid=".$row["user_id"]."'>Accept request</a>"; } } else { if($row['user_id'] == $user_id){ $req_status = "Request pending"; //echo "Request pending"; } else { $req_status = '<a href="add_friend.php?fid='.$friend_id.'">Add Friend</a>'; //echo "<a href='add_friend.php?fid=".$friend_id."'>Add Friend</a>"; } } } } else { // if the relationship don't exist $req_status = '<a href="add_friend.php?fid='.$friend_id.'">Add friend</a>'; //echo "<a href='add_friend.php?fid=".$friend_id."'>Add friend</a>"; } // ---------------------------------------------------- } ?>

Version	System time (s)	User time (s)	Memory (MiB)
5.4.16	0.008	0.042	12.39
5.4.15	0.006	0.041	12.38
5.4.14	0.008	0.043	12.07
5.4.13	0.009	0.041	12.05
5.4.12	0.008	0.042	12.02
5.4.11	0.008	0.040	12.02
5.4.10	0.007	0.044	12.02
5.4.9	0.009	0.045	12.02
5.4.8	0.007	0.044	12.01
5.4.7	0.006	0.047	12.01
5.4.6	0.007	0.037	12.01
5.4.5	0.007	0.040	12.01
5.4.4	0.005	0.040	12.00
5.4.3	0.005	0.042	11.99
5.4.2	0.005	0.039	11.99
5.4.1	0.006	0.038	11.99
5.4.0	0.004	0.042	11.48
5.3.26	0.006	0.043	12.72
5.3.25	0.006	0.038	12.72
5.3.24	0.006	0.038	12.72
5.3.23	0.008	0.041	12.71
5.3.22	0.008	0.043	12.68
5.3.21	0.006	0.040	12.68
5.3.20	0.008	0.038	12.68
5.3.19	0.007	0.039	12.68
5.3.18	0.010	0.043	12.67
5.3.17	0.009	0.039	12.67
5.3.16	0.007	0.041	12.67
5.3.15	0.009	0.039	12.67
5.3.14	0.008	0.039	12.66
5.3.13	0.009	0.042	12.66
5.3.12	0.009	0.039	12.66
5.3.11	0.006	0.041	12.66
5.3.10	0.006	0.037	12.12
5.3.9	0.011	0.041	12.09
5.3.8	0.010	0.050	12.08
5.3.7	0.008	0.039	12.08
5.3.6	0.007	0.043	12.06
5.3.5	0.008	0.041	12.00
5.3.4	0.007	0.043	12.00
5.3.3	0.009	0.037	11.95
5.3.2	0.005	0.040	11.73
5.3.1	0.007	0.036	11.69
5.3.0	0.006	0.038	11.68