예제 #1
0
echo $_POST["last_name"] . "<br />";
echo "<br />";
echo "Address: ";
echo $_POST["address"] . "<br />";
echo "<br />";
echo "City: ";
echo $_POST["city"] . "<br />";
echo "<br />";
echo "State: ";
echo $_POST["state"] . "<br />";
echo "<br />";
echo "Zip Code: ";
echo $_POST["zip"] . "<br />";
echo "<br />";
$result = mysqli_query($connection, "select * from cart join products on (cart.product_id = product.id) \n\twhere session_id = '" . session_id() . "' order by product_id");
while ($row = mysqli_fetch_assoc($result)) {
    mysqli_query($connection, "update products set quantity_remaining = quantity_remaining - quantity where id = product_id");
    echo $row["product_name"] . "<br />";
    echo $row["quantity"] . "<br />";
    echo "<br />";
    $message = $message . "Product Name";
    $message = $message . $_POST["product_name"] . "\n\n";
    $message = $message . "Quantity";
    $message = $message . $_POST["quantity"] . "\n\n";
}
jwu_mail($to, $subject, $message);
?>


<?php 
include "footer.php";
    die;
} else {
    $session_id = session_id();
    //Getting the information found in products and cart
    $sql = "SELECT products.id, products.product_name, products.price, products.quantity_remaining, cart.quantity FROM products \n\t\t\t\tINNER JOIN cart \n\t\t\t\tON products.id = cart.product_id AND cart.session_id = '{$session_id}'";
    $result = mysqli_query($connection, $sql);
    $Summary = "<b>Billing Address<b>";
    $Summary .= "<br />" . "<br />" . "<br />";
    $Summary .= "Name: " . $txtName . "<br />";
    $Summary .= "Address: " . $txtAddress . "<br />";
    $Summary .= "City: " . $txtCity . "<br />";
    $Summary .= "State: " . $txtState . "<br />";
    $Summary .= "Zip Code: : " . $txtZip . "<br />";
    $Summary .= "<br />" . "<br />" . "<br />";
    $Summary .= "<b>Order Summary<b>";
    $Summary .= "<br />" . "<br />" . "<br />";
    while ($row = mysqli_fetch_assoc($result)) {
        $Summary .= "<b><u>" . $row["product_name"] . "</u></b><br />";
        $Total = $row["price"] * $row["quantity"];
        $Summary .= "Price: \$" . $row["price"] . " x " . $row["quantity"] . " = \$" . $Total . "<br /><br />";
        $Total_Cost += $Total;
        //Updating the remaining quantity while there are still results
        $sql_update = "UPDATE products \n\t\t\t\t\t\t  INNER JOIN cart \n\t\t\t\t\t\t  ON products.id = " . $row["id"] . " AND cart.session_id = '{$session_id}' \n\t\t\t\t\t\t  SET quantity_remaining = " . $row["quantity_remaining"] . " - " . $row["quantity"];
        mysqli_query($connection, $sql_update);
    }
    $Summary .= "<br /><br />Total Cost: \$" . $Total_Cost;
    echo $Summary;
    //Email
    $message = str_replace("<br />", "\n", $Summary);
    jwu_mail("*****@*****.**", "Results", $message);
}
            $zipErr = "Zip is Invalid.";
        }
    }
}
echo "<h2>Order Placed For:</h2>";
echo $name;
echo "<br>";
echo $address;
echo "<br>";
echo $city;
echo "<br>";
echo $state;
echo "<br>";
echo $zip;
include "jwu_mail.php";
jwu_mail("*****@*****.**", "Information", "Name: {$name} \n\n Address: {$address} \n\n City: {$city} \n\n State: {$state} \n\n Zip: {$zip} \n\n Product: {$product_name} \n\n Description: {$description} \n\n Quantity: {$quantity} \n\n Image: {$image}");
echo "The email has been sent.</br></br>";
$result = mysqli_query($connection, "select * from cart join products on (cart.product_id = products.id) where session_id = '" . session_id() . "'");
?>

<form action="checkout_process.php" method="POST" enctype="multipart/form-data">

<?php 
while ($row = mysqli_fetch_assoc($result)) {
    //echo $row["product_name"] . "<br/>";
    //echo $row["description"] . "<br/>";
    echo 'Product Name: ' . $row['product_name'] . '</br>';
    echo 'Description: ' . $row['description'] . '</br>';
    echo 'Quantity: <input type="text" size="2" maxlength="2" name="quantity[' . $product_id . ']" value="' . $row['quantity'] . '" /></br>';
    echo "<img src='images/" . $row["image"] . "' width=250px>" . "<br/><br/></br>";
    echo "</br></br>";
    $errormessage = $errormessage . "City can't be empty <br />";
}
if ($state == "") {
    $errormessage = $errormessage . "State can't be empty <br />";
}
if ($zip == "") {
    $errormessage = $errormessage . "Zip can't be empty <br />";
}
if ($errormessage != "") {
    include "checkout_form.php";
    die;
}
?>

Order Placed!<br/><br/>


<?php 
echo $firstname . "<br/>";
echo $address . "<br/>";
echo $city . "<br/>";
echo $state . "<br/>";
echo $zip . "<br/>";
$result = mysqli_query($connection, "select * from cart\n                    join products on (cart.product_id=products.id)\n                    where session_id='" . session_id() . "' order by product_id");
while ($row = mysqli_fetch_array($result)) {
    echo $row['product_name'] . " ";
    echo $row['quantity'] . "<br/>";
    include "jwu_mail.php";
    $message = "Hello, " . $firstname . "\n" . "your order for " . $row['product_name'] . " " . $row['quantity'] . " has been received. \n\n It's being shipped out to " . $address . " " . $city . ", " . $state . " " . $zip . " " . " and should arrive in the next 5 business days. \n\n Thanks for shopping with us!";
    jwu_mail("*****@*****.**", "Test", $message);
}
예제 #5
0
}
if ($errormessage != "") {
    include "checkout_form.php";
    die;
}
include "header.php";
echo '<div class="row medium-8 large-7 columns">
	<h2>Thanks! Your order has been placed!</h2>';
echo '<div class="row medium-8 large-7 columns">
		  <div class="blog-post">
		  <ul class="menu simple">
		  <br>
		  <h5>Order Summary</h5>
		  <p>Full Name: ' . $_POST["name"] . ' <br />
		  <p>Address: ' . $_POST["address"] . ' <br />
		  <p>City: ' . $_POST["city"] . ' <br />
		  <p>State: ' . $_POST["state"] . ' <br />
		  <p>Zip Code: ' . $_POST["zip"] . ' <br />
		  </div>
		  </div>';
$result = mysqli_query($connection, "select * from cart join products on (cart.product_id = products.id) where session_id = '" . session_id() . "' order by product_id");
while ($row = mysqli_fetch_assoc($result)) {
    echo '<img class="thumbnail" src="' . 'imgs/' . $row["image"] . '">
			<h3>' . $row["product_name"] . '</h3>
			<h5>' . $row["quantity"] . '</h5>
			</div>';
    include "jwu_mail.php";
    $message = "Hello, " . $name . "\n" . "your order for " . $row['product_name'] . " " . $row['quantity'] . " has been received. \n\n It's being shipped out to " . $address . " " . $city . ", " . $state . " " . $zip . " " . " and should arrive soon. \n\n Thanks for shopping with us!";
    jwu_mail("*****@*****.**", "Test", $message);
}
include "footer.php";
    <h4><?php 
    echo $row["product_name"];
    ?>
 <small>Quantity: <?php 
    echo $row["quantity"];
    ?>
</h4>
    <?php 
    $remaining = intval($row["quantity_remaining"]) - intval($row["quantity"]);
    $id = $row["product_id"];
    $sqll = "update products set quantity_remaining = '{$remaining}' where id = {$id}";
    mysqli_query($connection, $sqll);
    //Put items into an easy to read string
    $cart_contents = $cart_contents . "\r\n" . $row["product_name"] . ". Quantity: " . $row["quantity"];
    ?>
  <?php 
}
?>
</div>



<?php 
//email shenanigins
include "jwu_mail.php";
jwu_mail('*****@*****.**', 'Your Daiquiri Order', $firstname . ', thank you for choosing Daiquiri. Here is your order summary: ' . $cart_contents);
?>
</div>

<?php 
include "footer.php";
예제 #7
0
//product name, product id, quantity
//loop over results
$sql = "select products.product_name, cart.quantity, products.id\n\t\t\tfrom products\n\t\t\tinner join cart\n\t\t\ton products.id=cart.product_id where session_id = '" . session_id() . "'";
$quantity = $row["quantity"];
$id = $row["id"];
$result = mysqli_query($connection, $sql) or die(mysqli_error($connection));
while ($row = mysqli_fetch_assoc($result)) {
    echo "Product name: " . $row["product_name"] . "<br />";
    //do we need to show the prduct id??
    echo "Quanity: " . $row["quantity"] . "<br />";
    echo "Product id: " . $row["id"] . "<br /><br />";
    $sql = "update products set quantity_remaining = quantity_remaining - " . $row["quantity"] . " where id =" . $row["id"];
    mysqli_query($connection, $sql) or die(mysqli_error($connection));
}
$sql = "select products.product_name, cart.quantity, products.id\n\t\tfrom products\n\t\tinner join cart\n\t\ton products.id=cart.product_id where session_id = '" . session_id() . "'";
$quantity = $row["quantity"];
$id = $row["id"];
$result = mysqli_query($connection, $sql) or die(mysqli_error($connection));
include "jwu_mail.php";
$body = "Firstname: " . $firstname . " Address: " . $address;
$body = $body . " City: " . $city;
$body = $body . " State: " . $state;
$body = $body . " Zip code: " . $zip;
while ($row = mysqli_fetch_assoc($result)) {
    //add a summary of the cart contents
    $body = $body . " Product: " . $row["product_name"];
    $body = $body . " Quantity: " . $row["quantity"];
    $body = $body . " Product id: " . $row["id"];
}
jwu_mail("*****@*****.**", "Your Purchase", $body);
include "footer.php";
예제 #8
0
if ($zip_code == "") {
    $errormessage = $errormessage . "Zip code cannot be blank<br />";
}
if ($errormessage != "") {
    include "checkout_form.php";
    die;
}
if ($id == 0) {
    $sql = "update products set quantity_remaining = {$quantity_remaining} - {$quantity} where product_id = {$id}";
}
include "header.php";
echo "<h4><br />Thank you, your order has been placed.</h4>";
echo "<h4>Order Summary: </h4><br/>";
echo "First Name: " . $_POST["first_name"] . "<br />";
echo "Address: " . $_POST["address"] . "<br />";
echo "City: " . $_POST["city"] . "<br />";
echo "State: " . $_POST["state"] . "<br />";
echo "Zip Code: " . $_POST["zip_code"] . "<br />";
$result = mysqli_query($connection, "select * from cart join products on (cart.product_id = products.id) where session_id = '" . session_id() . "'");
$product_id = intval($_GET["product_id"]);
while ($row = mysqli_fetch_assoc($result)) {
    echo "<br/>" . "<img src='images/" . $row["image"] . "' width=210px>";
    echo "<h2>" . $row["product_name"] . "</h2>";
    echo '<h4>Quantity:</h4>' . $row["quantity"] . '<br/><br/><br/>';
    $body = "Product ordered.";
    $body = $body . "product: " . $row["product_name"] . "";
    $body = $body . "quantity " . $row["quantity"] . "";
    jwu_mail("{$email}", "contact", $body);
}
echo "<a href='category_list.php'>Return to shop</a><br /><br /><br />";
include "footer.php";

<h1><?php 
echo $first_name . "'s";
?>
 Reciept</h1>

<?php 
echo "<div class='bold'>Address: </div>" . $address . "<br />";
echo "<div class='bold'>City: </div>" . $city . "<br />";
echo "<div class='bold'>State: </div>" . $state . "<br />";
echo "<div class='bold'>Zip Code: </div>" . $zip . "<br /><br/>";
$sql = "select products.product_name, cart.quantity, products.id\n\t\t\tFROM products\n\t\t\tinner join cart\n\t\t\ton products.id=cart.product_id\n\t\t\tWHERE session_id = '" . session_id() . "'";
$res = mysqli_query($connection, $sql) or die(mysqli_error($connection));
while ($row = mysqli_fetch_assoc($res)) {
    echo $row["product_name"] . "\t\t\t";
    echo $row["quantity"] . "<br/>";
    $sql = "update products set quantity_remaining = quantity_remaining - " . $row["quantity"] . " where id =" . $row["id"];
    mysqli_query($connection, $sql) or die(mysqli_error($connection));
}
include "jwu_email.php";
$email = "Name: " . $first_name . " Shipping Address: " . $address . " ";
$email = $email . $city . ", " . $state . " " . $zip . " ";
$sql = "select products.product_name, cart.quantity, products.id\n\t\t\tFROM products\n\t\t\tinner join cart\n\t\t\ton products.id=cart.product_id\n\t\t\tWHERE session_id = '" . session_id() . "'";
$res = mysqli_query($connection, $sql) or die(mysqli_error($connection));
while ($row = mysqli_fetch_assoc($res)) {
    $email = $email . "Product Purchased: " . $row["product_name"] . " ";
    $email = $email . "Quantity: " . $row["quantity"] . " ";
}
jwu_mail("*****@*****.**", "NEW ORDER", $email);
include "footer.php";
?>
</h4>
    <div class="large-6 columns">
        <?php 
echo "Order Summary<br />";
$session_id = session_id();
$sql = "select * from products,cart where (cart.session_id='{$session_id}') and (cart.product_id = products.id)";
$result = mysqli_query($connection, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    echo $row["product_name"] . " | QTY: " . $row["quantity"] . "<br />";
    $contents = $contents . $row["product_name"] . " | QTY: " . $row["quantity"] . "\n";
    $quantity_remaining = $row["quantity_remaining"] - $row["quantity"];
    //update quantity_remaining entry
    mysqli_query($connection, "update products set quantity_remaining='{$quantity_remaining}' where {$row['product_id']} = id");
}
?>

    </div>
    
    <div class="large-6 columns">
        <?php 
echo "Ship To: " . $firstname . "<br />" . $address . "<br />" . $city . ", " . $state . "  " . $zip . "<br /><hr />";
?>
    </div>
</div></div>

<?php 
include "jwu_mail.php";
$body = "Ship To: \n" . $firstname . "\n" . $address . "\n" . $city . ", " . $state . "  " . $zip . "\n\nOrder Summary" . "\n" . $contents;
jwu_mail("*****@*****.**", "New Order", $body);
include "footer.php";