Updating data in mysql
So, at one end of the system you have a visitor to your site who uses a web browser to request a page, and expects to receive a standard HTML document in return.
At the other end you have the content of your site, which sits in one or more tables in a My SQL database that understands only how to respond to SQL queries (commands).
For more information, see Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”.
My SQL converts .) By default, the current time zone for each connection is the server's time.
It’s important to understand how these will fit together.
The whole idea of a database driven web site is to allow the content of the site to reside in a database, and for that content to be pulled from the database dynamically to create web pages for people to view with a regular web browser.
We have two powerful tools at our disposal: the PHP scripting language and the My SQL database engine.
For many people, the main reson for learning a scripting language like PHP is because of the interaction with databases it can offer.