Random IT Tidbits

Had a need to send null values through PHP today. Finally figured it out. If I had the following query

$qry = INSERT INTO company_tb (cname,address,city) values (‘$name’,'$address’,$city)

and $city was my variable to pass the city value, then I would do the following

if ($city==”") //if $city is empty

$city = “NULL”; //set it as NULL

else $city = “‘” . $city . “‘”; //else set it as the city name plus single quotes around it. So if $city had Karachi, $city would become ‘Karachi’

So the query would become INSERT INTO company_tb (cname,address,city) values (‘Aqueeb’,'test address’,'Karachi’) if there was a city value otherwise it would become INSERT INTO company_tb (cname,address,city) values (‘Aqueeb’,'test address’,NULL)

Hope this helps someone! If you have any questions please feel free to ask them!

Tags: PHP MySql NULL

This entry was posted on Sunday, September 20th, 2009 at 12:09 pm and is filed under PHP MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.