Re: Date Test...

[Don Wieland <donw@xxxxxxxxxxxxxxxxxx>]

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