From 04f53e2d62a402661dcc2ef4aa635c352c0a134d Mon Sep 17 00:00:00 2001
From: arf20 <aruizfernandez05@gmail.com>
Date: Tue, 19 Mar 2024 05:03:32 +0100
Subject: Index, and client comments

---
 index.php | 19 ++++++++++++++++++-
 1 file changed, 18 insertions(+), 1 deletion(-)

(limited to 'index.php')
diff --git a/index.php b/index.php
index db7b080..83de5b5 100644
--- a/index.php
+++ b/index.php
@@ -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>
-- 
cgit v1.2.3

