Advertisement
Guest User

Untitled

a guest
Sep 17th, 2014
251
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.95 KB | None | 0 0
  1. <?php
  2.  
  3. //require_once 'dbconfig.php';
  4. require_once 'functions.php';
  5. //$dbconnect= mysqlConn('localhost','project1','christech','chris');
  6. $error="";
  7.     if (isset($_POST['btnRegister'])){
  8.        
  9.          //pass values to variable from user's input'  
  10.             $Fname= check_input($_POST['Fname']);
  11.             $Lname= check_input($_POST['Lname']);
  12.             $email= check_input($_POST['email']);
  13.             $user= check_input($_POST['username']);
  14.             $pass= $_POST['password'];
  15.             $repass= $_POST['repass'];
  16.          //validate user's input
  17.          
  18.         if ($Fname==''){
  19.             $error= "Please enter your first name";
  20.         }elseif ($Lname==''){
  21.             $error= "Please enter your last name";
  22.         }elseif($email==''){
  23.             $error= "Please enter your email";
  24.         }elseif($user==''){
  25.             $error= "Please choose a username";
  26.         }elseif ($pass==''){
  27.             $error= "Please enter a password";
  28.         }else{
  29.             $valid="";
  30.         }
  31.         if ($repass!== $pass){
  32.             $error= "Unidentical Password, Please, Enter same password";
  33.         }
  34.     try{
  35.        
  36.  
  37.     $pdoconn= new PDO('mysql:host= localhost; dbname=project1;','chritech','chris');
  38.     $pdoconn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  39.     $sql= $dbconnect -> prepare("INSERT INTO registration(first_name, last_name,email, username, password ) VALUES (:Fname,:Lname,:email,:user,:pass)");
  40.     $sql->bindParam(':Fname',$Fname,PDO::PARAM_STR);
  41.     $sql->bindParam(':Lname', $Lname,PDO::PARAM_STR);
  42.     $sql->bindParam(':email',$email,PDO::PARAM_STR);
  43.     $sql->bindParam('username',$user,PDO::PARAM_STR);
  44.     $sql->bindParam(':password',$pass,PDO::PARAM_STR);
  45.    
  46.     $count= $sql->execute();
  47.     echo "<p style:color:black; > sucess </p>";
  48.     }catch(PDOException $e){
  49.       echo  $e->getMessage();
  50.       //print_r(PDO::getAvailableDrivers());
  51.        
  52.     }
  53.  
  54.  
  55.  
  56. }
  57.        
  58. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement