From 9aa727869860a2feb8a6d6c5ca3495cb38b0793c Mon Sep 17 00:00:00 2001
From: bochard <git@bochard.net>
Date: Mon, 22 Dec 2025 18:51:05 +0800
Subject: [PATCH] force timezone to PH

---
 guestbook.php | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/guestbook.php b/guestbook.php
index a5dfcb6..69d1e9f 100644
--- a/guestbook.php
+++ b/guestbook.php
@@ -28,6 +28,9 @@
 						// connect to database
 						$conn = new mysqli($host, $username, $password, $dbname);
 						
+						// force to use PH timezone
+						$conn->query("SET time_zone='+08:00';");
+						
 						// check connection
 						if($conn->connect_error){
 							die("Connection failed: {$conn->connect_error}");
@@ -89,7 +92,6 @@
 					
 					<br><br>
 					
-					<center><h2>Entries</h2></center>
 					<table cellspacing="7" cellpadding="3" width="500" bgcolor="#0087fc">
 							<?php
 								if($result && $result->num_rows > 0){
-- 
2.39.5