SQL validation!
Posted
by Filip
on Stack Overflow
See other posts from Stack Overflow
or by Filip
Published on 2010-06-05T12:42:59Z
Indexed on
2010/06/05
12:52 UTC
Read the original article
Hit count: 190
I am pretty new in SQL so this may be a stupid question...
I have a form in PHP which fills in few fields in my SQL table. I have this code:
$sql="INSERT INTO $tbl_name
(app_name, app_path, short_desc, full_desc)
VALUES ('$_POST[app_name]', '$_POST[app_path]',
'$_POST[short_desc]', '$_POST[full_desc]')";
But even app_name and app_path are NOT NULL columns, the query can be executed if there is no text in these fields in the form.
So, my question is:
How to stop the execution of the query if there is no text in the NOT NULL fields ?
© Stack Overflow or respective owner