I have created a PHP file to store in my database but it displays nothing upon submit

Question

it displays a blank page

Answer 1

that was what was displayed

Answer 2

and the data is not stored in the database

Answer 3

What is the script in your file?

Answer 4

<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'e_cramer');

$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
?>
<?php

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

$firstname=$_POST['firstname'];
$surname=$_POST['surname'];
$username=$_POST['username'];
$pwd=$_POST['pwd'];
$cnf=$_POST['cnf'];
$gender=$_POST['gender'];
$dob=$_POST['dob'];
$country=$_POST['country'];
$email=$_POST['email'];
$tel=$_POST['tel'];
$address=$_POST['address'];
$bloodgroup=$_POST['bloodgroup'];
$sicklecell=$_POST['sicklecell'];
$history=$_POST['history'];

$firstname= mysqli_real_escape_string($db, $firstname);
$surname= mysqli_real_escape_string($db, $surname);
$username= mysqli_real_escape_string($db, $username);
$pwd= mysqli_real_escape_string($db, $pwd);
$pwd = md5($pwd);
$cnf= mysqli_real_escape_string($db, $cnf);
$gender= mysqli_real_escape_string($db, $gender);
$dob= mysqli_real_escape_string($db, $dob);
$country= mysqli_real_escape_string($db, $country);
$email= mysqli_real_escape_string($db, $email);
$tel= mysqli_real_escape_string($db, $tel);
$address= mysqli_real_escape_string($db, $address);
$bloodgroup= mysqli_real_escape_string($db, $bloodgroup);
$sicklecell= mysqli_real_escape_string($db, $sicklecell);
$history= mysqli_real_escape_string($db, $history);

Answer 5

//authenticate username, password & email
$sql = "SELECT username FROM registration WHERE username='$username'";
$result = mysqli_query($db,$sql);
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);

if(mysqli_num_rows($result) == 1){
echo "Sorry...This username already exist..";
}
else{

}

$sql = "SELECT pwd FROM registration WHERE pwd='$pwd'";
$result = mysqli_query($db,$sql);
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);

if(mysqli_num_rows($result) == 1){
echo "Sorry...password already exist..";
}
else{

}

$sql = "SELECT email FROM registration WHERE email='$email'";
$result = mysqli_query($db,$sql);
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);

if(mysqli_num_rows($result) == 1){
echo "Sorry...This email already exist..";
}
else{

}

$query = mysqli_query($db, "INSERT INTO 'registration'(firstname,surname,username,pwd,cnf,gender,dob,country,email,tel,address,bloodgroup,sicklecell,history)
VALUES('$firstname','$surname','$username','$pwd','$cnf','$gender','$dob','$country','$email','$tel','$address','$bloodgroup','$sicklecell','$history')");

if($query){
echo "Thank You! you are now registered.";
}

}
?>

Answer 6

$db->prepare("INSERT INTO users ("firstname", "username"... ) VALUES($firstname, $username... ) )->execute

Answer 7

you mean I should delete
$query = mysqli_query ($db,

Answer 8

and replace it with
$db->prepare (

Answer 9

Maybe but went I posted the message, your second message wasn't appear

Answer 10

so what's wrong with my codes now?

Answer 11

Try with prepare and execute by replacing "$
query = mysqli_query"

Answer 12

it didn't work

Answer 13

error appeared

Answer 14

Maybe because you write ->execute instead of ->execute()

Answer 15

on which line

Answer 16

there is no ->execute in my codes

Answer 17

$req = $db->prepare("INSERT INTO users SET username = ?, country = ?, gender= ?,... ");
$req->execute([$username,$country,$gender]);
Instead of:
$query = mysqli_query...

Answer 18

Ok let me try

Answer 19

Warning: mysqli_stmt::execute() expects exactly 0 parameters, 1 given in C:\xampp\htdocs\assar\database.php on line 81
Thank You! you are now registered.