<html><head> <title>Adding a New User</title> </head><body><?php $firstname = $_POST ['firstname']; $lastname = $_POST ['lastname']; $username = $_POST ['username']; $password = $_POST ['password']; if( ( !$firstname ) or ( !$lastname ) or ( !$username ) or ( !$password ) ){ $form = "<h2>Please enter all new user infromation</h2>"; $form.= "<form action=\"$self\" method=\"post\">"; $form.= "<input name=\"firstname\" type=\"text\" value=\"$firstname\">"; $form.= "<input name=\"lastname\" type=\"text\" value=\"$lasttname\">"; $form.= "<input name=\"username\" type=\"text\" value=\"$username\">"; $form.= "<input name=\"password\" type=\"text\" value=\"$password\">"; $form = "</form>"; echo( $form );}else{ $conn = @mysql_connect ( "localhost", "jonathanadams", "bu88les", "cms" ) or die ("<h2>Could not connect to MySQL</h2>"); $db = @mysql_select_db ( "users", $conn ) or die ("<h2>Could not select the database</h2>"); $sql = "insert into users (firstname,lastname,username,password) values (\"$firstname\",\"$lastname\",\"$username\",\"$password\") )"; $result = @mysql_query( $sql, $conn ) or die ("<h2>Could not exicute query</h2>"); if( $result ) {echo( "<h2>New user $username added</h2>" ); }}?></body></html>
