connect_error){ die("DB Error"); } /* ========= REGISTER ========= */ $msg = ""; if(isset($_POST['register'])){ $first_name = $_POST['first_name']; $last_name = $_POST['last_name']; $gender = $_POST['gender']; $job_title = $_POST['job_title']; $email = $_POST['email']; $country = $_POST['country']; $city = $_POST['state']; $phone = $_POST['phone']; $password = password_hash($_POST['password'], PASSWORD_DEFAULT); $check = $conn->prepare("SELECT id FROM users WHERE email=?"); $check->bind_param("s",$email); $check->execute(); $check->store_result(); if($check->num_rows > 0){ $msg = "Email already registered"; }else{ $stmt = $conn->prepare(" INSERT INTO users (first_name,last_name,gender,job_title,email,country,city,phone,password,role) VALUES (?,?,?,?,?,?,?,?,?,'user') "); $stmt->bind_param( "sssssssss", $first_name,$last_name,$gender,$job_title, $email,$country,$city,$phone,$password ); $stmt->execute(); $_SESSION['user_id'] = $stmt->insert_id; echo ""; exit; } } ?>
Access services after registration