Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include "config.php";
- $id_boat=$_GET['id_boat'];
- $price_q= mysql_query("select PRICE,PRICE_C from tb_boat where ID_BOAT=$id_boat");
- $price_h= mysql_fetch_array($price_q);
- $boat_Name=$_GET['boatName'];
- $trip_route=$_GET['tripRoute'];
- $trip_method=$_GET['tripMethod'];
- $depart_Date=$_GET['departDate'];
- $return_Date=$_GET['returnDate'];
- $adults=$_GET['Adults'];
- $children=$_GET['Children'];
- $hotel_name=$_GET['hotel'];
- $hotel_room=$_GET['room'];
- $nama_CP=$_GET['name'];
- $email2=$_GET['email'];
- $phone=$_GET['phone'];
- $special_req=$_GET['spec_req'];
- $total_p = $adults+$children;
- $a=1;
- $i=0;
- $abcd="";
- //tb_passanger + GROUP
- $Status="0";
- // Num Book
- $date_book1= explode("/", $depart_Date);
- $date_book2= explode("/", $return_Date);
- $angka="123456789";
- $count_db= mysql_query("Select COUNT(ID_BOOK) from tb_booking");
- $count_db_hs= mysql_fetch_array($count_db);
- $count=$count_db_hs[0]+1;
- $num_book= "GBT".$date_book1[0].$date_book2[0].$date_book1[2].substr(str_shuffle($angka), 0,4).$count;
- //Total Price
- $ad_price=$price_h[0]*$adults;
- $ch_price=$price_h[1]*$children;
- $total_P=$ad_price+ $ch_price;
- //date Depart & Return
- $tglDepart=$date_book1[0];
- $blnDepart=$date_book1[1];
- $thDepart=$date_book1[2];
- $date_Desave=$thDepart."-".$blnDepart."-".$tglDepart; // Tanggal Depart Save To DB
- $tglReturn=$date_book2[0];
- $blnReturn=$date_book2[1];
- $thReturn=$date_book2[2];
- $date_Resave=$thReturn."-".$blnReturn."-".$tglReturn; // Tanggal Return Save To DB
- //query save
- $query=mysql_query("SELECT GROUP_P FROM tb_passanger order by GROUP_P DESC limit 1 ");
- $hc= mysql_fetch_array($query);
- $group=$hc[0]+1;
- $id_book= mysql_query("select ID_BOOK from tb_booking order by ID_BOOK DESC limit 1 ");
- $id_book_hsl= mysql_fetch_array($id_book);
- $id_booking=$id_book_hsl[0]+1;
- for($x=1;$x<=$total_p;$x++)
- {
- $nama[$x]=$_GET['nP'.$x];
- $cek=mysql_query("Insert into tb_passanger (ID,ID_BOOK,GROUP_P,NAMA_P) values ('','$id_booking','$group','$nama[$x]')");
- $a++;
- };
- $query="insert into tb_booking (ID_BOOK,NUMBER_BOOK,GROUP_P,ID_BOAT,METHOD,ROUTE,DEPART_DATE,RETURN_DATE,ADULTS,CHILDREN,HOTEL,HOTEL_ROOM,NAME,EMAIL,PHONE,SPECIAL_REQ,CH_PRICE,AD_PRICE,TOTAL_PRICE,Status) values ('','$num_book','$group','$id_boat','$trip_method','$trip_route','$date_Desave','$date_Resave','$adults','$children','$hotel_name','$hotel_room','$nama_CP','$email2','$phone','$special_req','$ch_price','$ad_price','$total_P','$Status')";
- $save= mysql_query($query);
- $email_cek=mysql_query("select*from tb_booking order by ID_BOOK desc LIMIT 1");
- $email_cek_hasil= mysql_fetch_array($email_cek);
- echo $email_cek_hasil[2];
- $isi_email= mysql_query("SELECT
- tb_booking.NUMBER_BOOK,
- tb_boat.NAMA_BOAT,
- tb_booking.METHOD,
- tb_booking.ROUTE,
- tb_booking.DEPART_DATE,
- tb_booking.RETURN_DATE,
- tb_booking.ADULTS,
- tb_booking.CHILDREN,
- tb_booking.HOTEL,
- tb_booking.HOTEL_ROOM,
- tb_booking.PHONE,
- tb_booking.SPECIAL_REQ,
- tb_booking.TOTAL_PRICE,
- tb_booking.STATUS
- FROM tb_passanger INNER JOIN tb_booking
- ON tb_passanger.ID_BOOK=tb_booking.ID_BOOK
- INNER JOIN
- tb_boat
- ON tb_booking.ID_BOAT=tb_boat.ID_BOAT
- WHERE tb_booking.GROUP_P=$email_cek_hasil[2]");
- $isi_email_hasil= mysql_fetch_array($isi_email);
- $nama_P= mysql_query("SELECT
- tb_passanger.NAMA_P
- FROM tb_passanger INNER JOIN tb_booking
- ON tb_passanger.ID_BOOK=tb_booking.ID_BOOK
- WHERE tb_passanger.GROUP_P=$email_cek_hasil[2]");
- while($nama_P_hasil= mysql_fetch_array($nama_P))
- {
- $nama_P_hasil[0];
- }
- if($save)
- {
- /* echo "<script>alert('Thanks For Your Booking We will Confirm your booking as fast as we can , we will send you an email later.');location.href='index.php';</script>";*/
- //query untuk isi email
- date_default_timezone_set("Asia/Singapore");
- include('phpmailer/class.phpmailer.php');
- include('phpmailer/class.smtp.php');
- $mail = new PHPMailer();
- $mail->Host = "ssl://smtp.gmail.com";
- $mail->Mailer = "smtp";
- $mail->SMTPAuth = true;
- //email from
- $mail->Username = "emailtestdps@gmail.com";
- $mail->Password = "emailtest123";
- $webmaster_email= "emailtestdps@gmail.com";
- //email to
- $email = "gilibudgetcontact@gmail.com";
- $name = "Gili Budget";
- //email from
- $mail->From = $webmaster_email;
- $mail->FromName = "Gili Budget Ticket Contact System";
- $mail->AddAddress($email2,$nama_CP);
- $mail->AddReplyTo($email,"Gili Budget Ticket");
- $mail->WordWrap = 50;
- $mail->IsHTML(true);
- $mail->Subject = "Booking Confirmation";
- $mail->Body = "
- <font face='Verdana, Geneva, sans-serif' size='2'>New Booking From, <b>$email2</b></font><br><br>
- <font face='Verdana, Geneva, sans-serif' size='2'>
- Email Received On ".date("d-m-Y")." ".date("h:i:a")."
- </font>
- <br><br>
- <font face='Verdana, Geneva, sans-serif' size='2'>
- <b>The Message Is : </b> <br><br>
- <table border='1'>
- <tr>
- <td bgcolor='#D4D4D4'>Booking Number :</td>
- <td>$isi_email_hasil[0]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Passanger Name :</td>
- <td>""</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Boat Name :</td>
- <td>$isi_email_hasil[1]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Trip Method :</td>
- <td>$isi_email_hasil[2]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Trip Route :</td>
- <td>$isi_email_hasil[3]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Depart Date :</td>
- <td>$isi_email_hasil[4]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Return Date :</td>
- <td>$isi_email_hasil[5]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Adults :</td>
- <td>$isi_email_hasil[6]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Children :</td>
- <td>$isi_email_hasil[7]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Hotel Name :</td>
- <td>$isi_email_hasil[8]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Hotel Room :</td>
- <td>$isi_email_hasil[9]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Phone :</td>
- <td>$isi_email_hasil[10]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Children Price :</td>
- <td>$ch_price</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Adults Price :</td>
- <td>$ad_price</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Total Price :</td>
- <td>$isi_email_hasil[12]</td>
- </tr>
- <tr>
- <td background='#D4D4D4'>Special Requirement :</td>
- <td>$isi_email_hasil[11]</td>
- </tr>
- </table>
- </font>
- <br><br>
- <font face='Verdana, Geneva, sans-serif' size='2'>
- Thanks.
- </font>
- <br>
- <font face='Verdana, Geneva, sans-serif' size='2'>
- Gili Budget Ticket
- </font>
- <br><br><br>
- <font face='Verdana, Geneva, sans-serif' size='1' color='#FF0000'>
- NOTE:
- </font>
- <br>
- <font face='Verdana, Geneva, sans-serif' size='1'>
- This Email was send from our system , do not reply this email.
- </font>
- <br>
- <br>
- ";
- $mail->AltBody = "This is the body when user views in plain text format";
- if(!$mail->Send())
- {
- echo "Mailer Error: " . $mail->ErrorInfo;
- }
- else
- {
- /* echo "<script> alert('Message has been sent successfully');location.href='index.php';sem</script>"; */
- }
- }
- else
- {
- /*echo "<script>alert('Something Wrong With The Data , Try Again Later');location.href='index.php';</script>";*/
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement