phpmyedit-discuss

[PHPMyEdit-Discuss] now() date

[Jason <ok...@kd...>]

phpymyedit,

    I am trying to enter the current date and time into a date field.  Not a
timestamp field because, I don't want this field to change when the record
is updated.

The only approach I can think of, is to add a button or pulldown, on the
modify record page, when clicked it will add in a time.  When not clicked it
leaves the date field unmodified.

Has this been done before with phpmyedit?

I am trying to insert the now() command into the [fdd] area of the field,
although I haven't had good results, hence this post.

Thanks again for all your support and this excellent program

Jason

Re: [PHPMyEdit-Discuss] now() date

[Ondrej J. <ne...@po...>]

> I am trying to enter the current date and time into a date field.  Not
> a timestamp field because, I don't want this field to change when the
> record is updated.
> The only approach I can think of, is to add a button or pulldown, on
> the modify record page, when clicked it will add in a time.  When not
> clicked it leaves the date field unmodified.

Try this, it works well for me with 5.3 and current CVS as well.

$ezin_opts['fdd']['datetime'] = array(
		'name'=>Platon::htmlspecialchars2('Date & Time'),
		'select'=>'T',
		'sort'=>true,
		'required'=>true,
		'mask'=>'%.10s',
		'default'=>date('Y-m-d H:i:s')
		);

This is rough paste from my phpMyEzin project files, however point on
'default' option above.

> I am trying to insert the now() command into the [fdd] area of the
> field, although I haven't had good results, hence this post.

This will be _probably_ possible in 5.4... Something like:

$opts['fdd']['col_name']['sql|AC'] = 'NOW()';

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  This message was written with Pine, the fastest IMAP mail client
    '`

Re: [PHPMyEdit-Discuss] now() date

[jim k. <jim...@ya...>]

the evaluation time of 
    'default'=>date('Y-m-d H:i:s')
is at _add/update_page_generation_ time, not submit time.

If the user requests a record for add or update and then doesn't 
submit the page for 15 minutes or a couple of days, it's going to 
be off by that much.  If you need very accurate information in 
this field, this won't work at all.

suggestions:
1. within existing framework, 
    a. if you want only insert time, then use a pre-insert trigger to set the time field
    b. if you want last updated times, then you could 
        - make the column definition be a timestamp
       or
        - use both pre-insert and pre-update trigger to set the time field
2. extend PME by adding an 'eval' field option.
    'eval'=>Array(
        'eval_time'=>'IU',        // I(nsert) and U(pdate)
        'expr'=>"date('Y-m-d H:i:s')",
        'expr_type'=>'sql'        // sql or php
    ),

where the expr is eval'd (security warning!) by either PHP or MySQL

--jim

--- Ondrej Jombik <ne...@po...> wrote:
> > I am trying to enter the current date and time into a date field.  Not
> > a timestamp field because, I don't want this field to change when the
> > record is updated.
> > The only approach I can think of, is to add a button or pulldown, on
> > the modify record page, when clicked it will add in a time.  When not
> > clicked it leaves the date field unmodified.
> 
> Try this, it works well for me with 5.3 and current CVS as well.
> 
> $ezin_opts['fdd']['datetime'] = array(
> 		'name'=>Platon::htmlspecialchars2('Date & Time'),
> 		'select'=>'T',
> 		'sort'=>true,
> 		'required'=>true,
> 		'mask'=>'%.10s',
> 		'default'=>date('Y-m-d H:i:s')
> 		);
> 
> This is rough paste from my phpMyEzin project files, however point on
> 'default' option above.
> 
> > I am trying to insert the now() command into the [fdd] area of the
> > field, although I haven't had good results, hence this post.
> 
> This will be _probably_ possible in 5.4... Something like:
> 
> $opts['fdd']['col_name']['sql|AC'] = 'NOW()';
> 
> --
>   _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
>  <_  \  Platon SDG - open source software development - http://platon.sk
>    `\|  This message was written with Pine, the fastest IMAP mail client
>     '`
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: ObjectStore.
> If flattening out C++ or Java code to make your application fit in a
> relational database is painful, don't do it! Check out ObjectStore.
> Now part of Progress Software. http://www.objectstore.net/sourceforge
> _______________________________________________
> Phpmyedit-discuss mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com