How to fix Trying to access array offset on value of type null error

by

When you receive this error after fetching data from the database then it means that the database didn’t found any matching rows. Most database fetching functions return either null or an empty array when there are no matching records or when the result set has been exhausted.

To solve the problem you need to check for the truthiness of the value or for the existence of the key that you want to access.

$monday_lectures = "SELECT * from lectures where lecture_time="11am to 1pm" and lecture_day = 'firday'";
$result_11to1 = mysqli_query($con, $monday_lectures);
$m11to1 = mysqli_fetch_array($result_11to1);
if ($m11to1 && $m11to1["lecture_day"] == !'') {
    echo "<td>".$m11to1["lecture_name"]."</td>";
} else {
    echo "<td> no class</td>";
}

If what you are after is a single value from the result array then you can specify a default in case the result is not present.

$monday_lectures = "SELECT * from lectures where lecture_time="11am to 1pm" and lecture_day = 'firday'";
$result_11to1 = mysqli_query($con, $monday_lectures);
$m11to1 = mysqli_fetch_array($result_11to1);
$lecture = $m11to1["lecture_day"] ?? null;

The same applies to PDO.

$monday_lectures = $pdo->prepare("SELECT * from lectures where lecture_time="11am to 1pm" and lecture_day = 'firday'");
$monday_lectures->execute();
$m11to1 = $monday_lectures->fetch();
$lecture = $m11to1["lecture_day"] ?? null;

More Related Contents:

  1. PHP create new array by value
  2. How to bind mysqli bind_param arguments dynamically in PHP?
  3. mysqli bind_param() expected to be a reference, value given
  4. Fatal error: Cannot use object of type mysqli_result [closed]
  5. MySQLi Bind Param with an array for IN [duplicate]
  6. Returning Multiple Rows with MySqli and Arrays
  7. Can I bind an array to an IN() condition in a PDO query?
  8. Best way to INSERT many values in mysqli?
  9. PHP Constants Containing Arrays?
  10. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  11. mysqli_query() expects parameter 1 to be mysqli, object given
  12. Group array by subarray values
  13. Remove all elements from array that do not start with a certain string
  14. php – How do I fix this illegal offset type error
  15. Posting multidimensional array with PHP and CURL
  16. Recursively remove empty elements and subarrays from a multi-dimensional array
  17. How to echo a MySQLi prepared statement?
  18. PHP array_filter with arguments
  19. Unexpected bracket ‘[‘ – PHP [duplicate]
  20. scandir() to sort by date modified
  21. Print the keys of an array
  22. MySQLi prepared statements with IN operator [duplicate]
  23. Sort Object in PHP
  24. Best method for sum two arrays [closed]
  25. Notice: Undefined index when trying to increment an associative array in PHP
  26. PHP – Get key name of array value
  27. Sort array by value alphabetically php
  28. CMS Routing in MVC
  29. Recursive array_search
  30. How to get a list of databases?

Leave a Comment