Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Check before insert in Database
May 21, 2006, 8:40 pm
rate this thread
I would to know how to check the value I am getting from an HTML form.
Let's put it that way, I need to get a string and I would like to make sure
this is a string and not a number for instance.
What kind of test could I use to check that?
//here is the line where I get the value
$variable = $_POST['value'];
The point is I have to insert the data in an Oracle database. And I would
like to test it before sending the data to the database.
Any advice, please?
Re: Check before insert in Database
Everything you get from $_POST is a string. It might also be the
string representation of a number.
Make checks appropriate for the specific data involved. PHP has
all sorts of nice string functions to pick strings apart, to do
regular expression matching, etc. If a serial number is supposed
to be a letter followed by 5 digits, you might match it against
is_numeric() checks for a string that could be interpreted as a number.
It allows signs, decimal points, and exponential notation.
That's a very good idea, but I don't see what kind of field has restrictions
like "any string that isn't a number".
Gordon L. Burditt