CS631TermProject/paid.php at master · Pendon13/CS631TermProject · 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
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    <?php
$servername = "localhost";
$username = "admin";
$password = "admin";
$dbname = "woodysdb";
$conn = new mysqli($servername, $username, $password, $dbname);
$date = $_POST["date"];
$id = $_POST["id"];

$query = "UPDATE `invoice` SET date_paid = '$date' WHERE id = '$id'";
$conn->query($query);
$query = "UPDATE `invoicedetails` SET `status` = 'Paid' WHERE invoice_id = '$id'";
$conn->query($query);

$query = "SELECT * FROM `invoice` WHERE `id` = '$id'";
$invoice = $conn->query($query);
$row = $invoice->fetch_assoc();
echo "You paid $" . $row["amount"] . " on " . $row["date_paid"] . ".";
echo "We charged your credit card.";
echo "<br><a href=\"index.php\">Return</a>";

    ?>
</body>
</html>