Welcome Guest, Not a member yet? Register   Sign In
Update screen via ajax with DB data
#1

[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?
#2

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

[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.
#4

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




Theme © iAndrew 2016 - Forum software by © MyBB