session_start
`<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<?php
if(isset($_POST["Email"]) && isset($_POST["Password"])){
$name=$_POST['First_name'];
try {$pdo_options[PDO::ATTR_ERRMODE]=PDO::ERRMODE_EXCEPTION ;
$Dbc= new PDO('mysql:host=localhost;dbname=abakwa','admin','anthony',$pdo_options);
//$register=$Dbc-> exec("INSERT INTO user(first_name,last_name,email,Date_of_birth ,password)VALUES(" .$_POST['First_name'],$_POS
//T['Last_name'],$_POST['Email'],$_POST['Date_of_birth'],$_POST['Password']);
$Register_user=$Dbc->prepare("INSERT INTO user(First_name,last_name,Email,Date_of_birth ,password)VALUES(:First_name,:last_name,:Email,
ate_of_birh,
assword)");
$Register_user->execute(array(
'First_name' => $name,
'Last_name'=>$_POST['Last_name'],
'Email'=> $_POST['Email'],
'Date_of_birth'=>$_POST['Date_of_birth'],
'password' => $_POST['Date_of_birth']) );
// echo "Your Detials have been added to the data base";
//get user_name which has that acc
}
catch(Exception $e)
{die ('ERROR: '.$e->getMessage());
}
}
?>
<form method="post" action="register.php ">
First Name:
<input type="text" name="First_name" /><br />
Last Name:
<input type="text" name="Last_name" />
<br />
Email:
<input type="text" name="Email" />
<br />
<input type="text" name="Date_of_birth" />
Password:
<input type="Password " name="Password" /><br />
<br />
<input type="submit" value="login" />
</form>
</body>
</html>
ERROR: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
