Re: Check before insert in Database
- From: gordonb.mc8hl@xxxxxxxxxxx (Gordon Burditt)
- Date: Sun, 21 May 2006 21:26:42 -0000
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.
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
"[A-Za-z][0-9][0-9][0-9][0-9][0-9]".
is_numeric() checks for a string that could be interpreted as a number.
It allows signs, decimal points, and exponential notation.
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.
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
.
- References:
- Check before insert in Database
- From: Steph
- Check before insert in Database
- Prev by Date: Re: Variable scope - function in function
- Next by Date: Re: I need a mini "logic interpreter"
- Previous by thread: Re: Check before insert in Database
- Next by thread: Re: Check before insert in Database
- Index(es):
Relevant Pages
|
