Trying to access array offset on value of type bool

by

You are getting this error probably because there were no records found in the database matching your criteria.

The easiest way to solve this error is to check if the database returned anything first.

$emailRes = $query->fetch(PDO::FETCH_ASSOC);
// VVV - Here I am checking if there was anything returned and then I check the condition
if($emailRes && $emailRes['Email']==$_POST['email']) {
    // ...
}

If you don’t care whether the database returned anything, then you can simply provide a default value. For example:

$emailRes = $query->fetch(PDO::FETCH_ASSOC);
$email = $emailRes['Email'] ?? ''; // default: empty string

The correct way to check for existance in DB using PDO is:

$query = $pdo->prepare("SELECT COUNT(*) FROM Users WHERE Username =:Username");
$query->execute([':Username' => $name]);
if ($query->fetchColumn()) {
    throw new \Exception("Username is already in use!");
}

$query = $pdo->prepare("SELECT COUNT(*) FROM Users WHERE Email =:Email");
$query->execute([':Email' => $email]);
if ($query->fetchColumn()) {
    throw new \Exception("Email is already in use!");
}

Instead of fetching the row and doing the comparison again in PHP I am fetching a count of matching rows from the database and I use that count as a boolean in the if statement. fetchColumn() will fetch a single column from the first row and if I use COUNT(*) I know there will always be one row.

You can also do it in one query:

$query = $pdo->prepare("SELECT COUNT(*) FROM Users WHERE Username =:Username OR  Email =:Email");
$query->execute([':Username' => $name, ':Email' => $email]);
if ($query->fetchColumn()) {
    throw new \Exception("Username or email is already in use!");
}

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. Getting raw SQL query string from PDO prepared statements
  5. How do I set ORDER BY params using prepared PDO statement?
  6. “Invalid parameter number: parameter was not defined” Inserting data
  7. Having issue with matching rows in the database using PDO
  8. How can I properly use a PDO object for a parameterized SELECT query
  9. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  10. PDO with INSERT INTO through prepared statements [closed]
  11. PDO::fetchAll vs. PDO::fetch in a loop
  12. Real escape string and PDO [duplicate]
  13. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  14. PDO Connection Test
  15. PHP PDO vs normal mysql_connect
  16. Can I create a database using PDO in PHP?
  17. PHP PDO and MySQLi [duplicate]
  18. PDO fetch one column from table into 1-dimensional array
  19. Getting a PHP PDO connection from a mysql_connect()?
  20. PDO error: SQLSTATE[HY000]: General error: 2031
  21. Having issue with matching rows in the database
  22. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  23. PHP/SQL Insert Error when using Named Placeholders
  24. How to escape single-quote (apostrophe) in string using php
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. php, mysql – Too many connections to database error
  27. PDO bindParam into one statement?
  28. Insert value list does not match column list: 1136 Column count doesn’t match value count
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment