From c9cab084b9d8679f31a80d74d19a8bb91c810c8a Mon Sep 17 00:00:00 2001
From: bochard <git@bochard.net>
Date: Mon, 22 Dec 2025 10:57:57 +0800
Subject: [PATCH] new layout for guestbook entries

---
 guestbook.php | 47 +++++++++++++++++++++++++----------------------
 1 file changed, 25 insertions(+), 22 deletions(-)

diff --git a/guestbook.php b/guestbook.php
index 39c7f5b..6ddd1e5 100644
--- a/guestbook.php
+++ b/guestbook.php
@@ -76,29 +76,32 @@
 					<br><br>
 					
 					<center><h2>Entries</h2></center>
-					<table border="1" cellspacing="" width="600">
-						<tr>
-							<th>Name</th>
-							<th>Country</th>
-							<th>Web site</th>
-							<th>Comment</th>
-						</tr>
-					<?php
-						if($result && $result->num_rows > 0){
-							while($row = $result->fetch_assoc()){
-								echo "<tr>";
-									echo "<td>" . htmlspecialchars($row['name']) . "</td>";
-									echo "<td>" . htmlspecialchars($row['country']) . "</td>";
-									if(!empty($row['website'])){
-										echo "<td><a href='" . htmlspecialchars($row['website']) . "' target='_blank'>" . htmlspecialchars($row['website']) . "</a></td>";
-									} else{
-										echo "<td></td>";
+					<table cellspacing="7" cellpadding="3" width="500" bgcolor="#0087fc">
+							<?php
+								if($result && $result->num_rows > 0){
+									while($row = $result->fetch_assoc()){
+										$name = htmlspecialchars($row['name'] ?? '');
+										$country = htmlspecialchars($row['country'] ?? '');
+										$website = htmlspecialchars($row['website'] ?? '');
+										$email = htmlspecialchars($row['email'] ?? '');
+										$comment = htmlspecialchars($row['comment'] ?? '');
+										$written_at = $row['written_at'] ?? '';
+										$ip_addr = $row['ip_addr'] ?? '';
+										
+										echo "<tr>";
+											echo "<td>";
+												echo "By <b>$name</b> at <b>$written_at</b><br>";
+												echo "Country: <b>$country</b><br>";
+												echo "Website: <b><a href='$website'>$website</a></b><br>";
+												echo "Message: <b>$comment</b>";
+												echo "<hr>";
+											echo "</td>";
+										echo "</tr>";
 									}
-									echo "<td>" . htmlspecialchars($row['comment']) . "</td>";
-								echo "</tr>";
-							}
-						}
-					?>
+								} else{
+									echo "<tr><td>No entries yet.</td></tr>";
+								}
+							?>
 					</table>
 					
 					<br><br>
-- 
2.39.5