All pastes #493198 Raw Edit

Yancho

public php v1 · immutable
·published 2007-05-17 17:18 UTC
rendered paste body
     $manageremail = "matthew@solutions-lab.net" ;     $supplieremail = "yancho@mepa-clan.info";          $recepient[0] = $manageremail;     $recepient[1] = $supplieremail;          // SQL INSERT QUERY          $insertquery = "INSERT into transport (groupno, leadername, leadermobile, depdate, deptime, deppoint, typeoftransport1, typeoftransport2, typeoftransport3, ";     $insertquery .= "pax, leaders, activitytype, typeofpayment, destination, rettime, returnfrom, returnto, updated, ";     $insertquery .= "updatedby, active) VALUES ('$groupno', '$leadername', '$leadermob', '$depdate','$deptime', '$deppoint', ";     $insertquery .= "'$typeoftransport1', '$typeoftransport2', '$typeoftransport3', '$pax', '$leaders', '$activitytype', '$typeofpayment', '$destination', ";     $insertquery .= "'$rettime', '$returnfrom', '$returnto', '$updated', '$updatedby', '$active')";     echo "\n\n\n$insertquery\n\n\n";     mysql_query($insertquery) or die('Error, query failed With this error : ' . mysql_error());               //Searching the id the voucher has been given     $selectquery = "SELECT vid from transport order by 'vid' desc limit 1";      $result = mysql_query($selectquery);         if (!$result) {           $message  = 'Invalid query: ' . mysql_error() . "\n";           $message .= 'Whole query: ' . $selectquery;           die($message);        }      $voucherid = mysql_result($result,0);      $voucherid = "TRANS-".$voucherid;               foreach ($recepient AS $i => $value) {}  {          echo "$i $recepient $value $recepient[$i]  ";          $mime_boundary = "----EF Malta----".md5(time());        # -=-=-=- MAIL HEADERS        $to = $recepient[$i];        $subject = "New Transport Booking from EF";                $headers = "From: Beach Club <beachclub@efbookings.info>\n";        $headers .= "Reply-To: Jeff Galea <jeff@efbookings.info>\n";        $headers .= "MIME-Version: 1.0\n";        $headers .= "Content-Type: multipart/alternative; boundary=\"$mime_boundary\"\n";        # -=-=-=- TEXT EMAIL PART                $message = "--$mime_boundary\n";        $message .= "Content-Type: text/plain; charset=UTF-8\n";        $message .= "Content-Transfer-Encoding: 8bit\n\n";                $message .= "New Booking:\n\n";        $message .= "Voucher Number : $voucherid\n";        $message .= "Group Number : $groupno\n";        $message .= "Leader Name : $leadername\n";        $message .= "Leader Mobile Number : $leadermob\n";        $message .= "\n\n";        $message .= "Departure Date : $gurnata : $day / $month / $year\n";        $message .= "Departure Time : $hr:$min\n";        $message .= "Type of Activity : $activitytype\n";        $message .= "Destination : $destination\n";        $message .= "Return at $hr1:$min1 from $returnfrom\n";        $message .= "Return Point : $returnto\n\n";        $message .= "\n\n";        $message .= "Number of Paying Students : $pax\n";        $message .= "Number of Free Leaders : $leaders\n";        $message .= "Type of Transport Requested : $typeoftransport\n";        $message .= "\n\n";        $message .= "Booking made by : $updatedby\n";        $message .= "Date : $updated\n";        $message .= "Thank You.\n\n";                        # -=-=-=- FINAL BOUNDARY                $message .= "--$mime_boundary--\n\n";        # -=-=-=- SEND MAIL                $mail_sent = mail( $to, $subject, $message, $headers );          //outputting confirmation      display_confirmation("Success","The data you entered has been emailed to the supplier and stored in the DB");   }