The Least complicated Way to Include a Day From PHP to MySQL

Typically you will be demanded to keep a date in MySQL. Both on an update of an present document, or on a clean insert of a new history. Excellent programmers are unique about the sort and quality of data that is stored in a MySQL database. Sometime you do not want the day to be produced by MySQL at the time of the insert or update. Fairly, you want the day to be designed in PHP through code execution. Though the time distinction from the day development could be well below a number of milliseconds, there is a variation. This big difference could incorporate up if numerous transactional sequences ought to transpire.

A simple option is to develop the date in PHP and then transfer that data to the question that will by run by your database server.

Under you will obtain a rapid method to generate the date price for the two types of MySQL field styles: date, and datetime.

Phase 1. Produce a area in your database that is either day or datetime.

• If the industry is of sort date, it will have this format: [Year-Month-Day].
• If the subject is of type datetime, it will have this structure: [Year-Month-Day Hour:Minute:Second]

Action 2. After you have developed the SQL to be employed in the MySQL Question, populate the date discipline with both the variable $now or $currently. Carrying out so, will match the insert or update date/time industry in PHP, to that applied in your MySQL databases.

<br /> <?php <br /> // today&#8217;s date with Year, Month, Day<br /> <br /> $today = date(&#8220;Y-m-d&#8221;)<br /> <br /> // today&#8217;s date plus hours, minutes, seconds<br /> <br /> $now = date(&#8220;Y-m-d H:i:s&#8221;)<br /> <br /> $myDatabase = &#8216;BookStore&#8217;<br /> <br /> $myConnection = mysql_connect(&#8220;localhost&#8221;,&#8221;username&#8221;,&#8221;password&#8221;)<br /> <br /> if (!$myConnection)<br /> <br /> die(&#8216;Could not connect: &#8216;. mysql_error())<br /> </p> <p> <br /> mysql_select_db($myDatabase, $myConnection)<br /> <br /> // if the created_at field is of field type: &#8216;date&#8217;<br /> <br /> mysql_query(&#8220;INSERT INTO Users (first_name, created_at )<br /> <br /> VALUES (&#8216;Frank&#8217;, $today)&#8221;)<br /> <br /> // if the created_at field is of field type: &#8216;datetime&#8217;<br /> <br /> mysql_query(&#8220;INSERT INTO Users (first_name, created_at )<br /> <br /> VALUES (&#8216;Frank&#8217;, $now)&#8221;)<br /> <br /> mysql_close($myConnection)<br /> ?>

As you can see, the day data is designed by PHP. It is then utilised in the query, and throughout the insert the PHP date info is applied.

At this point, you only endeavor is to figure out if you want to capture just the date, or if you furthermore want the the seconds bundled.

A superior rule of thumb to assist determine which to include is as follows.

If the info being inserted is not managed or compared to something else then just the day will do.

If the data currently being inserted is managed or when compared to some thing else then use seconds as well. An illustration of this would be login facts. Normally the programmer wishes to look at the last login to the present login facts. This information will give a greater knowing of how frequently the person is returning and applying the site.