Home > database >  Auto add new data with default value for each day every 12 PM using MySQL and Codeigniter 4
Auto add new data with default value for each day every 12 PM using MySQL and Codeigniter 4

Time:04-23

I am trying to create function to automatically adding rows every 12 PM each day for attendance record table, total data based on total employees, for example I have 5 employees, so I need function to adding 5 new rows with default value that I have set before.

here is my table:

enter image description here

Thanks for any ideas.

CodePudding user response:

Just write php script for this work.

and scheduler it into Cron job.

You can following: Execute PHP script in cron job

  • Related