Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $fname = $_POST['fname'];
- $lname = $_POST['lname'];
- $gender = $_POST['gender'];
- $age = $_POST['age'];
- $address = $_POST['address'];
- $email =$_POST['email'];
- if (!empty($fname) || !empty($lname) || !empty($gender) || !empty($age) ||!empty($address) || !empty($email)) {
- $host = "localhost";
- $dbUsername = "root";
- $dbPassword = "";
- $dbname = "register";
- //create connection
- $conn = new mysqli($host, $dbUsername, $dbPassword, $dbname);
- if (mysqli_connect_error()) {
- die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
- } else {
- $SELECT = "SELECT email From register Where email = ? Limit 1";
- $INSERT = "INSERT Into register (fname, lname, gender, age, address, email) values(?, ?, ?, ?, ?, ?)";
- //Prepare statement
- $stmt = $conn->prepare($SELECT);
- $stmt->bind_param("s", $email);
- $stmt->execute();
- $stmt->bind_result($email);
- $stmt->store_result();
- $rnum = $stmt->num_rows;
- if ($rnum==0) {
- $stmt->close();
- $stmt = $conn->prepare($INSERT);
- $stmt->bind_param("ssssss", $fname, $lname, $gender, $age, $address, $email);
- $stmt->execute();
- echo "New record inserted sucessfully";
- } else {
- echo "Someone already register using this email";
- }
- $stmt->close();
- $conn->close();
- }
- } else {
- echo "All field are required";
- die();
- }
- ?>
Add Comment
Please, Sign In to add comment