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 (183)

Platform: All

Language: PHP

Related Software
New Reviews
New Downloads Top Downloads Top Search

New Downloads

GlassWire Data Usage Monitor
Start Menu 8
IObit Malware Fighter
ChequeSystem Cheque Printing Software
Net Monitor for Employees Professional
WidsMob ImageConvert
WidsMob HDR
WidsMob Montage
WidsMob Panorama
Project Packer
Simple Disable Key
ACDSee Ultimate
Tab Writer
My System Mechanic
Business Process Manager
Photovoltaic System
TATEMS Fleet Maintenance Software
iCare Data Recovery Free
Encrypt Care
Blackjack Systems Analyst
Handy Backup Home Standard

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
Photo! 3D Album
Syston Data Recovery Free

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