NYCPHP Meetup

[Malcolm, Gary]

mysql will judge based on field type so it works both ways :)

so in a date it inserts yyyy-mm-dd

in datetime it inserts yyyy-mm-dd hh-mm-ss

> -----Original Message-----
> From: Aaron Fischer [mailto:agfische at email.smith.edu]
> Sent: Tuesday, 27 May, 2003 9:47 AM
> To: NYPHP Talk
> Subject: Re: [nycphp-talk] need some form help...
> 
> 
> Gary,
> 
>  From mysql site it looks like now() creates date and 
> timestamp?  If you 
> are inserting to a date field, will it insert date and time, or just 
> date?
> 
> Aaron
> 
> On Tuesday, May 27, 2003, at 12:29 US/Eastern, Malcolm, Gary wrote:
> 
> > there is an even easier way...
> >
> > if you want the current time in your mysql database just 
> use the mysql
> > function NOW() in your insert statement (this works for 
> date, datetime
> > types) that way you can let the db do the messy date work. 
> I only mess
> > around with dates outside a db when absolutely necessary ( 
> and this is 
> > rare
> > since mysql has things like date arithmetic)
> >
> > ex. insert into mytable (datefield, name) values(NOW(), "$username")
> >
> >> -----Original Message-----
> >> From: Aaron Fischer [mailto:agfische at email.smith.edu]
> >> Sent: Tuesday, 27 May, 2003 9:23 AM
> >> To: NYPHP Talk
> >> Subject: Re: [nycphp-talk] need some form help...
> >>
> >>
> >> One way of making it easier is to not have any mention of 
> date in the
> >> form.  You are working behind the scenes with php to input
> >> the current
> >> date into mysql, so you don't have to ask the user anything
> >> pertaining
> >> to date.  This is nice because it is one less thing you are
> >> asking the
> >> user to do.
> >>
> >> In your php processing, set $date = date("Y-m-d");  Then 
> you can use
> >> $date along with your other form values that are posted and
> >> insert them
> >> into the database.
> >>
> >> HTH,
> >>
> >> Aaron
> >>
> >> On Tuesday, May 27, 2003, at 11:07 US/Eastern, Joshua S.
> >> Freeman wrote:
> >>
> >>> right now everything is in the same file...
> >>>
> >>> J.
> >>>
> >>> On 5/27/03 9:38 AM, "Aaron Fischer"
> >> <agfische at email.smith.edu> wrote:
> >>>
> >>>> Hey Josh,
> >>>>
> >>>> It would depend on how you have your form page and php
> >> processing set
> >>>> up.  How do you have your logic set up?  Do you have the
> >> form as one
> >>>> page and the php processing as a separate file, or are
> >> they both in
> >>>> the
> >>>> same file?
> >>>>
> >>>> Aaron
> >>>>
> >>>>
> >>>> On Tuesday, May 27, 2003, at 09:05 US/Eastern, Joshua S. Freeman
> >>>> wrote:
> >>>>
> >>>>> Hi Aaron,
> >>>>>
> >>>>> So... if, in my form, I want both the date to both be
> >> part of my form
> >>>>> input
> >>>>> as well as displayed on the page when the page is 
> loaded, how do I
> >>>>> write
> >>>>> that code?
> >>>>>
> >>>>>
> >>>>> Say I have a webpage 'waspsurvey.php3' that contains my form.
> >>>>>
> >>>>> When a surveyor loads that page in his/her browser, the form is
> >>>>> displayed
> >>>>> for the surveyor to fill out.
> >>>>>
> >>>>> At a point on the form, there is the parameter 'Date:'
> >> so, I'd want
> >>>>> ' $date = date("Y-m-d");
> >>>>>   print "$date";'
> >>>>> in waspsurvey.php3 so that the date will print in the 
> page.. but..
> >>>>> what do I
> >>>>> do to capture "$date" so that it becomes part of my form input?
> >>>>> <input
> >>>>> type="hidden" name="date" value="$date"> ?
> >>>>>
> >>>>> J.
> >>>>>
> >>>>>
> >>>>> the On 5/27/03 8:20 AM, "Aaron Fischer" 
> <agfische at email.smith.edu>
> >>>>> wrote:
> >>>>>
> >>>>>> For date, In your php script that handles the form, you can do
> >>>>>> something like:
> >>>>>>
> >>>>>> $date = date("Y-m-d");
> >>>>>>
> >>>>>> Then you can insert $date along with your other form
> >> variables into
> >>>>>> the
> >>>>>> mysql table.
> >>>>>>
> >>>>>> Aaron
> >>>>>>
> >>>>>>
> >>>>>>>
> >>>>>>>> Another point of confusion... one of the fields in the
> >> survey form
> >>>>>>>> is 'survey_date'.
> >>>>>>>>
> >>>>>>>> I have field of type 'date' in my 'specimen' table...
> >> I'd like to
> >>>>>>>> have
> >>>>>>>> the 'survey_date' be handled automagically for the
> >> surveyor by PHP
> >>>>>>>> and
> >>>>>>>> MySQL..
> >>>>>>>> any suggestions on how best to accomplish that?
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> > 
> >
> >
> 
> 
> 
> --- Unsubscribe at http://nyphp.org/list/ ---
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030527/8916403c/attachment.html>