Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Coding inside your component
MySQL triggers
  • Page:
  • 1

TOPIC:

MySQL triggers 29 Jul 2012 08:25 #2920

I would like to record automatically a datetime record in one of my SQL table when another field of the same table is changed by the front-end user.
I guess this is usually realized using SQL triggers.

1 => Where in j-cook interface can I define such triggers ?
2 => If it's not possible from the interface where should be the right place in the generated code to do it ?

Please Log in or Create an account to join the conversation.

Last edit: by admin.

Re: MySQL triggers 30 Jul 2012 16:57 #2928

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
You can use the 'Creation date' wizard.

If you want to use a different way :


MySQL has an issue here :
stackoverflow.com/questions/168736/how-d...ysql-datetime-column

You can realize it with two methods.


1st Method (Triggers)
TODO in :
sql/install.mysql.utf8.sql

Add the SQL instructions at the installation (like triggers)


2nd Method
TODO in :
tables/[myTable].php

in the check() function :

Test the value and if the value is empty, fill it with the current time (PHP call)
mktime()
or
www.php.net/manual/fr/function.date.php#...unction.date-seealso
Hope it helps
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.

Last edit: by admin.
  • Page:
  • 1
Forum
Support forum
Coding inside your component
MySQL triggers
Time to create page: 0.080 seconds
“
”

Although I found this tool some time ago I just started learning experimenting and building this first component on Monday and now on Thursday afternoon it's already online. Although I already had a working version done with another tool this is much easier to build and at the end you have the freedom to own your own component. Once you know how to use Cook you will boost your productivity as the learning curve is really moderate compared to many other tools.
Giori (Forum)

Get Started

Log In Sign In