I am new to programming and just finished designing my first site.
On my XAMPP server in my Windows, PHP writes the current time for certain actions in time columns in my database tables. They reflect my timezone.
But as I deployed to the web server hosted by Namecheap, my time columns started recording time 6 hours less than my current timezone.
I have tried to read through similar cases here on Stack Overflow but didn't find a solution. I have also tried contacting Namecheap support but that could still not solve my issue. I have also searched online through different sites, yet no solution.
How can I to get the time columns in my database on my Namecheap hosted server tables to record time based on my timezone "Africa/Lagos"?