function PHPTutorials() { //echo$ip=getIp(); echo "\n<div class='container_fluid'>\n<center><table width='800'>\n <tr>"; openDB(); $getPro_id = mysql_query("select * from products where product_link='php.php'"); $split = 0; while ($row_pro = mysql_fetch_array($getPro_id)) { $prod_id = $row_pro['product_id']; $prod_title = $row_pro['product_title']; $prod_price = $row_pro['product_price']; $prod_image = $row_pro['product_image']; $pro_desc = $row_pro['product_desc']; $split++; echo "\n\t\t\t\t\t\t<td width='400' style='padding:5px;'><h3>{$prod_title}</h3>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<a href='../pages/details2.php?pro_id={$prod_id}'>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<image src='../Images/{$prod_image}' width='200' height='100'></image></a>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<h4><strong>Price: \$ {$prod_price}</strong></h4>\n\t\t\t\t\t\t<br><br><h4>Description:</h4><br>{$pro_desc}<br><br>\n\t\t\t\t\t\t<a href='../pages/details2.php?pro_id={$prod_id}'>Details</a>\n\t\t\t\t\t\t<a href='http://www.smcleodtech.com.au/index.php?add_cart={$prod_id}'>\n\t\t\t\t\t\t<button>Add to Cart</button></a></td>"; if ($split % 3 == 0) { echo "\n\t\t\t\t\t\t</tr><tr>"; } } cart(); closeDB(); echo "</tr><br>\n </table></center>\n </div>"; }
$query = "SELECT order_id FROM orders WHERE user_id = '{$userID}' and product_id = '{$productID}'"; $result = mysqli_query($db, $query); if (!$result) { die('Invalid query: ' . mysqli_error($db)); } $row = mysqli_fetch_array($result, MYSQLI_ASSOC); $count = mysqli_num_rows($result); if ($count == 1) { $orderID = $row['order_id']; $query = "UPDATE orders SET qty=qty+1 WHERE order_id='{$orderID}'"; $data = mysqli_query($db, $query); if (!$data) { die('Invalid query: ' . mysqli_error($db)); } } else { $query = "INSERT INTO orders(user_id, product_id) VALUES ('{$userID}', '{$productID}')"; $data = mysqli_query($db, $query); if (!$data) { die('Invalid query: ' . mysqli_error($db)); } } } } if (!$_SESSION['login_user']) { echo "<br>You need to login first"; echo "</br></br>This page will redirect in 5 seconds"; header("refresh:5;url={$base_url}/views/home.php"); } else { cart($db); header("location: {$base_url}/views/home.php"); }
function total() { $totaal = 0; foreach (cart() as $albumId) { $totaal += searchAlbum($albumId)["price"]; } return $totaal; }
<?php require_once 'admin_carrello.php'; ?> <html> <head> <link rel="stylesheet" type="text/css" href="public/css/shop.css" media="all"> </head> <body> <div id="shop"> <a href="http://spano.sc.unica.it/amm2015/scanuAndrea/Iosonouncane/index.php">Home Page<br /><br /></a> Nel nostro Shop potrai acquistare i CD di Iosonouncane <br /> e pagarli in sicurezza tramite Paypal! <?php products(); ?> <br /> <br /> <?php cart(); ?> </div> </body> </html>
<?php include "albums.php"; /* file uit boeken.php wordt uitgelezen en als onderdeel van de huidige php file gezien*/ include "cart.php"; $theAlbum = searchAlbum($_POST["isbn"]); echo "U heeft <i>" . $theAlbum["name"] . "</i> besteld."; ?> <h3>uw winkelwagen:</h3> <table> <?php voegBoekToeAanWiWa($theAlbum["id"]); foreach (cart() as $albumId) { $album = searchAlbum($albumId); echo "<tr><td>"; echo '<img height="80" src="img/' . $album['afbeelding'] . '">'; echo "</td><td>"; echo $album["titel"]; echo "</td><td>"; echo number_format($album['prijs'] / 100, 2); echo "</td></tr>"; } echo "<tr><td></td><td>totaal:</td><td>" . number_format(totaalBedrag() / 100, 2) . "</td></tr>"; ?> </table> doei...