Results 1 to 2 of 2

Thread: How To Send MYSQL Data To An Email

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2025
    Posts
    1

    How To Send MYSQL Data To An Email

    After the customer fills the form, the form data is sent to mysql and an email gets sent to me with the last form data that the customer submitted. But, the email "last mysql data" is not going as inline text. Please help me. Sample code is given below.

    PHP Code:
    <?php
    define
    ('DB_NAME''XXXXXXX');
    define('DB_USER''XXXXXXX');
    define('DB_PASSWORD''XXXXXXX');
    define('DB_HOST''localhost');
    $link mysql_connect (DB_HOSTDB_USERDB_PASSWORD);
    if (!
    $link) {
    die(
    'Could not connect: ' mysql_error());
    }
    $db_selected mysql_select_db(DB_NAME$link);
    if (!
    $db_selected) {
    die(
    'Can\'t use ' DB_NAME ': ' mysql_error());
    }
    //Start Posting the data in Mysql database from Form Input
    $value $_POST['input1'];
    $value2 $_POST['MAmount'];
    $sql "INSERT INTO demo (input1, MAmount) VALUES ('$value', '$value2')";
    if (!
    mysql_query($sql)) {
    die(
    'Error: ' mysql_error());
    }
    //start print the database
    $data mysql_query("SELECT * FROM demo ORDER BY ID DESC LIMIT 1")
    or die(
    mysql_error());
    Print 
    "<table border cellpadding=3>";
    while(
    $info mysql_fetch_array$data ))
    {
    Print 
    "<tr>";
    Print 
    "<th>ID:</th> <td>".$info['ID'] . "</td> ";
    Print 
    "<th>Input1:</th> <td>".$info['input1'] . "</td> ";
    Print 
    "<th>MAmount:</th> <td>".$info['MAmount'] . " </td></tr>";
    }
    Print 
    "</table>";
    mysql_close();
    //end print the database on form processing page
    //start emailing the data
    date_default_timezone_set('Asia/Kolkata');
    require_once(
    'class.phpmailer.php');
    //include("class.smtp.php"); // optional, gets called from within class.phpmailer.php if not already loaded
    $mail = new PHPMailer();
    //$body = "gdssdh";
    //$body = preg_replace("[\]",'',$body);
    $mail->IsSMTP(); // telling the class to use SMTP
    $mail->Host "ssl://XXXXXXX.XXXXXXX.org"// SMTP server
    $mail->SMTPDebug 1// enables SMTP debug information (for testing)
    // 1 = errors and messages
    // 2 = messages only
    $mail->SMTPAuth true// enable SMTP authentication
    $mail->SMTPSecure "ssl"// sets the prefix to the servier
    $mail->Host " [url]www.astaguru.com[/url] "// sets GMAIL as the SMTP server
    $mail->Port 465// set the SMTP port for the GMAIL server
    $mail->Username "XXXXXXX.com"// GMAIL username
    $mail->Password "XXXXXXX"// GMAIL password
    $mail->SetFrom('contact@XXXXXXXX.com''HAL');
    //$mail->AddReplyTo("XXXXXXX', 'First Last");
    $mail->Subject "XXXXXXX";
    //THE PROBLEM IS HERE WHEN I WANT TO SEND THE DATA AS INLINE TEXT TO EMAIL FROM MYSQL IT IS NOT WORKING. ONLY "PRINT THE DATA" IS SENDING TO EMAIL.
    $body 'Print the data';
    mysql_connect("localhost","XXXXXXX","XXXXXXX");
    @
    mysql_select_db("XXXXXXX");
    $query["SELECT * FROM demo ORDER BY ID DESC LIMIT 1"];
    $result mysql_query($query);
    //while ($row = mysql_fetch_array ($result)) {
    // $mail->AltBody = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test
    $mail->MsgHTML($body);
    $address "XXXXXXX";
    $mail->AddAddress($address"user2");
    //$mail->AddAttachment("images/phpmailer.gif"); // attachment
    //$mail->AddAttachment("images/phpmailer_mini.gif"); // attachment
    if(!$mail->Send()) {
    echo 
    "Mailer Error: " $mail->ErrorInfo;
    } else {
    echo 
    "Message sent!";
    }
    ?>
    Last edited by dday9; Jan 13th, 2025 at 10:18 AM.

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: How To Send MYSQL Data To An Email

    That's because your body is set here: $body = 'Print the data'; If you want it set to something else, then you need to change this line.


    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width