Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include 'connect.php';
- $userName = $_POST['name'];
- $firstname = $_POST['FirstName'];
- $Surname = $_Post['Surname'];
- $email = $_POST['EmailAddress'];
- $password = $_POST['Password'];
- $gender = $_POST['Gender'];
- $dob = $_POST['DOB'];
- $query = 'INSERT INTO `User` (`username`,`Password`,`First Name`,`Surname`, `Gender`, `DOB`, `Email Address`)
- VALUES ('.$userName.','.$password.','.$firstname.','.$Surname.', '.$gender.', '.$dob.', '.$email.')';
- $stmt = $conn->prepare($query);
- try {
- $myarray = array(
- ":userName" => $userName,
- ":password" => $password,
- ":firstname" =>$firstname,
- ":Surname" => $Surname,
- ":gender" => $gender,
- ":dob" => $dob,
- ":email" => $email);
- print_r($myarray);
- $stmt->execute($myarray);
- } catch(PDOException $err) {
- echo "Houston we have a problem: $err";
- }
- ?>
- $query = 'INSERT INTO `User` (`username`,`Password`,`First Name`,`Surname`, `Gender`, `DOB`, `Email Address`)
- VALUES (:userName, :password, :firstname, :Surname, :gender, :dob, :email)';
- $table='User';
- $sql="INSERT INTO
- $table(username,Password,First Name,Surname,Gender,DOB,Email Address) VALUES ('$userName','$password','$firstname','$Surname', '$gender', '$dob', '$email')";
- $result=$conn->query($sql) ;
- $db = "mysql:host=yourhost;dbname=yourdbname";
- $username = " ";
- $password = " ";
- $conn = new PDO( $db, $username, $password ) or die("Error Connection !! ");
- array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8");
- <?php
- include 'connect.php';
- $userName = $_POST['name'];
- $firstname = $_POST['FirstName'];
- $Surname = $_Post['Surname'];
- $email = $_POST['EmailAddress'];
- $password = $_POST['Password'];
- $gender = $_POST['Gender'];
- $dob = $_POST['DOB'];
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $query = 'INSERT INTO `User` (`username`,`Password`,`First Name`,`Surname`, `Gender`, `DOB`, `Email Address`)
- VALUES (:userName, :password, :firstname, :Surname, :gender, :dob, :email)'
- try {
- $stmt = $conn->prepare($query);
- $result = $stmt->execute(array(
- ":userName" => $userName,
- ":password" => $password,
- ":firstname" =>$firstname,
- ":Surname" => $Surname,
- ":gender" => $gender,
- ":dob" => $dob,
- ":email" => $email));
- if ($result) {
- // success!
- echo 'lastInsertId = '.$conn->lastInsertId();
- } else {
- // Query failed.
- echo 'errorcode = '.$stmt ->errorCode();
- }
- } catch(PDOException $err) {
- echo "Houston we have a problem: $err <br />";
- echo 'errorcode = '.$stmt ->errorCode();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement