rendered paste body<?php
//gift certificates
if(isset($_GET['personalTo']))
{
include 'include/mysql.php';
$mysql = new sql_queries();
$mysql->do_mysql_connect();
//filter input
$personalTo = $mysql->mysql_safe($_GET['personalTo']);
$personalFrom = $mysql->mysql_safe($_GET['personalFrom']);
$personalService = $mysql->mysql_safe($_GET['personalService']);
$personalAmount = $mysql->mysql_safe($_GET['personalAmount']);
$personalGiftWrapped = $mysql->mysql_safe($_GET['personalGiftWrapped']);
$personalTotal = $mysql->mysql_safe($_GET['personalTotal']);
$pickup = $mysql->mysql_safe($_GET['pickup']);
$pickupName = $mysql->mysql_safe($_GET['pickupName']);
$pickupEmail = $mysql->mysql_safe($_GET['pickupEmail']);
$pickupPhone = $mysql->mysql_safe($_GET['pickupPhone']);
$mailtoName = $mysql->mysql_safe($_GET['mailtoName']);
$mailtoEmail = $mysql->mysql_safe($_GET['mailtoEmail']);
$mailtoPhone = $mysql->mysql_safe($_GET['mailtoPhone']);
$mailtoStreet = $mysql->mysql_safe($_GET['mailtoStreet']);
$mailtoCity = $mysql->mysql_safe($_GET['mailtoCity']);
$mailtoState = $mysql->mysql_safe($_GET['mailtoState']);
$mailtoZip = $mysql->mysql_safe($_GET['mailtoZip']);
$billtoStreet = $mysql->mysql_safe($_GET['billtoStreet']);
$billtoCity = $mysql->mysql_safe($_GET['billtoCity']);
$billtoState = $mysql->mysql_safe($_GET['billtoState']);
$billtoZip = $mysql->mysql_safe($_GET['billtoZip']);
if($_POST['sameAsMailing'] != "")
{
$billtoStreet = "Same as Mailing";
$billtoCity = "Same as Mailing";
$billtoState = "Same as Mailing";
$billtoZip = "Same as Mailing";
}
$sql = "INSERT INTO gift_certificates (Send_To, Send_From, Service, Amount, Gift_Wrap, Total, Pickup_Location,
Pickup_Name, Pickup_Email, Pickup_Phone, Mailto_Name, Mailto_Email, Mailto_Phone, Mailto_Street, Mailto_City,
Mailto_State, Mailto_Zip, Billing_Address, Billing_City, Billing_State, Billing_Zip) VALUES(
$personalTo, $personalFrom, $personalService, $personalAmount, $personalGiftWrapped, $personalTotal,
$pickup, $pickupName, $pickupEmail, $pickupPhone, $mailtoName, $mailtoEmail, $mailtoPhone, $mailtoStreet,
$mailtoCity, $mailtoState, $mailtoZip, $billtoStreet, $billtoCity, $billtoState, $billtoZip)";
$mysql->run_sql_query($sql);
}
require('includes/application_top.php');