Sending Email with MYSQL data

Question

This is for a school project creating a parking reservation. The data inserts into the database fine and the email gets sent. I am just having a hard time displaying the reservation information in the email or will it be better to display the information using the variables? The goal is to have the user see the information that gets inserted to the database in the email they receive.

<?php
$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name="Reservation"; // Table name
$confirm_code=substr(number_format(time() * rand(),0,'',''),0,10);

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Get values from form
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$gname=$_POST['garage'];
$license=$_POST['license'];
$myusername=$_POST['email'];
$floor=$_POST['floor'];
$spot=$_POST['spot'];

// Insert data into mysql
$sql="INSERT INTO $tbl_name(Confirmation, Fname, Lname, Gname, License, Floor, Spot )
VALUES('$confirm_code', '$fname', '$lname', '$gname', '$license', '$floor', '$spot')";
$result=mysql_query($sql);


// if suceesfully inserted data into database, send confirmation link to email 

      if($result){
// ---------------- SEND MAIL FORM ----------------

      // send e-mail to ...

      $to=$myusername;

    // Your subject

      $subject="Your Parking Reservation is Confirmed";

    // From

      $header="from: Luxury Parking <luxuryparking.comeze.com>";

    // Your message

      $message=" \r\n";

      $message.="The following is your reservation information. \r\n";

      $message.=$result;

      // send email

      $sentmail = mail($to,$subject,$message,$header);
    }

      // if not found 

      else {

      echo "Not found your email in our database";

      }

      // if your email succesfully sent

      if($sentmail){

    header("Location: reservationmade.php");

      }

      else {

      echo "Cannot send Confirmation link to your e-mail address";

      }
    ?>

You shouldn't use mysql_* functions anymore. Use PDO or mysqli instead... http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php — luchosrock, Jul 10 '13 at 00:50
This is for a school project and i been using codes i found on different sites, i heard that PDO is better but i rather use the above since im familiar with it. — Tristan Krishindat, Jul 10 '13 at 00:52

score 2 · Accepted Answer · answered Jul 10 '13 at 00:51

After your query is finished MySql is returning a boolean value in $result.

You need to just manually add all your values into your email with a cognitive statement.

Example:

$message .= $fname;
$message .= $lname;
$message .= $gname;
$message .= $license;
$message .= $myusername;
$message .= $floor;
$message .= $spot;

Instead of

$message .= $result;

It most likely is just putting 1 or 0 into the email.

Sending Email with MYSQL data

1 Answers1