0

i dont have any idea how to send through email

i have a sample ticket. i dont know if i'm going to convert the php file into pdf..

i have no idea exactly..

if ever its hard, how can i send the sample ticket through inputted email of a customer...

2
Contributors
6
Replies
7
Views
7 Years
Discussion Span
Last Post by venus_me11
0

i dont have any idea how to send through email

i have a sample ticket. i dont know if i'm going to convert the php file into pdf..

i have no idea exactly..

if ever its hard, how can i send the sample ticket through inputted email of a customer...

There's a great bit of code out there for doing just what you are wanting it to do. It's now located in the google code labs, and can be found here:

http://code.google.com/p/dompdf/

My 2¢. Hope this helps.

0

Here's what it looks like.. its a table of our sample ticket... please help me.. tnx in advance..

<?php
		$db=mysql_connect('localhost', 'root', '');

		if ($dbc=mysql_connect('localhost','root','')){
			if(!mysql_select_db('bus')){
			die ('could not select the database because:'.mysql_error());
			}
		}
		else {
			die ('could not select the database because:'.mysql_error());
		}

		$res=mysql_query("SELECT * FROM customer WHERE ReservationID='{$_REQUEST['ReservationID']}'", $db);


		$Name = "";

		while($row = mysql_fetch_array($res) )
		{
			$ReservationID=$row['ReservationID'];
			$TempID=$row['IDTemp'];
			$ages .= $row['Age'] . ",";
			$names .= $row['Name'] . ",";
			$contacts .= $row['Contact'] . ","; 
			$Address=$row['Address'];
			$Age=$row['Age'];
			$Contact=$row['Contact'];
			$Email=$row['Email'];
			$DateReserved=$row['DateReserved'];
			$Company=$row['Company'];
			$BusNo=$row['BusNo'];
			$Busfrom=$row['Busfrom'];
			$Busto=$row['Busto'];
			$DepDate=$row['DepDate'];
			$ArrDate=$row['ArrDate'];
			$Seats=$row['Seats'];
			$NoSeats=$row['NoSeats'];
			$Price=$row['Price'];
			$Total=$row['Total'];
			$TimeDest=$row['TimeDest'];
			$TimeADest=$row['TimeADest'];
			$BusType=$row['BusType'];
		}
?>
<html>
<head>
<link href="style/ticket_style.css" rel="stylesheet" type="text/css" media="print">
<title>Buckle Up - Online Reservation System</title>
</head>
<body>
<div id="templatemo_content_wrapper">
<div id="templatemo_content">

<center>

<table border="1" width="800">
	<tr>
		<td rowspan="3" align=center>
			<img src="images/grayscale.jpg" width="179" height="97">
			<img src="images/grayscale1.jpg" width="320" height="60">
		</td>
		<td align=center bgcolor=#FFFFFF><b><font size="2" face="arial">Reservation No.</font></b></td>
		
	</tr>
	<tr align=center>
		<td height="27"><font face="arial" size="2"><?php echo $ReservationID;?></font></td>
		
	</tr>

	<tr align="center">
		<td bgcolor=#FFFFFF><b><font size="2" face="arial">Date & Time Issued</font></b></td>
	</tr>
	<tr align="center">
		<td ><font size="2" face="arial"> J.P. Rizal Ext. West Rembo, Makati City</font></td>
		<td><font size="2" face="arial">
			<?php
			date_default_timezone_set('Asia/Manila');
			echo $DateReserved; echo "<br>"; print date("h:i A");
			?>

			</font></td>
	</tr>
</table>
	<font face="arial">
<table border="1" width="800">
	<tr>
		<td colspan="4" bgcolor="#FFFFFF"><font size="3"><b>PASSENGER DETAILS</b></font></td>
	</tr>
	<tr>
		<td><font size="2">Name</font></td>
		<td colspan="3"><font size="2"><?php echo $names;?></font></td>
	</tr>
	<tr>
		<td><font size="2">Address</font></td>
		<td width="65%" colspan="3"><font size="2"><?php echo $Address;?></font></td>
	</tr>
	<tr>
		<td width="31%"><font size="2">Age</font></td>
		<td width="28%"><font size="2"><?php echo $ages;?></font></td>
		<td width="20%"><font size="2">Contact No.</font></td>
		<td width="35%"><font size="2"><?php echo $contacts;?></font></td>

	</tr>
	<tr>
		<td width="15%" ><font size="2">Email</font></td>
		<td width="22%" colspan=4><font size="2"><?php echo $Email;?></font></td>
	</tr>
</table>

<table border="1" width="800">
	<tr>
		<td colspan="6" bgcolor="#FFFFFF"><b><font size="3">TRIP DETAILS</font></b></td>
	</tr>
	<tr>
		<td width="20%"><font size="2">Bus Company</font></td>
		<td colspan="5"><font size="2"><?php echo $Company ?></font></td>
	</tr>
	<tr>
		<td width="20%"><font size="2">Bus Type</font></td>
		<td colspan="5"><font size="2"><?php echo $BusType;?></font></td>
	</tr>
	<tr>
		<td width="20%"><font size="2">Bus No.</font></td>
		<td colspan="5"><font size="2"><?php echo $BusNo;?></font></td>
	</tr>
	<tr>
		<td height="24" width="20%"><font size="2">Seat No(s)</font></td>
		<td height="24" colspan="5"><font size="2"><?php echo $Seats;?></font></td>
	</tr>
	<tr>
		<td colspan="3" bgcolor="#FFFFFF"> <font size="2"><b>Departure</b></font></td>
		<td colspan="3" bgcolor="#FFFFFF"><font size="2"><b>Arrival</b></font></td>
	</tr>
	<tr>
		<td width="20%"><font size="2">From</font></td>
		<td width="16%"><font size="2">Date</font></td>
		<td width="13%"><font size="2">ETD</font></td>
		<td width="18%"><font size="2">To</font></td>
		<td width="15%"><font size="2">Date</font></td>
		<td width="13%"><font size="2">ETA</font></td>
	</tr>
	<tr>
		<td width="20%"><font size="2"><?php echo $Busfrom;?></font></td>
		<td width="16%"><font size="2"><?php echo $DepDate;?></font></td>
		<td width="13%"><font size="2"><?php echo $TimeDest;?></font></td>
		<td width="18%"><font size="2"><?php echo $Busto;?></font></td>
		<td width="15%"><font size="2"><?php echo $ArrDate;?></font></td>
		<td width="13%"><font size="2"><?php echo $TimeDest;?></font></td>
	</tr>
</table>

<table border=1 width=800>
	<tr>
		<td width="51%"><font size="2">No. of Seats Reserved</font></td>
		<td><font size="2"><?php echo $NoSeats;?></td>
	</tr>
	<tr>
		<td width="51%"><font size="2">Price per Seat</font></td>
		<td><font size="2"><?php echo $Price;?></td>
	</tr>
	<tr>
		<td width="51%"><font size="2">Reservation Fee</font></td>
		<td><font size="2"><?php echo $_REQUEST['fee'];?></td>
	</tr>
	<tr>
		<td width="20%"><font size="2">Total</font></td>
		<td><font size="2"><?php echo $Total;?></td>
	</tr>
</table>
<br>
<table border=1 width=800>
	<tr>
		<td colspan="6" bgcolor="#FFFFFF"><b><font size="3">Note</font></b></td>
	</tr>
	<tr>
		<td colspan="6" width="51%"><font size="2">Kindly present the printed ticket to Bayad Center for the payment.</font></td>

	</tr>
	<tr>
		<td colspan="6" height=30><font size="2">Upon payment, please bring a valid ID.</font></td>
	</tr>

</table><br>
<table border=1 width=800>
	<tr>
		<td colspan="6" bgcolor=#FFFFFF><b><font size="3">Bayad Center Print Validation</font></b></td>
	</tr>
	<tr>
		<td colspan="6" height="100"><b><font size="3"></font></b></td>
	</tr>


</table>

<div id="hidethis">
<br>
<img src=images/print_icon.gif width=60 height=60 onClick="window.print()">

<br><br>
<a href="index.php">Back to Home</a>
</div>
</center>
</div>
</div>
</body>
</html>
0

Let's see here:

<?php
		$db=mysql_connect('localhost', 'root', '');

		if ($dbc=mysql_connect('localhost','root','')){
			if(!mysql_select_db('bus')){
			die ('could not select the database because:'.mysql_error());
			}
		}
		else {
			die ('could not select the database because:'.mysql_error());
		}

		$res=mysql_query("SELECT * FROM customer WHERE ReservationID='{$_REQUEST['ReservationID']}'", $db);


		$Name = "";

		while($row = mysql_fetch_array($res) )
		{
			$ReservationID=$row['ReservationID'];
			$TempID=$row['IDTemp'];
			$ages .= $row['Age'] . ",";
			$names .= $row['Name'] . ",";
			$contacts .= $row['Contact'] . ","; 
			$Address=$row['Address'];
			$Age=$row['Age'];
			$Contact=$row['Contact'];
			$Email=$row['Email'];
			$DateReserved=$row['DateReserved'];
			$Company=$row['Company'];
			$BusNo=$row['BusNo'];
			$Busfrom=$row['Busfrom'];
			$Busto=$row['Busto'];
			$DepDate=$row['DepDate'];
			$ArrDate=$row['ArrDate'];
			$Seats=$row['Seats'];
			$NoSeats=$row['NoSeats'];
			$Price=$row['Price'];
			$Total=$row['Total'];
			$TimeDest=$row['TimeDest'];
			$TimeADest=$row['TimeADest'];
			$BusType=$row['BusType'];
		}
$mycontent = <<<EOD
?>
<html>
<head>
<link href="style/ticket_style.css" rel="stylesheet" type="text/css" media="print">
<title>Buckle Up - Online Reservation System</title>
</head>
<body>
<div id="templatemo_content_wrapper">
<div id="templatemo_content">

<center>

<table border="1" width="800">
	<tr>
		<td rowspan="3" align=center>
			<img src="images/grayscale.jpg" width="179" height="97">
			<img src="images/grayscale1.jpg" width="320" height="60">
		</td>
		<td align=center bgcolor=#FFFFFF><b><font size="2" face="arial">Reservation No.</font></b></td>
		
	</tr>
	<tr align=center>
		<td height="27"><font face="arial" size="2"><?php echo $ReservationID;?></font></td>
		
	</tr>

	<tr align="center">
		<td bgcolor=#FFFFFF><b><font size="2" face="arial">Date & Time Issued</font></b></td>
	</tr>
	<tr align="center">
		<td ><font size="2" face="arial"> J.P. Rizal Ext. West Rembo, Makati City</font></td>
		<td><font size="2" face="arial">
			<?php
			date_default_timezone_set('Asia/Manila');
			echo $DateReserved; echo "<br>"; print date("h:i A");
			?>

			</font></td>
	</tr>
</table>
	<font face="arial">
<table border="1" width="800">
	<tr>
		<td colspan="4" bgcolor="#FFFFFF"><font size="3"><b>PASSENGER DETAILS</b></font></td>
	</tr>
	<tr>
		<td><font size="2">Name</font></td>
		<td colspan="3"><font size="2"><?php echo $names;?></font></td>
	</tr>
	<tr>
		<td><font size="2">Address</font></td>
		<td width="65%" colspan="3"><font size="2"><?php echo $Address;?></font></td>
	</tr>
	<tr>
		<td width="31%"><font size="2">Age</font></td>
		<td width="28%"><font size="2"><?php echo $ages;?></font></td>
		<td width="20%"><font size="2">Contact No.</font></td>
		<td width="35%"><font size="2"><?php echo $contacts;?></font></td>

	</tr>
	<tr>
		<td width="15%" ><font size="2">Email</font></td>
		<td width="22%" colspan=4><font size="2"><?php echo $Email;?></font></td>
	</tr>
</table>

<table border="1" width="800">
	<tr>
		<td colspan="6" bgcolor="#FFFFFF"><b><font size="3">TRIP DETAILS</font></b></td>
	</tr>
	<tr>
		<td width="20%"><font size="2">Bus Company</font></td>
		<td colspan="5"><font size="2"><?php echo $Company ?></font></td>
	</tr>
	<tr>
		<td width="20%"><font size="2">Bus Type</font></td>
		<td colspan="5"><font size="2"><?php echo $BusType;?></font></td>
	</tr>
	<tr>
		<td width="20%"><font size="2">Bus No.</font></td>
		<td colspan="5"><font size="2"><?php echo $BusNo;?></font></td>
	</tr>
	<tr>
		<td height="24" width="20%"><font size="2">Seat No(s)</font></td>
		<td height="24" colspan="5"><font size="2"><?php echo $Seats;?></font></td>
	</tr>
	<tr>
		<td colspan="3" bgcolor="#FFFFFF"> <font size="2"><b>Departure</b></font></td>
		<td colspan="3" bgcolor="#FFFFFF"><font size="2"><b>Arrival</b></font></td>
	</tr>
	<tr>
		<td width="20%"><font size="2">From</font></td>
		<td width="16%"><font size="2">Date</font></td>
		<td width="13%"><font size="2">ETD</font></td>
		<td width="18%"><font size="2">To</font></td>
		<td width="15%"><font size="2">Date</font></td>
		<td width="13%"><font size="2">ETA</font></td>
	</tr>
	<tr>
		<td width="20%"><font size="2"><?php echo $Busfrom;?></font></td>
		<td width="16%"><font size="2"><?php echo $DepDate;?></font></td>
		<td width="13%"><font size="2"><?php echo $TimeDest;?></font></td>
		<td width="18%"><font size="2"><?php echo $Busto;?></font></td>
		<td width="15%"><font size="2"><?php echo $ArrDate;?></font></td>
		<td width="13%"><font size="2"><?php echo $TimeDest;?></font></td>
	</tr>
</table>

<table border=1 width=800>
	<tr>
		<td width="51%"><font size="2">No. of Seats Reserved</font></td>
		<td><font size="2"><?php echo $NoSeats;?></td>
	</tr>
	<tr>
		<td width="51%"><font size="2">Price per Seat</font></td>
		<td><font size="2"><?php echo $Price;?></td>
	</tr>
	<tr>
		<td width="51%"><font size="2">Reservation Fee</font></td>
		<td><font size="2"><?php echo $_REQUEST['fee'];?></td>
	</tr>
	<tr>
		<td width="20%"><font size="2">Total</font></td>
		<td><font size="2"><?php echo $Total;?></td>
	</tr>
</table>
<br>
<table border=1 width=800>
	<tr>
		<td colspan="6" bgcolor="#FFFFFF"><b><font size="3">Note</font></b></td>
	</tr>
	<tr>
		<td colspan="6" width="51%"><font size="2">Kindly present the printed ticket to Bayad Center for the payment.</font></td>

	</tr>
	<tr>
		<td colspan="6" height=30><font size="2">Upon payment, please bring a valid ID.</font></td>
	</tr>

</table><br>
<table border=1 width=800>
	<tr>
		<td colspan="6" bgcolor=#FFFFFF><b><font size="3">Bayad Center Print Validation</font></b></td>
	</tr>
	<tr>
		<td colspan="6" height="100"><b><font size="3"></font></b></td>
	</tr>


</table>

<div id="hidethis">
<br>
<img src=images/print_icon.gif width=60 height=60 onClick="window.print()">

<br><br>
<a href="index.php">Back to Home</a>
</div>
</center>
</div>
</div>
</body>
</html>
<?php
EOD;

$to = $row['Email'];
$subject = "Your reservation.";
$headers = 'From: your.email@this.spot' . "\r\n" .
   'Reply-To: your.email@this.spot' . "\r\n" .
   'X-Mailer: PHP/' . phpversion();

mail($to, $subject, $mycontent, $headers);

Remember that you will need to make ALL of your links literal, even to images and stylesheets, like:

<link href="http://www.yoursite.com/style/ticket_style.css" rel="stylesheet" type="text/css" media="print">

not

<link href="style/ticket_style.css" rel="stylesheet" type="text/css" media="print">

My 2¢. Hope this helps.

0

I've tried youre code.. but its not working..

i've change your $to = $row;

to $to = $Email;


Its not sending emails..

also, i've turned on mercury

tnx

how can i send money to you..

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.