SignUp_auth.php

<?php 
    include("connect.php");

    $uname = $_POST['uname'];
    $inst = $_POST['inst'];
    $dept = $_POST['dept'];
    $email = $_POST['email'];
    $mobno = $_POST['mobno'];
    $state = $_POST['state'];
    $city = $_POST['city'];
    $pass = $_POST['pass'];
    $utype = $_POST['utype'];
    if($utype == 'student') {
        $uinfo = $_POST['sem'];
        $udata = 'sem';
        $table = 'students';
    }
    else {
        $uinfo = $_POST['post'];
        $udata = 'post';
        $table = 'faculties';
    }

    $query = "select id from $table order by id";
    $cmd = mysqli_query($con,$query);

    while($row = mysqli_fetch_array($cmd)) {
        $uid = $row['id'];
    }
    $uid++;
    
    $image = $_FILES["uimg"];

    // Check if file is uploaded successfully
    
        // Read file contents
        if ($image["error"] === UPLOAD_ERR_OK) {
            $imageData = file_get_contents($_FILES["uimg"]["tmp_name"]);
            $fileType = $_FILES["uimg"]["type"];
        }
        else {
            $imageData = NULL;
            $fileType = NULL;
        }
        
// Password to be encrypted
$password = $_POST['pass'];

// Encrypt the password using password_hash() function
$hashed = password_hash($password, PASSWORD_DEFAULT);

// Store $hashedPassword in your database
echo "Encrypted Password: " . $hashedPassword;


        // Prepare and bind the INSERT statement
        $stmt = $con->prepare("INSERT INTO $table (pic,imgType,id,name,inst,dep,email,mob,state,city,pass,$udata) 
        VALUES (?,?,$uid,'$uname','$inst','$dept','$email',$mobno,'$state','$city','$hashed','$uinfo')");
        $stmt->bind_param("ss", $imageData, $fileType);

        // Execute the statement
        if ($stmt->execute()) {
            setcookie("userid",$uid,time() + (10 * 365 * 24 * 60 * 60));
            setcookie("username",$uname,time() + (10 * 365 * 24 * 60 * 60));
            setcookie("usertype",$utype,time() + (10 * 365 * 24 * 60 * 60));
            header('location:index2.php');
        } else {
            $stmt->close();
            $con->close();
            header('location:SignUp.html');
        }
        // Close statement and database connection
        $stmt->close();
        $con->close();
    
?>