Empty data was able to be stored to the Database in CakePHP even if "Not Null" had been specified.

Posted by kwokwai on Stack Overflow See other posts from Stack Overflow or by kwokwai
Published on 2010-06-11T15:35:47Z Indexed on 2010/06/11 15:42 UTC
Read the original article Hit count: 130

Filed under:

cakephp

Hi all,

I was doing some self learning on CakePHP 1.26 with Mysql 5.
I got a simple table with only one field and had applied "Not Null" to this field.
This field in the table was corresponding to a Input text box in a HTML form.
I tried not to enter anything into the Input text field, and then
I saw that empty data was able to be stored into the Table even if "Not Null" had been applied to this field.

I am confused of this result. Could you help me please?

Related posts about cakephp

Losing sessions with window.open and cakephp redirection in PHP with cakephp

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys, Ok, here goes a very strange problem... Our team is using cakephp to develop a large application. Everything session related is working properly so far. The only issues we've had so far are related to iframes and opening windows in other subdomains. I'll explain: User opens up site… >>> More
CakePHP sending multiple lines of same cookie information in response header. why??

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I am having this problem with one of my cakePHP applications. My application displays a big html table on the page. I noticed that when the table goes beyond a certain size limit, IE cannot display that page. While trying to figure out why this happens, I noticed that my html response… >>> More
CakePHP: trouble configuring .htaccess for user directories enabled server

as seen on Server Fault - Search for 'Server Fault'
I've placed the CakePHP files in a directory in /home/user/public_html/cakephp. When I try to reach localhost/~user/cakephp with my browser, there's an error message. In my case, since I'm using Chrome, it is 'Oops! This link appears to be broken.". Looking for a solution on Google, I found a few… >>> More
CakePHP: 2-level JOIN with one Query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following models in CakePHP: A Deposit belongs to an Account An Account belongs to a Customer I want to have a list of Deposits, and I need to show the name of the customer (so I have to join through the Customer). I also need to paginate this list. If I set Deposit->recursive = 2… >>> More
[CakePHP] Can not Bake table model, controller and view

as seen on Stack Overflow - Search for 'Stack Overflow'
I developed small CakePHP application, and now I want to add one more table (in fact, model/controller/view) into system, named notes. I had already created a table of course. But when I run command cake bake model, I do not get table Notes on the list. I can add it manually, but after that I get… >>> More

Developer IT

Empty data was able to be stored to the Database in CakePHP even if "Not Null" had been specified. - Developer IT

Empty data was able to be stored to the Database in CakePHP even if "Not Null" had been specified.

cakephp

Related posts about cakephp

Losing sessions with window.open and cakephp redirection in PHP with cakephp

CakePHP sending multiple lines of same cookie information in response header. why??

CakePHP: trouble configuring .htaccess for user directories enabled server

CakePHP: 2-level JOIN with one Query

[CakePHP] Can not Bake table model, controller and view

Categories cloud