The system basically work in this series: a new registration is made in the database, the system sends me an e-mail notifcando a new record.
theflashbr 0 Newbie Poster
kindo 0 Newbie Poster
Do you have any code that ypu've written. So the community can know what you need.
Php code and mysql schema.
James_43 15 Junior Poster
Look up PHPMailer, in my experience it really is the best option. You can of course use the php mail() function, however, it does depend on a local mail server, wheras PHPMailer can connect through SMTP. https://github.com/PHPMailer/PHPMailer
Once configured correctly, you can easily make calls to PHPMailer to construct a message. Simply place that code once your database function returns true.
AleMonteiro 238 Can I pick my title?
If you doubt is who to know when to send an email, i see two options for you:
Use cron jobs that will run at specific intervals, identify the new records and send the e-mail. This way you can do it easily with PHP but you'll need to have some flag to know if that record was already mailed or not.
Use a trigger on your SQL Server that will run and external command (probably call your PHP mailing page) each time a record is created.
dean8710 -3 Junior Poster in Training
<?php
//query insert new record
//if(//inserted successfully){
//send email
if(//email_was_sent){
//inform_user
}
}
else{
}
?>
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.