Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PHP PDO connection failure
- <?php
- include("class.php");
- $dbhost = "localhost";
- $dbname = "db";
- $dbuser = "user";
- $dbpass = "pass";
- $conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
- $username = $_POST['username'];
- $password = $_POST['password'];
- $email = strtolower($_POST['email']);
- $firstName = ucwords(strtolower($_POST['firstName']));
- $lastName = ucwords(strtolower($_POST['lastName']));
- $date = date("Y-m-d");
- $hash = Secure::Encrypt($username, $password);
- $sql = "INSERT INTO users (username,password,email,firstName,lastName,createDate) VALUES (:username,:password,:email,:firstName,:lastName,:date)";
- $q = $conn->prepare($sql);
- $q->execute(array(
- ':username'=>$username,
- ':password'=>$hash,
- ':email'=>$email,
- ':firstName'=>$firstName,
- ':lastName'=>$lastName,
- ':date'=>$date));
- ?>
Add Comment
Please, Sign In to add comment