#$result = mysqli_query($link, $query);
$query_check_for_next = "SELECT `user` FROM `machine_queue` WHERE `machine_name`='" . $machine . "' ORDER BY `time` ASC;";
$result = mysqli_query($link, $query_check_for_next);
if ($current == 1) {
$next_user = mysqli_fetch_row($result);
$next_user = mysqli_fetch_row($result);
print json_encode($next_user);
die;
if ($next_user = mysqli_fetch_array($result)) {
$next_user = $next_user[0];
$query = "UPDATE `wait_times` SET `" . $machine . "`='" . date('Y-m-d H:i:s') . "';";
$get_user_email = "SELECT `email` FROM `users` WHERE `user` = '" . $next_user . "';";
$result = mysqli_query($link, $get_user_email);
$to = mysqli_fetch_array($result)[0];
$message = "Hi " . $next_user . ", \n \t Your machine is free. It will be reserved " . "for you for 15 minutes, after which you will be placed at the end of the queue." . "\n Best,\nBowles Laundry";
$result = gmail($to, $subject, $message);
#print(json_encode("i go here"));
die;
} else {
$query = "UPDATE `wait_times` SET `" . $machine . "`='0';";
}
$result = mysqli_query($link, $query);
}
#print(json_encode(true));
function gmail($to, $subject, $message)
{
//path to PHPMailer class
require_once './phpmailer/class.phpmailer.php';
// optional, gets called from within class.phpmailer.php if not already loaded
include "./phpmailer/class.smtp.php";
$mail = new PHPMailer();
include "gmail.php";
require "config.php";
if (isset($_POST['submitN'])) {
if (filter_input(INPUT_POST, 'emailN')) {
$email = strtolower(filter_input(INPUT_POST, 'emailN'));
$newslettersql = "SELECT * FROM newsletter WHERE email = '" . $email . "';";
$newslres = mysqli_query($mysqli, $newslettersql) or die(mysqli_error($mysqli));
$numrows = mysqli_num_rows($newslres);
if ($numrows > 0) {
echo "<script>alert('Email address already being used');</script>";
} else {
$addrecsql = "INSERT INTO newsletter VALUES ('" . $email . "');";
$res = mysqli_query($mysqli, $addrecsql) or die(mysqli_error($mysqli));
$subject = "Thank you for signing up!";
$message = "<p>Hello. I am Dorothy Biagioni.Thank you for sighing for our Newsletter!</p>";
gmail($email, $subject, $message);
}
if ($res == true) {
echo "<script>alert('Thank you for signing up for the newsletter {$email}');</script>";
echo "<script>location.href = 'index.php';</script>";
} else {
echo "<script>alert('Something went wrong, please try again later');</script>";
echo "<script>location.href = 'index.php';</script>";
}
} else {
echo "<script>alert('please enter your email');</script>";
echo "<script>location.href = 'index.php';</script>";
}
} else {
echo "<script>location.href = 'index.php';</script>";
}
function random_code($length = 16)
{
$chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!@#\$%^&*()_-=+;:,.?";
$code = substr(str_shuffle($chars), 0, $length);
return $code;
}
include "gmail.php";
require "header.php";
if (isset($_SESSION['SESS_LOGGEDIN'])) {
if (isset($_POST['paypalsubmit'])) {
$email_rec = $_POST['email'];
$code = random_code(16);
$subject = "This is a gift from your friend!";
$message = "<p>This is a gift from your friend to redeem, please visit.<br>\n\t\t\tPlease go to Login/Register->Myaccount->Redeem Giftcard. Thank you.<br>\n\t\t\tIf you have any questions, Please email me back.</p><p>Redeem code: {$code}</p>";
gmail($email_rec, $subject, $message);
$upsql = "UPDATE orders SET date = now(), Paid = 1, code = '" . $code . "' WHERE id = " . $_SESSION['SESS_ORDERNUM'];
$upres = mysqli_query($mysqli, $upsql) or die(mysqli_error($mysqli));
$itemssql = "SELECT * FROM orders WHERE id = " . $_SESSION['SESS_ORDERNUM'];
unset($_SESSION['SESS_ORDERNUM']);
$itemsres = mysqli_query($mysqli, $itemssql) or die(mysqli_error($mysqli));
$row = mysqli_fetch_assoc($itemsres);
header("Location: https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=you%40youraddress.com&item_name=" . urlencode($config_sitename) . "+Order&item_number=PROD" . $row['id'] . "&amount=" . urlencode(sprintf('%.2f', $row['total'])) . "&no_note=1¤cy_code=USD&lc=US&submit.x=41&submit.y=15");
}
$total = 0;
$custsql = "SELECT id from orders WHERE Paid = 0 AND customer_id = " . $_SESSION['SESS_USERID'];
$custres = mysqli_query($mysqli, $custsql) or die(mysqli_error($mysqli));
$custnumrows = mysqli_num_rows($custres);
if ($custnumrows != 0) {
$custrow = mysqli_fetch_assoc($custres);
$itemssql = "SELECT products.*, orderitems.*, orderitems.id AS itemid FROM products, orderitems WHERE orderitems.product_id =products.id AND order_id = " . $custrow['id'];
