sign in | join about | help | sitemap
Connecting Tech Pros Worldwide
Bart Nessux's Avatar

checking for data before doing sql insert


Question posted by: Bart Nessux (Guest) on July 17th, 2005 05:20 AM
I have a html form (generated by PHP) that users can fill out and submit
into a database. Everything works fine. However, I'd like to check to make
sure that each field in the form actually contains data (no null/void
fields) before doing the insert into the database. Any tips on how to do
this?

Thanks,
Bart

1 Answer Posted
kingofkolt's Avatar
Guest - n/a Posts
#2: Re: checking for data before doing sql insert

one idea is to do something like this...

function checkForm() {
if (!empty($_REQUEST['formitem1']) && !empty($_REQUEST['formitem2'] &&
!empty($_REQUEST['formitem3'] etc...) {
return true;
} else {
return false;
}
}

if (checkForm()) {
// insert stuff into database here because checkForm() returns true
} else {
print "Please fill out all fields in the form";
}


- JP

"Bart Nessux" <bart_nessux@hotmail.com> wrote in message
news:c3n316$k8i$1@solaris.cc.vt.edu...[color=blue]
> I have a html form (generated by PHP) that users can fill out and submit
> into a database. Everything works fine. However, I'd like to check to make
> sure that each field in the form actually contains data (no null/void
> fields) before doing the insert into the database. Any tips on how to do
> this?
>
> Thanks,
> Bart
>[/color]


 
Not the answer you were looking for? Post your question . . .
196,987 members ready to help you find a solution.
Join Bytes.com

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 196,987 network members.
Post your question now . . .
It's fast and it's free

Popular Articles

Top Community Contributors