Advertisement
fursty

Koko's artic

Apr 29th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. <?php
  2. include 'config.php';
  3. $query = "SELECT ime FROM articles";
  4. $result = mysql_query($query) or die(mysql_error()."[".$query."]");
  5. ?>
  6. <form method="post" action="">
  7. Продукт <select name="ime">
  8. <?php
  9. while ($row = mysql_fetch_array($result))
  10. {
  11. echo "<option value=".$row['ime'].">".$row['ime']."</option>";
  12. }
  13. ?>
  14. </select> <br />
  15. Брой <input type="number" name="broi" min="1" max="10"/> <br />
  16. <input type="submit" name="submit" value="Поръчай" />
  17. </form>
  18. <a href="store.php">Добави продукт</a>
  19. <a href="dostavka.php">Достави</a><br />
  20. <?php
  21. if(isset($_POST['submit'])){
  22. $ime = $_POST['ime'];
  23. $broi = $_POST['broi'];
  24. $result = mysql_query("SELECT * FROM articles WHERE ime = '$ime'");
  25. $row = mysql_fetch_assoc($result);
  26. if($row['broi'] >= $broi) {
  27. $a = $row['broi'] - $broi;
  28. $sql = "UPDATE articles SET broi = '$a' WHERE ime = '$ime'";
  29. mysql_query($sql);
  30. $res = mysql_query("SELECT * FROM articles");
  31. while($row=mysql_fetch_array($res))
  32. {
  33. echo " Продукт: ".$row['ime']." Цена: ".$row['cena']." Брой: ".$row['broi']."<br>";
  34. }
  35. }
  36. else
  37. echo "Няма достатъчно бройки";
  38. }
  39. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement