Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include 'config.php';
- $query = "SELECT ime FROM articles";
- $result = mysql_query($query) or die(mysql_error()."[".$query."]");
- ?>
- <form method="post" action="">
- Продукт <select name="ime">
- <?php
- while ($row = mysql_fetch_array($result))
- {
- echo "<option value=".$row['ime'].">".$row['ime']."</option>";
- }
- ?>
- </select> <br />
- Брой <input type="number" name="broi" min="1" max="10"/> <br />
- <input type="submit" name="submit" value="Поръчай" />
- </form>
- <a href="store.php">Добави продукт</a>
- <a href="dostavka.php">Достави</a><br />
- <?php
- if(isset($_POST['submit'])){
- $ime = $_POST['ime'];
- $broi = $_POST['broi'];
- $result = mysql_query("SELECT * FROM articles WHERE ime = '$ime'");
- $row = mysql_fetch_assoc($result);
- if($row['broi'] >= $broi) {
- $a = $row['broi'] - $broi;
- $sql = "UPDATE articles SET broi = '$a' WHERE ime = '$ime'";
- mysql_query($sql);
- $res = mysql_query("SELECT * FROM articles");
- while($row=mysql_fetch_array($res))
- {
- echo " Продукт: ".$row['ime']." Цена: ".$row['cena']." Брой: ".$row['broi']."<br>";
- }
- }
- else
- echo "Няма достатъчно бройки";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement