<?php if ($_SERVER["REQUEST_METHOD"] == "POST") { if (!empty($_POST['full_name']) && !empty($_POST['username']) && !empty($_POST['user_email']) && !empty($_POST['user_password']) && !empty($_POST['confirm_password']) && !empty($_POST['user_phone'])) { include '../database/dbconnect.php'; $fullname = $_POST['full_name']; $username = $_POST['username']; $email = $_POST['user_email']; $password = $_POST['user_password']; $phone = $_POST['user_phone']; if(isset($_POST['is_driver'])) { $status = 'driver'; } else { $status = 'customer'; } $query = mysqli_query($con,"INSERT INTO user (name,email,phone,username,password,status,pict) VALUES ('$fullname', '$email', '$phone', '$username', '$password', '$status',DEFAULT)") or die(mysqli_error()); if($query) { $getUserID = mysqli_query($con,"SELECT user_id FROM user WHERE username='".$username."'") or die(mysql_error()); $row=mysqli_fetch_assoc($getUserID); $user_id=$row['user_id']; if ($status == "customer") { header("Location: ../order/order.php?id=$user_id"); } else { $query = mysqli_query($con,"INSERT INTO driver (driver_id,total_score,votes) VALUES ('$user_id',0,0)") or die(mysqli_error($con)); if ($query) { header("Location: ../profile/profile.php?id=$user_id"); } } } mysqli_close($con); } else { include("sign_up.html"); echo "<script> document.getElementById('error_signup').innerHTML = 'Please fill all the required field'; </script>"; header("Location: sign_up.html"); } } else if ($_SERVER["REQUEST_METHOD"] == "GET") { if (!empty($_GET['key'])) { $key = stristr($_GET['key'],'=',true); $value = substr(strstr($_GET['key'],'='),1); include '../database/dbconnect.php'; if ($key == "username") { $query = mysqli_query($con,"SELECT * FROM user WHERE username='".$value."'") or die(mysqli_error()); $numrows=mysqli_num_rows($query); } else if ($key == "user_email") { $query = mysqli_query($con,"SELECT * FROM user WHERE email='".$value."'") or die(mysqli_error()); $numrows=mysqli_num_rows($query); } if ($numrows != 0) { echo "☓"; } else { echo "✓"; } mysqli_close($con); } } ?>