How can i get values from one table and save in other table using event in phpmyadmin

by 10 replies
12
I am trying to make a login system for user with following things. I wanted to know user is logging in my website or not.


I create a table "user_record" and i am saving "user last login" value in column "last_login_time"...


Now my question i wanted to create event which check if user last login date is 3 month old then insert "idol/delete" in another table(user_status) column name "status" and i want this event after every 24 hours.
Can any one help me ?
#programming #event #phpmyadmin #save #table #values
  • [DELETED]
  • That's not something for phpMyadmin, you need to create a script and a cron job.
    • [ 1 ] Thanks
  • okay thanks
  • make another field which is related to your source table
    You can try the Select then Insert into command. by the way what database are u using?
  • MySQL normal database with used in hosting phpmyadmin.

    Can you write query for me ?
    • [1] reply
    • Robin is right. Most, if not all, databases CAN'T schedule! NO variant of standard SQL allows for it. Triggers are triggered ONLY by events in SQL, NOT purely time, so you can't do it there. Even stored procedures need some trigger or must be called.

      THAT means this must be done by an EXTERNAL program triggered by time, and cron triggers programs by time.

      And nobody could give you the SQL without more info. Just for starters, you would have to specify AT LEAST an identifier on the source and target table. Of course, one wonders why you don't have this all in one table. It is a waste of space/effort to not do that. You could change the value to a short integer flag, and save several bytes there. You will probably save dozens on the overhead. So you could have maybe only 5% waiting for deletion and STILL save space, and you wouldn't have to worry about joins to do the deleting.

      Steve
  • Okay so one thing is clear i can do this work using cron job.

    Can any one explain cron job ? and write any simple command for me ?

    I tried in my hosting and i write command echo "hello everyone"; but nothing happened...No email received

    Can you tell me about command ?
  • I don't know how your host does it, but if you have terminal (SSH) access to your host, simply type `crontab -e` to edit your crontab, and read the manual if you need to do anything advanced. A daily cron job would look something like this:

    Code:
    MAILTO=myemail@example.com
@daily /usr/bin/php /path/to/script.php
    I never use PHP for server administration stuff, but you probably do, so this is just an example. The path to PHP may vary, depending on which flavor of server you have.

    You probably just need to ask your host how to execute a cron job though, most hosts have their own pre-configured way of doing this.
  • Instead of making a whole new table what not just make a new field and flag the user as inactive.
  • You can take backup using export options and then you can easily restore using import in another database
  • You cannot do it directly scripting in the phpmyadmin you should
    make a php page for it and you can then write script in php to copy
    data according to the conditions.
Join the discussion

Next Topics on Trending Feed