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

Program Name: DateTime with PHP and MySql

Published By: snippets.dzone.com

License Type: Freeware

Date Released: April 19, 2012


DateTime with PHP and MySql Instant Download

DateTime with PHP and MySql Desciption:


Advertisements



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

BuzzBundle Professional
IP Cam Soft Basic
Icecream Image Resizer
FirePlotter
Privacy Eraser Free
NoteBurner Spotify Music Converter
RPM Remote Print Manager Select 64 Bit
Koinonein Torrent Editor
DataNumen Office Repair
Active@ UNERASER
mightymacros Excel Utilities
Driver Booster
Advanced SystemCare Ultimate
Backup4all Professional
Image Tuner
PDF Studio Viewer for Windows
DataNumen Word Repair
Emsisoft Anti-Malware
Happytime RTMP Pusher
PDF-XChange Editor
True Burner
HelpNDoc
AllMyNotes Organizer Portable
Magic Lines
Nonlinear analysis - DataFitting

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
MathCast
Cleanup and Update Tool for Cisco CUCM
FTP!
Open-School Community Edition
Count Code
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
Photo! Editor
Sondle Virtual Desktop Assist

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