Online PHP editor | perf for kNJpk

<?php include "config.php"; //the database configuration file. Update this to connect to your databse //function to regiter function register($username,$password,$email) { //find the next userid $query="select max(Id) as total from accounts"; $results=mysql_query($query) or die(mysql_error()); if($results){ $row=mysql_fetch_row($results);//store the result in $row array $user_id=++$row['0'];//increment the currnet user_id by 1 } //encrypt the password using md5 $enc_password=md5($password); mysql_free_result($results);//free the result //insert new registration details to database $query="insert into accounts(Id,Name,Password,Email,AccessLevel,Membership,LastOnlineUtc,Coins)"; $query=$query."values('".$user_id."','".$username."','".$enc_password."','".$email."','"."0"."','"."0"."','"."0"."','"."0"."')"; $results=mysql_query($query) or die(mysql_error()); if($results) { echo 'Welcome '.$username.'!'; echo " ... Account successfully registered!"; return 1; } else { echo "Registration failed"; return 0; } } //function to activate the user. Give the user id as the parameter. function activate_user($user_id){ $query="update accounts set Membership=1 where Id=".$user_id; $results=mysql_query($query) or die(mysql_error()); if(!$results) { echo "The account has been activated!"; } } //check if the form was submitted if((isset($_POST['Submit']) && $_POST['Submit']=="Register")) { //check whether the username and e-mail already exist or not $sql="select Name,Email from accounts where Name='".$_POST['username']."' or Email='".$_POST['email']."'"; $results=mysql_query($sql) or die(mysql_error()); if(mysql_num_rows($results)>0) { $row=mysql_fetch_row($results); //check if username exists if($_POST['username']==$row['0']) { echo "Username already taken!"; } //check if e-mail exists elseif($_POST['email']==$row['1']) { echo "The e-mail already used for registration!"; } else { //if username and e-mail not used, register the new user to database register($_POST['username'],$_POST['password'],$_POST['email']); } } else { //register new user to access register($_POST['username'],$_POST['password'],$_POST['email']); } }else{ ?> <!---- the form to take input ----!> <html> <body> <form action="<? $_SERVER['PHP_SELF'] ?>" method="post"> <input type="text" value="username" align="LEFT" name="username" /> <br> <input type="password" value="password" name="password" /> <br> <input type="text" value="email" name="email" /> <br> <input type="submit" value="Register" name="Submit" /> </form> </body> </html> <? { } ?>

Version	System time (s)	User time (s)	Memory (MiB)
5.4.17	0.027	0.048	12.40
5.4.16	0.015	0.045	12.40
5.4.15	0.015	0.045	12.39
5.4.14	0.017	0.043	12.08
5.4.13	0.014	0.045	12.07
5.4.12	0.021	0.052	12.03
5.4.11	0.015	0.043	12.03
5.4.10	0.023	0.067	12.03
5.4.9	0.014	0.046	12.02
5.4.8	0.014	0.044	12.03
5.4.7	0.016	0.042	12.02
5.4.6	0.015	0.044	12.02
5.4.5	0.017	0.056	12.02
5.4.4	0.019	0.039	12.01
5.4.3	0.012	0.047	12.00
5.4.2	0.017	0.040	12.00
5.4.1	0.016	0.056	12.00
5.4.0	0.017	0.043	11.49
5.3.27	0.019	0.042	12.73
5.3.26	0.018	0.045	12.72
5.3.25	0.015	0.061	12.72
5.3.24	0.015	0.049	12.72
5.3.23	0.014	0.048	12.71
5.3.22	0.016	0.044	12.68
5.3.21	0.019	0.043	12.68
5.3.20	0.015	0.045	12.68
5.3.19	0.019	0.042	12.68
5.3.18	0.024	0.067	12.67
5.3.17	0.018	0.043	12.67
5.3.16	0.018	0.058	12.67
5.3.15	0.014	0.047	12.67
5.3.14	0.020	0.041	12.67
5.3.13	0.015	0.050	12.66
5.3.12	0.018	0.045	12.66
5.3.11	0.017	0.044	12.66
5.3.10	0.020	0.041	12.14
5.3.9	0.014	0.047	12.13
5.3.8	0.015	0.046	12.11
5.3.7	0.014	0.046	12.11
5.3.6	0.014	0.047	12.10
5.3.5	0.022	0.067	12.04
5.3.4	0.019	0.057	12.04
5.3.3	0.015	0.042	12.01
5.3.2	0.017	0.042	11.79
5.3.1	0.019	0.038	11.76
5.3.0	0.016	0.041	11.73