diff options
-rw-r--r-- | client.php | 6 | ||||
-rw-r--r-- | index.php | 19 |
2 files changed, 21 insertions, 4 deletions
@@ -14,7 +14,7 @@ $type = $_SESSION["type"]; require_once "config.php"; // Get orders -$sql = "SELECT id, service, name, billing FROM orders WHERE client = ?"; +$sql = "SELECT id, service, name, billing, comments FROM orders WHERE client = ?"; $stmt = mysqli_prepare($link, $sql); mysqli_stmt_bind_param($stmt, "s", $param_client); $param_client = $clientid; @@ -61,10 +61,10 @@ function getservicebyid($id) { <div class="col5"> <h3>Active services</h3> <table> - <tr><th>service</th><th>instance</th><th>billing</th></tr> + <tr><th>service</th><th>instance</th><th>billing</th><th>comments</th></tr> <?php foreach ($orders as $order) { - echo "<tr><td>".getservicebyid($order["service"])["name"]."</td><td>".$order["name"]."</td><td>".$order["billing"]."</tr>\n"; + echo "<tr><td>".getservicebyid($order["service"])["name"]."</td><td>".$order["name"]."</td><td>".$order["billing"]."</td><td><pre>".$order["comments"]."</pre></td></tr>\n"; } ?> </table> @@ -1,3 +1,13 @@ +<?php +require_once "config.php"; +// Get services +$sql = "SELECT id, name, type, billing FROM services"; +$stmt = mysqli_prepare($link, $sql); +mysqli_stmt_execute($stmt); +$result = mysqli_stmt_get_result($stmt); +$services = $result->fetch_all(MYSQLI_ASSOC); +?> + <!doctype html> <html> <head> @@ -22,7 +32,14 @@ </div> <div class="col5"> <h3>Services and plans</h3> - <!-- TODO PHP list of services --> + <table> + <tr><th>name</th><th>type</th><th>billing</th></tr> + <?php + foreach ($services as $service) { + echo "<tr><td>".$service["name"]."</td><td>".$service["type"]."</td><td>".$service["billing"]."</tr>\n"; + } + ?> + </table> </div> </div> </div> |