Make a value into NULL instead of empty in php

Question

I can't make the empty value to be checked as NULL in database instead of leaving an empty space when I am inserting a value.

I don't want to leave an empty/blank space for an entry when it has no value. So if there is no file selected, make that entry into NULL

Is it unnecessary to be in NULL?

if (empty($_FILES['logo']['name'])) {
  $code = NULL;
  } else {
}

How do you update/insert this value, and is the column nullable? — Qirel, Feb 25 '19 at 12:06
Why not change the if statement to `if (!empty($_FILES['logo']['name']))` and then run the inserts within that code block? — JustCarty, Feb 25 '19 at 12:10
You must set the NULL value explicit in mysql. INSERT INTO () VALUES (NULL) — prometheus, Feb 25 '19 at 12:12
Add the code. Sounds like you are using `$code` in the insert.. — user3783243, Feb 25 '19 at 12:15
Please update your question, the problem is not your if/else, it is in the sql syntax. — Daniel, Feb 25 '19 at 12:32

score 0 · Accepted Answer · answered Feb 25 '19 at 12:14

It's a normal problem with null-able strings. For a quick solution, you can change your code to:

$code = NULL;
if( !empty($_FILES['logo']['name']) ){
 ...
}

score 0 · Answer 2 · answered Feb 25 '19 at 12:18

0

$logo = (!empty($_FILES['logo']['name']) ? "logo" : "NULL");
try this

answered Feb 25 '19 at 12:18

Kabir Safi

2 Answers2