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
