[mr.]

please, what is my mistake here?

 

<?php 

// This function will run within each post array including multi-dimensional arrays
function ExtendedAddslash(&$sql){
    foreach($sql as $sql){
        // check if $var is an array. If yes, it will start another ExtendedAddslash() function to loop to each key inside.
        is_array($sql) ? ExtendedAddslash($sql) : $sql=addslashes($sql);
    }
}

// Initialize ExtendedAddslash() function for every $_POST variable
ExtendedAddslash($_POST);
if ($_POST["submit"]==true)
echo'you submitted this form';
else{
    echo'You are yet to complete your form';
}

$fname=$_POST["fname"];
$sname=$_POST["sname"];
$lname=$_POST["lname"];
$dept=$_POST["dept"];
$school=$_POST["school"];
$faculty=$_POST["faculty"];
$level=$_POST["level"];
$email=$_POST["email"];
$course=$_POST["course"];
$psw=$_POST["psw"];

$servername = "localhost:3306";
$username = "admin";
$password = "Ilove081.";
$dbname = "school";

// Create connection
$conn =mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

else {
    echo'<hr/>';
}

// Attempt insert query execution
$sql = "INSERT INTO register (id,firstname,surname, lastname,department,school,faculty,level, email,course,password,reg_time) VALUES ('',$fname,$sname, $lname,$dept,$school,$faculty,$level, $email,$course,$password,CURRENT_TIME_STAMP)";
if(mysqli_query($conn, $sql)){
    echo "Records inserted successfully.";
} else{
    echo "ERROR: Couldn't upload your data. Please, kindly try again. this is the error message<br/> $sql. " . mysqli_error($conn);
}
 
// Close connection
mysqli_close($conn);
?>

<div>
    <p align="center">
        <h2>Below are the information you submitted;</h2><br/>
         <ol>
        <li><em>Firstname:</em> <?php echo $fname?></li>
        <li><em>Email:</em> <?php echo $email?></li>
        <li><em>School:</em> <?php echo  $school?></li>
        <li><em>Course:</em> <?php echo $course?></li>
    </ol>
    </p>
    
</div>

 

kindly correct me