2uzhan.com
Advertisement
Now Place:2uzhan.com » How to send a mail as soon as record is updated in mysql

How to send a mail as soon as record is updated in mysql

Web Development @ March 4, 2013   Views:0

Hello,

I have a Mysql table, where i want that after i execute the update query in the JSP form, an automated mail is send to the email id in the record.Can anyone tell me how to do this?

--------------Solutions-------------

You must download javax.mail-1.3.3.01.jar and take a look at Tranport class.

any other help?? any code?

Google results for its examples http://lmgtfy.com/?q=javax.mail+example
I would say take a look at this one or this one.

it would be like this... on click of button, the entire record set should be mailed to the email id in that record set..

well, if you code it like that, it will work like that, but we won't write your code for you. put in a bit effort yourself,it's doable.

I'm attempting to simplify my fundraising page, and would like to show exactly how much each donation would help us out. I've listed the options below, but I would like ...

I'm currently doing some encoding work to protect a site from XSS attacks. We've stuck a bunch of <script>debugger;</script> tags in the db. Dispite my best efforts, the strings I've ...

    //The php section of the code

           <?php

           function getJSONFromDB($sql){

           $conn = mysqli_connect("localhost", "root", "","rent");

           //echo $sql;

           $result = mysqli_query($conn, $sql)or die(mysqli_error());

           $arr=array();

           while($row = mysqli_fetch_assoc($result)) {

                   $arr[]=$row;

               }

               return json_encode($arr); ...
Tags:mail, mysql, jsp
© 2018 2uzhan.com Contact