I'm working on a school project and when I'm trying to make a website with registration function it shows this error after I submit the form:
Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in /storage/ssd5/928/6222928/public_html/04_Registration.php:34 Stack trace: #0 {main} thrown in /storage/ssd5/928/6222928/public_html/04_Registration.php on line 34
<!DOCTYPE HTML>
<html>
<head>
<title>Register Form</title>
</head>
<body>
<form action="04_Registration.php" method="POST">
<table>
<tr>
<td>Name :</td>
<td><input type="text" name="username" required></td>
</tr>
<tr>
<td>Password :</td>
<td><input type="password" name="password" required></td>
</tr>
<tr>
<td>TP Number :</td>
<td><input type="text" name="tpnumber"></td>
</tr>
<tr>
<td>Gender :</td>
<td>
<input type="radio" name="gender" value="m" required> Male
<input type="radio" name="gender" value="f" required> Female
</td>
</tr>
<tr>
<td>Group :</td>
<td>
<input type="radio" name="group" value="a" required> A
<input type="radio" name="group" value="b" required> B
</td>
</tr>
<tr>
<td>Email :</td>
<td><input type="email" name="email" required placeholder="TP011111@mail.apu.edu.my"></td>
</tr>
<tr>
<td>Phone no :</td>
<td>
<select name="phoneCode" required>
<option selected hidden value="">Select code</option>
<option value="011">011</option>
<option value="012">012</option>
<option value="016">016</option>
<option value="017">017</option>
<option value="018">018</option>
<option value="019">019</option>
</select>
<input type="phone" name="phone" required placeholder="017460****">
</td>
</tr>
<tr>
<td><input type="submit" value="Submit"></td>
</tr>
</table>
</form>
</body>
</html> <?php
$username = $_POST['username'];
$password = $_POST['password'];
$tpnumber = $_POST['tpnumber'];
$gender = $_POST['gender'];
$group = $_POST['group'];
$email = $_POST['email'];
$phoneCode = $_POST['phoneCode'];
$phone = $_POST['phone'];
if (!empty($username) || !empty($password) || !empty($tpnumber) || !empty($gender) || !empty($group) || !empty($email) ||
!empty($phoneCode) || !empty($phone)) {
$host = "localhost";
$dbUsername = "id6222928_apuassignment2018";
$dbPassword = "joeshern123";
$dbName = "id6222928_registered";
//create connection
$conn = new mysqli($host, $dbUsername, $dbPassword, $dbName);
if (mysqli_connect_error()) {
die('Connect Error('. mysqli_connect_errno().')'. mysqli_connect_error());
} else {
$SELECT = "SELECT email From users Where email = ? Limit 1";
$INSERT = "INSERT Into users (username, password, tpnumber, gender, group, email, phoneCode, phone) values(?, ?, ?, ?, ?, ?, ?, ?)";
//Prepare statement
$stmt = $conn->prepare($SELECT);
$stmt->bind_param("s", $email);
$stmt->execute();
$stmt->bind_result($email);
$stmt->store_result();
$rnum = $stmt->num_rows;
if ($rnum==0) {
$stmt->close();
$stmt = $conn->prepare($INSERT);
$stmt->bind_param("ssssssii", $username, $password, $tpnumber, $gender, $group, $email, $phoneCode, $phone);
$stmt->execute();
echo "Registration success!!";
} else {
echo "Someone already register using this email";
}
$stmt->close();
$conn->close();
}
} else {
echo "All field are required";
die();
}
?>
