Edit: signup.php

Editing: signup.php

Kembali

<?php

include '../components/connect.php';

session_start();

if(isset($client_email)){
   header('location:index.php');
}

// if(isset($_SESSION['user_id'])){
//    $user_id = $_SESSION['user_id'];
// }else{
//    $user_id = '';
// };

if(isset($_POST['submit'])){

$name = $_POST['name'];
   $name = filter_var($name, FILTER_SANITIZE_STRING);
   $email = $_POST['email'];
   $email = filter_var($email, FILTER_SANITIZE_STRING);
   $contact = $_POST['contact'];
   $contact = filter_var($contact, FILTER_SANITIZE_STRING);
   $pass = sha1($_POST['pass']);
   $pass = filter_var($pass, FILTER_SANITIZE_STRING);
   $cpass = sha1($_POST['cpass']);
   $cpass = filter_var($cpass, FILTER_SANITIZE_STRING);
   $category=$_POST['category'];
   $category = filter_var($category, FILTER_SANITIZE_STRING);

$select_user = mysqli_query($conn,"SELECT * FROM `client_login_buffer` WHERE client_email = '$email'");

// $row =mysqli_fetch_assoc($select_user);

if(mysqli_num_rows($select_user) > 0){
      $message[] = 'email already exists!';
   }else{
      if($pass != $cpass){
         $message[] = 'confirm password not matched!';
      }else{
         $insert_user = mysqli_query($conn,"INSERT INTO `client_login_buffer`(client_name,client_contact,client_email,client_password,category) VALUES('$name','$contact','$email','$cpass','$category')");
         // $insert_user->execute([$name, $email, $cpass]);
         if($insert_user){

$message[] = 'registered successfully, login after 24Hrs please!';
         }
         else{
            $message[] =mysqli_error($conn);
         }
      }
   }

}

// session_start();

// if(isset($_POST['submit'])){

//    $name = $_POST['name'];
//    $name = filter_var($name, FILTER_SANITIZE_STRING);
//    $pass = sha1($_POST['pass']);
//    $pass = filter_var($pass, FILTER_SANITIZE_STRING);

//    $sql = "SELECT * FROM admins WHERE name='$name';";
//    $res = mysqli_query($conn, $sql);
//    // print_r($res);
//    // echo(mysqli_error($conn) );

//             if(mysqli_num_rows($res) != 0){
//                 $row = mysqli_fetch_array($res);
//                 if($pass != $row['password']){
//                     $message[] = "Invalid password!";
//                 }
//                 else{
//                     $result = "Loggedin successfully! Redirecting...";
//                      $_SESSION['admin_id'] = $row['id'];
//                      header('location:index.php');
//                 }
//             }
//             else{
//                 $message[] = "Invalid username!";
//             }

// }

</head>
<body>

<?php
   if(isset($message)){
      foreach($message as $message){
         echo '
         <div class="message">
            <span>'.$message.'</span>
            <i class="fas fa-times" onclick="this.parentElement.remove();"></i>
         </div>
         ';
      }
   }
?>

<form action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" method="post">
      <h3>SignUp</h3>
       
           <input type="text" name="name" required placeholder="Enter your Name" maxlength="20"  class="box" oninput="this.value = this.value.replace(/\s/g, '')">
      <input type="text" name="email" required placeholder="Enter your Email" maxlength="20"  class="box" oninput="this.value = this.value.replace(/\s/g, '')">

<select name="category" placeholder="enter category" class="box">
            
            <?php
            $categories=mysqli_query($conn,"SELECT category FROM categories");
            // print_r($categories);
            // echo(mysqli_error($conn));
            if(mysqli_num_rows($categories)>0){
               while($categoryArray=mysqli_fetch_array($categories)){
                  
                  print_r($categoryArray);
                  echo('<option value="'.$categoryArray[0].'">'.$categoryArray[0].'</option>');
               }
               
            }
            
            ?>
 
      <input type="submit" value="Register Now" class="btn" name="submit">
      
      <div style="font-size: 1.5rem;margin-top: 1rem;" >
        Already Account?
        <a href="./client_login.php">Login Now</a>
      </div>
   </form>

</section>
   
</body>
</html>

<?php

// include '../components/connect.php';

// session_start();

// if(isset($_SESSION['user_id'])){
//    $user_id = $_SESSION['user_id'];
// }else{
//    $user_id = '';
// };

// if(isset($_POST['submit'])){

//    $name = $_POST['name'];
//    $name = filter_var($name, FILTER_SANITIZE_STRING);
//    $email = $_POST['email'];
//    $email = filter_var($email, FILTER_SANITIZE_STRING);
//    $pass = sha1($_POST['pass']);
//    $pass = filter_var($pass, FILTER_SANITIZE_STRING);
//    $cpass = sha1($_POST['cpass']);
//    $cpass = filter_var($cpass, FILTER_SANITIZE_STRING);

//    $select_user = mysqli_query($conn,"SELECT * FROM `users` WHERE email = $email");
//    // $select_user->execute([$email,]);

//    $row =mysqli_fetch_assoc($select_user);
//    //  $select_user->fetch(PDO::FETCH_ASSOC);

//    if(mysqli_num_rows($select_user) > 0){
//       $message[] = 'email already exists!';
//    }else{
//       if($pass != $cpass){
//          $message[] = 'confirm password not matched!';
//       }else{
//          $insert_user = mysqli_query($conn,"INSERT INTO `users`(name, email, password) VALUES('$name', '$email', '$cpass')");
//          // $insert_user->execute([$name, $email, $cpass]);
//          if($insert_user){

//             $message[] = 'registered successfully, login now please!';
//          }
//          else{
//             $message[] =mysqli_error($conn);
//          }
//       }
//    }

// }

<!DOCTYPE html>
<html lang="en">
<head>
   <meta charset="UTF-8">
   <meta http-equiv="X-UA-Compatible" content="IE=edge">
   <meta name="viewport" content="width=device-width, initial-scale=1.0">
   <title>register</title>
   
   
   <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.1.1/css/all.min.css">

<link rel="stylesheet" href="../css/admin_style.css">

</head>
<body>

<!-- <section class="form-container">

<form action="" method="post">
      <h3>register now</h3>
      <input type="text" name="name" required placeholder="enter your username" maxlength="20"  class="box">
      <input type="email" name="email" required placeholder="enter your email" maxlength="50"  class="box" oninput="this.value = this.value.replace(/\s/g, '')">
      <input type="password" name="pass" required placeholder="enter your password" maxlength="20"  class="box" oninput="this.value = this.value.replace(/\s/g, '')">
      <input type="password" name="cpass" required placeholder="confirm your password" maxlength="20"  class="box" oninput="this.value = this.value.replace(/\s/g, '')">
      <input type="submit" value="register now" class="btn" name="submit">
      <p>already have an account?</p>
      <a href="user_login.php" class="option-btn">login now</a>
   </form>

</section> -->

</body>
</html>