Convert a MySQL date field using PHP Functions

Today I am going to show you how to convert data returned from a MySQL database that was store as a date data type into a user friendly format. To do this you can take two different approaches.

Related Tutorials

PHP and MySQL - Introduction
The topics covered in this tutorial include: * PHP basics, including script structure, variables, supported types, constants, expressions, and type conversions * Condition and branch statements supported by PHP, including if, if...else, and the switch statements * Looping statements * Arrays and array library functions * Strings and string library functions * Regular expressions * Date and time functions * Integer and float functions * How to write functions, reuse components, and determine the scope and type of variables * An introduction to PHP object-oriented programming support * Common mistakes made by programmers new to PHP, and how to solve them.

PHP/MYSQL Snippets
This tutorial explains the following: Opening and closing PHP tags; Connecting to a MYSQL Database; Selecting a mysql database; usage of ucfirst, ucwords, strtolower and strtoupper function, Using the date function to print different aspects of the date and time, Printing Browser Info, IP Address and hostname of the ip.

Using MySQL with PHP
This tutorial describes: How to configure PHP with a MySQL server, What are the basic functions to use a MySQL server, A test script with a MySQL server.

Data Integrity Using MySQL and PHP (Part 2)
A continuation of the series, "Data Integrity Using MySQL and PHP," this article discusses the concept of auto_increment fields in MySQL, to cause MySQL to store a unique, incrementing integer in the field of each new row.

Are PHP and MySQL the Perfect Couple?
This is ore of an introductory article on PHP and MySQL covering such topics as features of PHP and MySQL, and how to use PHP to interact with MySQL.

Generating Advanced Web Page Statistics using PHP
This tutorial is intended for the PHP programmer interested in gathering and analyzing Website statistics in a presentable format using mySQL and PHP.You will need a moderate understanding of PHP and a limited knowledge of mySQL, including how to create a mySQL table using the mySQL client.

Acquiring PHP MySQL
PHP and MySQL are already packaged in Linux and Mac OS X OSs. However, most PHP developer are actually using Windows when developing PHP applications. This is also true to myself. I have Mandrake Linux 10 but I'll just use it for testing purposes of my finished scripts. One reason is that Windows render an amazing web presence unlike any other OS's browsers. So this page will only cover the WAMP ( Windows, Apache, MySQL, PHP ). You will learn how to install Apache, PHP, and MySQL under Windows platform.

Date and Time
Most of the time, the date and time functionalities of PHP 5 are used for printing out the current date and timeto pretend that the web page is up to date (you would be surprised how many larger websites actually use this). But apart from that, working with date and time in PHP offers many other possibilities, most of which you will find in this chapter.

Introduction to PHP Functions
Functions are a very important part of PHP and it is probably safe to say that they are used in every single script. This tutorial will guide you through the basics of PHP functions to creating your own to do specific tasks.

PHP and Mysql: Part 1
Alot of people have written in saying that the Using MySQL with PHP tutorials they've found in the internet are difficult to follow. This tutorial is our attempt at solving the confusion and providing a straight-forward explanation of how you use PHP to interact with a MySQL database.

Working with Directories
As is necessary for any language, PHP has a complete set of directory support functions. PHP gives you a variety of functions to read and manipulate directories and directory entries. Like other file-related parts of PHP, the functions are similar to the C functions that accomplish the same tasks, with some simplifications. This tutorial describes how PHP handles directories. You will look at how to create, remove, and read them.

How to connect to MySQL database using PHP
Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running.

Basic mySQL Queries And PHP
This tutorial will help you get started in working with mySQL and PHP. It will assume that you have no prior experience in using mySQL with PHP before. After reading this tutorial, you should get an idea on what a database is, how to use it, and how to access it.

Creating a graphic clock using Date() functions in PHP
In this tutorial I aim to show you one of the many ways of showing the time on a webpage. Many websites use a textual display of the date and time on their site. In this tutorial we will be creating a unique graphic clock using PHP.

How to convert date to time and back
This tutorial show how to convert DATE to TIME and customize output.

Using PHP to search a MySQL database and return paged results
PHP, MySQL and a Web Server capable of parsing PHP pages, like Apache or IIS. This search script does not spider all your pages by crawling the links, so the content you want to be searchable must be within the database. Knowledge of PHP and MySQL is also necessary because this script is just the bones of a working solution.

Databases in PHP - MySQL in PHP
Having studied database basics and taken a look at the Structured Query Language, it's time to dig in. Now we take a look at the use of MySQL in PHP.

Basic HTML newsletter in PHP/MYSQL
This tutorial will teach you how to make a simple newsletter in PHP/MYSQL with account activation. This will require PHP that is not running in SAFE_MODE or PHP that at least allows the sendmail function(duh, you can't send mail without this enabled).

Dynamic URLS using php and mysql
To create dynamic URL with php and mysql is quite simple and this small tutorial will teach you how very easily. If you look at Chipmunk directory, board, or CMScore, you will find that they all use Dynamic URLs with PHP/Mysql.

Working with dates and times in PHP
The date and time functions allow you to use the time of the server that PHP is running on so keep in mind that this function will depend on the local setting of your server.

PHP For Beginners - Free Courses from www.iTechCollege.com
What is PHP? PHP is a computer scripting language, which is originally designed for creating dynamic web pages. PHP is an open-source language, used primarily for dynamic web content and server-side applications. In this course, you will learn how to: How to write to screen; Generate and Retrieve a query string; Use functions; Redirect a page; Show environment variables; How to use cookies in PHP; Include a page; How to connect to MySql database; PHP`s most advantage: create an image directly.

Building a Database-Driven Web Site Using PHP and MySQL
This ten part series of articles will teach you everything you'll need to build a database-driven Web site from the ground up. Main topics include: Installation, Getting Started with MySQL, Getting Started with PHP, Using PHP to access a MySQL database, Relational Database Design, A Content Management System, Content Formatting and Submission, MySQL Administration, Advanced SQL, and Advanced PHP.

Displaying Date and Time using PHP
Type exactly like below in Notepad or any other HTML Editor and save it as date.php in your localhost.

PHP string functions summary
One of PHP strengths are all the string functions. We give you a great help with starting to work with these functions.

Is it possible to repair MySql Databases using PHP?
Why yes, yes it is. Here, we attempt to devise a method of storing the structure of a MySql database and it’s individual tables in PHP.

PHP and Accessing MySQL Databases
PHP can be used for many things, including grabbing your MySQL database entries.

PHP and MySQL for beginners
Very Simple tutorial to get you start using PHP with the most popular MySQL database.

MySQL & PHP Basics
A breif description of each way of using a mysql database with php coding.

Basics to PHP and MySQL
Covers two php techniques, self forms and connecting to mysql.

Introduction to Serializing
Serializing is a technique that allows you to turn variables, arrays, functions or objects from PHP into a form that can be used to store them, and when needed, convert them back into PHP. Serializing is useful for flatfile applications that store things in arrays, and are good for CMS features that can let you edit how it works to an advanced degree.

Making Data Dynamic
One of the main strengths of PHP is its support for a vast number of databases. Very often, PHP and MySQL are viewed as an entity. However, other databases have their strengths, toofor instance, it took MySQL a very long time to support features that are considered standard in other systems; however, MySQL is known to be very fast.

Pagination with PHP
This tutorial is designed to guide you through the logic and code behind the process of paginating data in PHP. In this tutorial, the data is retrieved from mySQL database. I feel you will be able to grasp this tutorial better if you have a decent knowledge of PHP and mySQL.

Design an Online Chat Room with PHP and MySQL
In this article, you will learn how to design and develop a simple online chat room with PHP and MySQL. This tutorial explains every steps of the development, including both database design and PHP programming. Basic computer skills and knowledge of HTML and PHP are required.

Scripting a Dynamic PHP Copyright
The date is fairly specific in how it is scripted. you can single out the year and use the PHP script for year to script a dynamic date so you won't have to update at the end of each year. All you do is set the starting date, apply the script!

Directories, Files and Images
This tutorial describes: Directory functions, File system functions, Image functions, ShowPhoto.php - a sample program.

How to Get Apache, PHP, and MySQL Up and Running
If you have no idea where to start or need some help on how to install, configure and tweak Apache, PHP, and MySQL on Unix or Windows, this 3-part hands-on article will guide you before you get lost in manuals.

Installing Apache, PHP and MySQL
This tutorial will show you how to install Apache 2.0.59, PHP 5.2.3 and MySQL 5.0.41 on machine running Windows XP.

Simple Chatbox in PHP/MySQL
This will show you how to build the frontend of a PHP/MYSQL based chatbox that has a WYSIWYG built in.

PHP Script Tips - Creating Your Own Functions
A collection of 19 tips on creating your own PHP functions. Clear answers are provided with tutorial exercises on defining functions, defining arguments, passing references, returning references, argument default values, etc.

Convert a MySQL date field using PHP Functions

View Tutorial