php-mysql-example/toys.php at master · criles25/php-mysql-example · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
<?php
/**
 * Created by PhpStorm.
 * User: Charles
 * Date: 11/17/13
 * Time: 10:35 AM
 */
$toysActive = 'class="active"';
include_once 'header.php';

echo '<h1>Toys</h1><h5><div class="row">';

$query = "SELECT * FROM inventory";
$result = queryMysql($query);
while ($row = mysql_fetch_row($result)) {
    $price = $row[2];
    $discount = number_format($row[7], '2', '.', ',');
    $finalPrice = number_format(($price * $discount), '2', '.', ',');
    $percentOff = "";
    if ((1 - $discount) > 0)
        $percentOff = ((1 - $discount) * 100) . "% off";

    echo <<<EOD

        <div class="col-sm-6 col-md-4">
            <div class="thumbnail">
                <img src="$row[4]" width="150" height="150">
                <div class="caption">
                    <h4>$row[1]</h4>
                    <p>$row[3] $$finalPrice <b>$percentOff</b></p>
                    <form method="post" action="cart.php?user=$userstr">
                        <div class="input-group">
                            <span class="input-group-addon">Quantity</span>
                            <input type="number" min ='1' name='quantity' value='1' class="form-control">
                        </div>
                        <br>
                        <input type="hidden" name="toy" value="$row[0]">
                        <input type="hidden" name="toyName" value="$row[1]">
                        <input type="hidden" name="price" value="$row[2]">
                        <input type="hidden" name="discount" value="$row[7]">
                        <input type="hidden" name="weight" value="$row[6]">
                        <input type='submit' value='Add To Cart' class="btn btn-default">
                    </form>
                </div>
            </div>
        </div>

EOD;
}

echo "</div></h5>";

include_once 'footer.php';