php - Data are not saved into database eventhough the code works correctly -
im trying register user database.the code works correctly data arent saved database in end.the final output "you registered successfully!wit admin confirmation" should be.this registration form:
<html > <head> <title></title> </head> <body> <?php print ("<form action='register.php' method='post'> <p>name <input type='text' name='firstname' /> </p> <p>surname <input type='text' name='lastname' /> </p> <p>username <input type='text' name='username' /> </p> <p>password <input type='password' name='password' /> </p> <p>email <input type='text' name='email'/> </p> enter cv: <p> <textarea name='cv' cols='60' rows='50'></textarea> </p> <input type='submit' value='register'/> </form> "); if( !($database=mysql_connect("localhost","root",""))||!(mysql_select_db("st_login",$database)) ) print("could not connect"); if(isset($_post['firstname'] )&&isset($_post['lastname'])&&isset($_post['username'])&&isset($_post['password']) &&isset($_post['cv'])/*&&isset($_post['notat'])&&isset($_post['lendet'])*/&&isset($_post['email'])){ $firstname=$_post['firstname']; $lastname=$_post['lastname']; $username=$_post['username']; $password=md5($_post['password']); $email=$_post['email']; $cv=$_post['cv']; /* $notat=$_post['notat']; $lendet=$_post['lendet']; */ $query = "insert login (firstname, lastname, username,password,cv,email,admin,approval) values ('$firstname', '$lastname', '$username','$password','$cv','$email',0,0)"; } if ( !empty($firstname)&&!empty($lastname)&&!empty($username) &&!empty($password)&&!empty($cv)&&!empty($email)) { if(!($result=mysql_query($query,$database))) { print("could not execute query"); die (mysql_error());//ose error } echo "you have been registered successfully!please wait admin approval!"; } else echo "fill in blank fields"; mysql_close($database); ?> </body> </html>this database:
phpmyadmin needs refreshed see updated data. hit reload or click elsewhere , display new data.
Comments
Post a Comment