JSFiddle - React, Tailwind, and code Playground

by chayacooper

HTML

$gender = $_POST['gender'];  
if ($gender==="female" ) {
try {      
   $stmt = $conn->prepare('INSERT INTO customer_info (fname...) VALUES(:fname...)');
   $stmt->bindParam(':fname', $_POST['fname'], PDO::PARAM_STR);   

// The new code starts here

$result = $stmt->execute();
if ($result) {

      $qry="SELECT * FROM customer_info WHERE user_name='$_POST['user_name']' AND password='$_POST['password']'";
      $result = $stmt->execute();       
              
if($result) {
   $affected_rows = $stmt->rowCount();
if ($affected_rows == 1)  {

        //user_name Successful
        
            session_regenerate_id();
            $member = mysql_fetch_assoc($result);
            $_SESSION['SESS_USER_ID'] = $member['user_id'];
          $_SESSION['SESS_USER_NAME'] = $member['user_name'];
            $_SESSION['SESS_FIRST_NAME'] = $member['fname'];
            $_SESSION['SESS_LAST_NAME'] = $member['lname'];            
        }else {
            //user_name failed
            header("location: login_failed.html");
            exit();
        }

// New code ends here
    } catch(PDOException $e) {
  echo $e->getMessage();
}