On Jul 8, 2010, at 10:09 AM, Ashley Sheridan wrote:
thanks Ash,
I figure it out. I was not entering the full year.
date('y-m-d',strtotime($fval))
needed to be
date('o-m-d',strtotime($fval))
Duh ;-)
Thanks,
Don
On Wed, 2010-07-07 at 13:28 -0700, Don Wieland wrote:
Hello all,
I am processing an array to build an INSERT string in PHP. The code
below I build an a separate array for the TARGET fields and the
VALUES.
I am trying to trap for a NULL ENTRY in a Date Input Field. Date
fields are identified with: $ffield['s']=='/'
I tried to add the "&& !empty($fval)" to the test but it is giving my
an unexpected results. In my case, I have a Data of Birth field that
keeps populating in the future: So 1941-06-16 inserts in the DB as
2041-06-16.
foreach($form_fields as $ffield){
$fval = is_array($ffield['f'])?joinFields($ffield['s'],
$ffield['f']):$_POST[$ffield['f']];
$query_values[] = "'".mysql_real_escape_string($ffield['s']=='/'
&& !empty($fval) ?date('y-m-d',strtotime($fval)):$fval)."'";
}
Will anyone point out the problem with this CODE?
Don Wieland
I can't see anything immediately wrong, but the tertiary operators
here mixed in with the mysql_ function and string concatenation
don't make for easy reading! Maybe add some brackets to partition
things off a bit to make the code easier on the eye. :p
Have you tried echo'ing out the queries to see if they actually look
well-formed? One place it could fall over is if the values you're
using in it aren't well formed.
Lastly, you're using a $_POST field directly in your query if the
first tertiary if/else fails. You should at the very least validate
it to make sure it's in the form you expect, which has to at least
be something that can be parsed and processed by strtotime() which
you're using in your example.
Thanks,
Ash
http://www.ashleysheridan.co.uk
Don Wieland
D W D a t a C o n c e p t s
~~~~~~~~~~~~~~~~~~~~~~~~~
donw@xxxxxxxxxxxxxxxxxx
Direct Line - (949) 305-2771
Integrated data solutions to fit your business needs.
Need assistance in dialing in your FileMaker solution? Check out our
Developer Support Plan at:
http://www.dwdataconcepts.com/DevSup.html
Appointment 1.0v9 - Powerful Appointment Scheduling for FileMaker Pro
9 or higher
http://www.appointment10.com
For a quick overview -
http://www.appointment10.com/Appt10_Promo/Overview.html