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.079 seconds
“
”

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)

         

Get Started

Log In Sign In