Member Avatar for yanti

hi guys, just want to know how to do alert via email when a new record updated in database. i use php and mySql. thanks.

  • 4 Contributors
  • 3 Replies
  • 116 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by MayaLocke
Member Avatar for tyfius

Use the mail function. Simply add the functionality to send an email after you made the update statement.

Member Avatar for sikka_varun

Once you post the data, insert it into the mysql database, use the mail function to send the confirmation through the email. Usually mail function does not work on local systems as no mail exchange service is installed like SMTP. So u need to test it on a real-time hosting server.

Refer the mail function documentation here -> http://php.net/mail

Member Avatar for MayaLocke

hi guys, just want to know how to do alert via email when a new record updated in database. i use php and mySql. thanks.

You could use something like PageGate with the commandline/ascii to send alert when a record or something is updated. Does not have to be an email could be a text message as well.
HTH

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.