i have this two function for create user.first function for insert/create user and other function for check if user was/exist in MySql
database. but when i send data i see blank page for die(); (if user exsit or user not exist) how to fix this error? and how to print error list in red box i.e:
- this user not activate
- email is empty
- ....
my class:
public function createUser($email, $password, $salt, $verification) {
if($this->checkUserFound($email) != true ){die();}
$query = "INSERT INTO tbUsers (email, password, user_salt, is_verified, is_active, is_admin, verification_code) "
. "VALUES (?, ?, ?, ?, ?, ?, ?)";
$stmt = $this->_db->prepare($query);
$ver = 0;
$act = 1;
$adm = 0;
$stmt->bind_param("sssiiis", $email, $password, $salt, $ver, $act, $adm, $verification);
if ($stmt->execute()) {
return true;
}
return false;
}
public function checkUserFound($email) {
$query = "SELECT email FROM tbUsers where email = ?";
$stmt = $this->_db->prepare($query);
$stmt->bind_param("s", $email);
if ($stmt->execute()) {
$stmt->bind_result($email);
//fetch first row of results
$stmt->fetch();
return false;
}
return true;
}