bookings.php : ================================ edit_transport_booking.php $value) {} { echo "$i $recepient $value $recepient[$i] "; $mime_boundary = "----EF Malta----".md5(time()); # -=-=-=- MAIL HEADERS $to = $recepient[$i]; $subject = "Edited Transport Booking from EF"; $headers = "From: Beach Club \n"; $headers .= "Reply-To: Jeff Galea \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 .= "Editing 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 ); } // SQL INSERT QUERY $updatequery = "UPDATE transport SET groupno='$groupno', leadername='$leadername', leadermobile='$leadermobile', "; $updatequery .= "depdate='$depdate', deppoint='$deppoint', typeoftransport='$typeoftransport', pax='$pax', "; $updatequery .= "leaders='$leaders', activitytype='$activitytype', typeofpayment='$typeofpayment', destination='$destination', "; $updatequery .= "rettime='$rettime', returnfrom='$returnfrom', returnto='$returnto', updated='$updated', updatedby='$updatedby', active='$active'"; $updatequery .= "WHERE vid = '$vid'"; echo "\n\n\n$updatequery\n\n\n"; mysql_query($updatequery) or die('Error, query failed With this error : ' . mysql_error()); //outputting confirmation display_confirmation(); } if (($_POST['delete'] == 'ON')) { createconfirm("form11"); $deletequery = "UPDATE transport SET updated='$updated', updatedby='$updatedby', active = '0' WHERE vid = '$vid'"; mysql_query($deletequery) or die('Error, query failed With this error : ' . mysql_error()); $manageremail = "matthew@solutions-lab.net" ; $supplieremail = "yancho@mepa-clan.info"; $recepient[0] = $manageremail; $recepient[1] = $supplieremail; foreach ($recepient AS $i => $value) {} { echo "$i $recepient $value $recepient[$i] "; $mime_boundary = "----EF Malta----".md5(time()); # -=-=-=- MAIL HEADERS $to = $recepient[$i]; $subject = "Booking Removed from EF"; $headers = "From: Beach Club \n"; $headers .= "Reply-To: Jeff Galea \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 .= "Delete 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 .= "\n\n"; $message .= "Booking deleted 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("The Receipt you selected has been set to INACTIVE"); } } // End the part where data has already been edited //Displaying the 'old' data else { if (!isset($_SESSION['search'])) { display_transport(); //displaying the search form $_SESSION['search'] = "true"; } if ($_SESSION['search'] == "true") { //searching the database after reading the form $grooupno = $_POST['gr0upno']; $day = $_POST['d4y']; $month = $_POST['m0nth']; $year = $_POST['y34r']; $deppdate = $year."-".$month."-".$day; $query22 = "SELECT vid, groupno, leadername, leadermobile, depdate, deptime, deppoint, typeoftransport, "; $query22 .= "pax, leaders, activitytype, typeofpayment, destination, rettime, returnfrom, returnto, updated, "; $query22 .= "updatedby, active FROM transport WHERE groupno='$grooupno' AND depdate = '$deppdate' AND active='1'"; $result22 = mysql_query($query22); if (!$result22) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query22; die($message); } while ($row = mysql_fetch_assoc($result22)) { $vid = $row['vid']; $groupno = $row['groupno']; $leadername = $row['leadername']; $leadermobile = $row['leadermobile']; $depdate = $row['depdate']; list($year,$month,$day) = explode('-',$depdate); $deptime = $row['deptime']; list($hour,$min,$sec) = explode(':',$deptime); $deppoint = $row['deppoint']; $typeoftransport = $row['typeoftransport']; $pax = $row['pax']; $leaders = $row['leaders']; $activitytype = $row['activitytype']; $typeofpayment = $row['typeofpayment']; $destination = $row['destination']; $rettime = $row['rettime']; list($hr,$min,$sec) = explode(':',$deptime); $returnfrom = $row['returnfrom']; $returnto = $row['returnto']; } redraw_transport(); } } ?> ===================== a function in menu_html.php function display_transport(){ ?>
 

 

">

Search Booking

 
  Group Number :
  Date of Activity : / /