FileBuzz: Software Download
Find shareware, freeware downloads from thousands of software titles

Program Name: DateTime with PHP and MySql

Published By:

License Type: Freeware

Date Released: April 19, 2012

DateTime with PHP and MySql Instant Download

DateTime with PHP and MySql Desciption:


This script shows, by example, how to convert from a UNIX Timestamp (the returned data type from the PHP time() or mktime() functions) into a string that can be stored in MySql's DATETIME or TIMESTAMP fields. It also shows how to convert back into a UNIX Timestamp. The times are stored in the database as GMT/UTC times, so finally, it shows how to convert from the resulting UNIX timestamp into a string that represents the time with a given GMT/UTC offset.

Convert that UNIX Timestamp into a string, safe for MySql. The string will be in the format CCYY-MM-DD HH:MM:SS and will represent the GMT/UTC time represented by the UNIX Timestamp. Example: 2006-02-10 20:33:55

Parse the String and store the result in a new UNIX Timestamp. Because strtotime() thinks that any string passed to it, that does not specify a timezone, is in the local timezone, according to the settings in your configuration, we append " GMT" to the string that is returned from MySql. This creates a new string that is both compliant with strtotime() and explicitly a GMT value.

Show the two values, in W3C format, for debugging. W3C format dates include the full date, time and timezone information. If we visually or programmatically compare the two values, they should be identical in all aspects.

License: Freeware | Downloads (189)

Platform: All

Language: PHP

Related Software
New Reviews
New Downloads Top Downloads Top Search

New Downloads

All Household Checklists
Network Shares Recycle Bin
Efficient To-Do List
Switch Audio and Mp3 Converter Free
Switch Plus Edition
Syvir PC Build 3
WavePad Masters Edition
Aiseesoft Mac FoneLab
WebSite Auditor Enterprise
Internet of Things Developer
DVDFab HD Decrypter for Mac
DVDFab All-In-One Lifetime Gift for Mac
PDF Rotator
Business Process Manager
Eusing Free Registry Cleaner
Rank Tracker Professional
DVDFab DVD Cinavia Removal for Mac
DVDFab Blu-ray Cinavia Removal for Mac
Duplicate Photo Cleaner
wpCache® WordPress HTTP Cache
Final Selection
Bernida Cams Viewer

Top Downloads

Opera Mini
Turbo C++
Abyss Web Server X1
TaskMerlin Project Management Software
Macrorit Disk Partition Expert Server Edition
Foxit Advanced PDF Editor
Kids Online Browser
Rapid PHP Editor
Cleanup and Update Tool for Cisco CUCM
Open-School Community Edition
Count Code
Daniel Drubin Access Control Suite
simplitec simplisafe
Multi-Process Killer Portable
SCEA Part 2 & 3 Exam EPractize Labs Enterprise
Silva 2.1a2
Agama Web Menus
aXmag Free
Flash Player Pro
Red Call Recorder
Syston Data Recovery Free
Photo! 3D Album

Top Search

Dynamic Graphs With Php Mysql Demos
Insert Edit Delete With Php Mysql
Dictionary With Php Mysql
Tree List With Php Mysql
Newsletter Mailing With Php Mysql
Build Quizzes With Php Mysql
Crm Software Build With Php Mysql
Task Manager With Php And Mysql
Menu Bar With Php And Mysql
Create Html Charts With Php Mysql
Exam Grading System With Php Mysql
Create Bar Chart With Php Mysql
Big Csv To Mysql With Php
Import Dbf To Mysql With Php
Php Mysql Navigation Menu With Demo
Edit Mysql Text With Php
Convert From Dbf To Mysql With Php
Barcode In Mysql Database With Php
Export Mysql Data To Pdf With Php
Import Xml Data To Mysql With Php
Form With File Upload Php Mysql
Import Data Dbf Ke Mysql With Php
Mysql Data Capture With Php Form
Php With Wysiwyg Mysql
Compare Php Mysql With Access