#$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'];