Zend: How to insert NULL values into MySQL

php mysql zend-framework null zend-db
Naveed picture Naveed · Nov 13, 2009 · Viewed 9k times · Source

I am using Zend Framework with MySQL,Apache and Ubuntu 9.04.

I am trying to insert NULL values into database like this:

$personObj->setPersonId( '1' );
$personObj->setPersonEmail('NULL');
$personObj->save();

But 'NULL' is stored in database as string and not NULL.

When I use this:

$personObj->setPersonId( '1' );
$personObj->setPersonEmail(NULL);
$personObj->save();

But nothing happens and previous entry is unchanged.

What should I do to insert NULL values into MySQL?

Answer

Joseph Montanez picture Joseph Montanez · Nov 13, 2009

If you are not modifying any of the values after they are assigned then 

new $personObj->setPersonEmail(new Zend_Db_Expr('NULL'));

Related questions

php, mysql - Too many connections to database error

Good day to all. I have an odd error. I have created a chat that works like this: questions/answers are inserted into a db every 2 seconds an ajax request is sent to a php script that fetch the new …

Read More
How to print exact sql query in zend framework ?

I have the following piece of code which i taken from model, ... $select = $this->_db->select() ->from($this->_name) ->where('shipping=?',$type) ->where('customer_id=?',$userid); echo $select; exit; // …

Read More
Running MySQL *.sql files in PHP

I have two *.sql files that I use when creating a new web site database. The first file creates all the tables. The second file populates some default records. I would like to execute these files from PHP. I also …

Read More