CodeIgniter Forums
Update screen via ajax with DB data - Printable Version

+- 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: Update screen via ajax with DB data (/showthread.php?tid=31177)



Update screen via ajax with DB data - El Forum - 06-09-2010

[eluser]MarceloTM[/eluser]
Hello everyone, I'm trying to develop a 'pizza delivery' software, but the problem is that I need to update some field or flash some alert on the admin screen when someone makes a request from anywhere on the galaxy.
How can I make the DB send the data to the right place when someone makes a request? I'm using mySQL and jQuery for the ajax and I don't know if has anything to do with triggers, since I never used them...

Please, can anyone help?


Update screen via ajax with DB data - El Forum - 06-10-2010

[eluser]MarceloTM[/eluser]
No one again????


Update screen via ajax with DB data - El Forum - 06-11-2010

[eluser]LuckyFella73[/eluser]
The simplest way maybe would be to send an e-mail after someone
orders a pizza on the website. This way the admin gets a message
after each order.
If you want to get a message on a website you just have to set up
a routine and query the database for new entries. If you get it
to work to script the ordering-process that shouldn't be a problem
for you. Maybe write a looping ajax function with 1 minute timeouts.


Update screen via ajax with DB data - El Forum - 06-11-2010

[eluser]MarceloTM[/eluser]
Thanks Fella, I will try as you said and will let you know if i make some progress.