Is it possible to have a HTML SELECT OPTION value as NULL using PHP

Question

The following is a snippet from my HTML form which pulls the options from the table rows accordingly   What I want to do is have the first option value to be NULL so when no choice is made  NULL is entered when the form is submitted to the database        lt td gt Type lt  td gt       lt td gt   lt  td gt       lt td gt  lt select name  type id  id  type id  class  form  gt       lt option value    gt  lt  option gt           lt  php               sql   mysql query  SELECT type id  type FROM  tbl add type   or die mysql error                 while   row   mysql fetch array  sql                                         echo   lt option value    row  type id     gt      row  type       lt  option gt                                gt       lt  select gt   lt  td gt    Is this possible  Or could someone suggest an easier better way of doing this   Thanks  Update  Thanks for the answer  I m using the method detailed below to convert it to NULL   if    POST  location id                                                           POST  location id      NULL                           However when trying to use this NULL value with the following query it does not work   UPDATE addresses SET location id  NULL  WHERE ipid    4791    I know it needs to be location id NULL instead but don t know how to do this     Update 2  this is how my queries work   if    POST  location id               POST  location id      NULL      or  NULL  for SQL     notes isset   POST  notes      mysql real escape string   POST  notes             location id isset   POST  location id      mysql real escape string   POST  location id           ipid isset   POST  ipid      mysql real escape string   POST  ipid             sql  UPDATE addresses      SET notes   notes   location id   location id      WHERE ipid     ipid      mysql query  sql  or die mysql error

User · Answer

All you need is a check on the post side of things    if empty   REQUEST  type id     amp  amp    REQUEST  type id      0        REQUEST  type id     null

User · Answer

Yes  it is possible  You have to do something like this   if isset   POST  submit          type id      POST  type id            null          POST  type id            sql    INSERT INTO  table    type id   VALUES     type id          It checks if the   POST  type id   variable has an empty value  If yes  it assign NULL as a string to it  If not  it assign the value with   to it for the SQL notation

User · Answer

that s why Idon t like NULL values in the database at all  I hope you are having it for a reason   if    POST  location id                location id    NULL     else      location id         POST  location id           notes   mysql real escape string   POST  notes      ipid    mysql real escape string   POST  ipid       sql  UPDATE addresses      SET notes   notes   location id  location id     WHERE ipid     ipid     echo  sql    to see different queries this code produces    and difference between NULL and  NULL  in the query

User · Answer

No  POST GET values are never null  The best they can be is an empty string  which you can convert to null  NULL    if    POST  value                   POST  value     null     or  NULL  for SQL

User · Answer

In php 7 you can do     POST  value      null    If value is equal to    as said in other answers it will also send you null

[php] Is it possible to have a HTML SELECT/OPTION value as NULL using PHP?

Examples related to php

Examples related to html-select