Viewing File: /home/quiczmwg/public_html/admin/register-process.php

<?php
include 'config.php';
//
if ($_SERVER['REQUEST_METHOD']=="POST"){
    // print_r($_POST);
$isError = false;

//VALIDATION

//validate fullname
$isError = false;
if(empty($_POST['fname'])){
    $fError = "Fullname is required!";
    $isError = true;
}
elseif (is_numeric($_POST['fname'])){
    $fError = "Fullname cannot be number!";
    $isError = true;
}
else{
    $fname = cleanInput($_POST['fname']);
}

//validate phone number
if(empty($_POST['phone'])){
    $pError = "Phone number is required!";
    $isError = true;
}
elseif (!is_numeric($_POST['phone'])){
    $pError = "Insert a valid phone number!";
    $isError = true;
}
else{
    $phone = cleanInput($_POST['phone']);
}

//validate Email address
if(empty($_POST['email'])){
    $eError = "Email is required";
    $isError = true;
}elseif(!filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)){
    $eError = "Bro, put valid email now!";
    $iError = true;
}else{
    $email = cleanInput($_POST['email']);
    //check the email if it  already exist in the database
    // $sql = $conn->query("SELECT demail FROM login WHERE demail='$email'");
    // if($sql->num_rows>0){
    //     $eError = "email address already taken";
    //     $isError = true;
    // }
}

    //validate username
    if(empty($_POST['username'])){
        $uError = "username is required";
        $isError = true;
    }
    else{
        $username = cleanInput(ucfirst(strtolower(str_replace(' ','',$_POST['username']))));
        //check username in the db
        // $sql = $conn->query("SELECT dusername FROM login WHERE dusername='$username'");
        // if($sql->num_rows>0){
        //     $uError = "username already taken";
        //     $isError = true;
        // }
    }

        //validate password
        if(empty($_POST['pass'])){
            $passError = "password is required";
        }elseif (strlen($_POST['pass']) <3){
            $passError = "Bro, your password is too short!";
        }elseif (strlen($_POST['pass']) > 10){
            $passError = "Password is too long!";
        }else{
            $pass = cleanInput($_POST['pass']);
        }
    
        //Validate confirm password
        if(empty($_POST['cpass'])){
            $cpassError = "confirm password is required!";
            $isError = true;
        }
        else{
            $cpass = cleanInput($_POST['cpass']);
            if(empty($passError) && ($pass != $cpass)){
                $cpassError = "Password doesn't match!";
                $isError = true;
            }
        }


        if($isError==false){
            //run sql
            // $pass = md5($pass);
            $userid = md5(date("Ymdhis").rand(203991, 483678));
    
            $sql = $conn->query("INSERT INTO dlogin SET userid='$userid', dfname='$fname', dphone='$phone', demail='$email', dusername='$username', dpass='$pass'");


            // if($sql){
            //     echo "<h2>Registration Successfull</h2>";
            // }else{
            //     echo "<h2>Fail</h2>";
            // }
        }

}



//
include 'config.php';
// print_r($_POST);
if($_SERVER['REQUEST_METHOD']=="POST"){
    if(isset($_POST['btnSave'])){
        $userid = md5(date("Ymdhis").rand(203991, 483678));
        $gamecategory = cleanInput($_POST['gamecategory']);

    $sql = $conn->query("SELECT dgamecategory FROM dcategory WHERE dgamecategory='$gamecategory'");
    if($sql->num_rows>0){
        
        $sql = $conn->query("INSERT INTO dcategory SET userid='$userid', dgamecategory='$gamecategory'");

    }}
    else{
        $id = $_POST['id'];
        $sql = $conn->query("UPDATE dcategory SET dgamecategory='$gamecategory' WHERE id='$id' ");
    }  

    // $sql = $conn->query("SELECT dusername FROM login WHERE dusername='$username'");
    // if($sql->num_rows>0){
    //     $uError = "username already taken";
    //     $isError = true;
    // }
  


  header("Location:Manage-category.php");
}