+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: is it possible to configure the update of database according the time ? (/showthread.php?tid=50069)
is it possible to configure the update of database according the time ? - El Forum - 03-13-2012
[eluser]ludo31[/eluser]
Hello ;
I mean if it's possible to update ou to delete for example the 10 last rows in database per month ou 3 months . and it does it automatically .
I would like to create a site where people can publish something that they wanna to sell , but I 'm afraid about the width of my data , so I would like to delete the old message .
s if it's possible in codeigniter
thanks
is it possible to configure the update of database according the time ? - El Forum - 03-13-2012
[eluser]marcogmonteiro[/eluser]
You probably want to do that in your server and not depend on codeigniter for that. Just create a routine with the necessary mysql for that and you're good to go.
is it possible to configure the update of database according the time ? - El Forum - 03-13-2012
[eluser]PhilTem[/eluser]
It's possible in pure PHP so it's definitely possible in CI!
Either make CronJobs or put a model's method-call into MY_Controller which automatically deletes all old data (given you have a timestamp within the tables you want to delete data from).
Have you already tried something? Then post your code snippets so it's easier for use to help you
is it possible to configure the update of database according the time ? - El Forum - 03-13-2012
[eluser]marcogmonteiro[/eluser]
sure it's possible, I normally just don't bother with it
I do all this stuff on the server it self
is it possible to configure the update of database according the time ? - El Forum - 03-13-2012
[eluser]ludo31[/eluser]
Hello ;
not at all , but when I try , I posted here .
thanks
is it possible to configure the update of database according the time ? - El Forum - 03-13-2012
[eluser]CroNiX[/eluser]
http://ellislab.com/codeigniter/user-guide/general/cli.html
Just set up a cron job
is it possible to configure the update of database according the time ? - El Forum - 03-17-2012
[eluser]ludo31[/eluser]
I don't understand !! can you explain more ??with example if it's possible please