How to remove fatal error "cannot be null"?

Asked Jan 23 '17 at 13:40

Active Jan 23 '17 at 13:40

Viewed 29 times

Im trying to convert a multidimensional array into a single table in a database but receive the following error "Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'Column 'Day' cannot be null' in C:\xampp\htdocs\Timetable\projects\TimetableAlgorithmn.php:27" I tried defining the variables manually but it still came up with the same error so I believe the foreach loop is fine.

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$link = mysqli_connect("localhost", "root", "","test");
$stmt =mysqli_prepare($link,"INSERT INTO timetable VALUES (?, ?, ?);");
foreach ($timetable as $day => $subTimetable) {
foreach ($subTimetable as $hour => $subject) {
    mysqli_stmt_bind_param($stmt,'iis', $Day, $hour, $subject);
    mysqli_stmt_execute($stmt);
}

asked Jan 23 '17 at 13:40

Adam Anderson

2

`$day !== $Day` – jeroen Jan 23 '17 at 13:41
Looks like you didn't follow the suggestion provided before and didn't set error reporting to E_ALL – Your Common Sense Jan 23 '17 at 13:43
@jeroent ty that fixed one of the problems I had – Adam Anderson Jan 23 '17 at 13:47
@YourCommonSense Sorry I didnt see that part but have now amended the code to show all errors. – Adam Anderson Jan 23 '17 at 13:48
ik This question is already closed but just wanted to know i fixed the issue just needed to change "iis" to "isi" to match my database – Adam Anderson Jan 23 '17 at 14:16

How to remove fatal error "cannot be null"?

0 Answers0