diff options
Diffstat (limited to 'public')
| -rw-r--r-- | public/cart.php | 77 | ||||
| -rw-r--r-- | public/product.php | 5 |
2 files changed, 49 insertions, 33 deletions
diff --git a/public/cart.php b/public/cart.php index 34cccbb..d4dfcc6 100644 --- a/public/cart.php +++ b/public/cart.php @@ -2,24 +2,31 @@ <?php require "../lib/db.php" ?> <?php require "../lib/login.php" ?> <?php if_logged_in(false, "/login.php", true) ?> -<?php -do { +<?php do { if ($_SERVER['REQUEST_METHOD'] !== 'POST') break; + if (!$_POST['type']) break; if (!$_POST['product_id']) break; - // TODO: add product to cart - // $statement = $cursor->prepare("select id, image, price, name, description from webs.product where id = ?"); - // $statement->bind_param("i", $_GET['id']); - // if (!$statement->execute()) refuse(); - // $res = $statement->get_result(); - // if (!mysqli_num_rows($res)) refuse(); - // $product = $res->fetch_object(); - - - // if all guards passed, successful login occurred - cookie_redir($_POST['username'], $_POST['password']); -} while (false); -?> + switch($_POST['type']) { + case "delete": { + $statement = $cursor->prepare("delete from orderproduct where product = ? and `order` = cart(?)"); + $statement->bind_param("ii", $_POST['product_id'], $user_id); + $statement->execute(); + break; + } + case "add": { + // ik wou deze functie eigenlijk in een stored procedure doen maar het + // schijnt dat de knappe koppen bij mysql het geen goed idee vonden om + // gewoon 'return' toe te staan binnen de body van een stored + // procedure??? + $statement = $cursor->prepare("select add_to_cart(?, ?)"); + $statement->bind_param("ii", $_POST['product_id'], $user_id); + $statement->execute(); + $statement->get_result()/*->fetch_object()*/; + break; + } + } +} while (false); ?> <?php function item_template($item) { $image_path = $item->image ? "/img/product/$item->id-thumb.jpg" : "/img/placeholder.png"; @@ -28,8 +35,8 @@ function item_template($item) { <img src="$image_path" alt="productafbeelding"> <span class="name">$item->name</span> <label for="$item->id-count">hoeveelheid:</label> - <input type="number" value="$item->count" min="1" max="20" id="$item->id-count"> - <button id="$item->id-delete">weghalen</button> + <input type="number" value="$item->count" min="1" max="20" id="$item->id-count" disabled> + <button type="submit" value="$item->id" name="product_id">weghalen</button> <span class="price">$item->price</span> </div> EOF; @@ -45,20 +52,28 @@ EOF; <?php include 'navbar.php' ?> <div class="main limwidth"> <h2>dingen in de mand van <?php echo $username ?></h2> - <div class="products"> - <?php do { - global $username; - $statement = $cursor->prepare("select product.id, product.name, product.price, product.image, cart.count from cart join user on user.id = cart.user join product on product.id = cart.product where user.name = ?"); - $statement->bind_param("s", $username); - if (!$statement->execute()) break; - $res = $statement->get_result(); - if (!mysqli_num_rows($res)) { - echo "mandje leeg"; - break; - } - while ($product = $res->fetch_object()) item_template($product); - } while (false); ?> - </div> + <?php do { + global $username; + $statement = $cursor->prepare("select product.id, product.name, product.price, product.image, orderproduct.count from orderproduct join product on product.id = orderproduct.product where `order` = cart(?)"); + $statement->bind_param("i", $user_id); + if (!$statement->execute()) break; + $res = $statement->get_result(); + if (!mysqli_num_rows($res)) { + echo "mandje leeg"; + break; + } + echo <<<"EOF" + <form class="products" method="post"> + <input type="hidden" name="type" value="delete"> + EOF; + while ($product = $res->fetch_object()) item_template($product); + echo <<<"EOF" + </form> + <form class="product-footer" method="post" action="/order-complete.php"> + <input type="submit" value="Bestellen" class="buttonstyle filled"> + </form> + EOF; + } while (false); ?> </div> <?php include 'footer.php' ?> </body> diff --git a/public/product.php b/public/product.php index 70c511d..18cc936 100644 --- a/public/product.php +++ b/public/product.php @@ -38,8 +38,9 @@ $product = $res->fetch_object(); <span class="price"><?php echo $product->price ?></span> <p class="info"><?php echo $product->description ?></p> <form action="/cart.php" method="post"> - <input type="number" value="<?php echo $product->id ?>" hidden name="product_id"> - <input type="submit" value="Toevoegen aan winkelwagen" class="button filled"> + <input type="hidden" name="type" value="add"> + <input type="hidden" name="product_id" value="<?php echo $product->id ?>"> + <input type="submit" class="button filled" value="Toevoegen aan winkelwagen"> </form> </div> </div> |