Code Examples -> How to Insert a Date Format Into MySQL from PHP

	Join us on FaceBook
	Submit Your Code
	Poker Tournaments
	Poker Guide for Developers
	SEO Monitor
	UpTime Monitor
	My Favorite Examples
	My Favorite Articles
	Update Your Profile

More Weber Sites
	PHP Code Search
	Web Development Forums
	Learn MySQL Playing Trivia
	PHPBB2 Templates
	Web Development Resources
	Web Development Content
	Internet Security Software

Recommended Links
	PHPClasses
	PHP Editor
	PHP Jobs
	Vision.To Design
	Ajax Tutorials
	PHP Programming Help
	PHP/MySQL Programming
	Webmaster Resources
	Webmaster Forum
	XML meta language
	website builder

Recommended
	פרייסז - הכח לקנות עובר לידיים שלך
	Texas Holdem Poker Evangelists


BACK		ADD A COMMENT		SEND TO A FRIEND		ADD TO MY FAVORITES		ADD CODE EXAMPLES		PRINT

PHP Code Examples

Title :	How to Insert a Date Format Into MySQL from PHP
Categories :	PHP, Databases, MySQL, Date Time, Beginner Guides	Peter Saul
Date :	Mar 30th 2002
Grade :	2 of 5 (graded 24 times)
Viewed :	183165
File :	No file for this code example.
Images :	No Images for this code example.

Search :	More code by Peter Saul
Action :	Grade This Code Example
Tools :	My Examples List

Code

For a quick begginerrs note if you want to insert a date into a MySQL field that is of
DATE type, then do something like the following:

<?php
$date = date("Y-m-d");
mysql_query("INSERT INTO date_table VALUES ('$name', '$date')", $db_connection);
?>

Related Code Examples

	mySQL/PHP/search with multientry form and table output with colored rows Categories : PHP, Beginner Guides, MySQL, HTML and PHP, Databases
	Newbie Notes #4 - Trapping dumb MySQL query errors Categories : PHP, Databases, MySQL, Debugging, Beginner Guides
	email new items in db Categories : PHP, Email, Databases, MySQL, Beginner Guides
	Count how many weeks in the month have a specified day, such as Mon, Tue, etc. Var avail - number of days - first day name of the month, occurrences of Sun, occurrences of Mon, etc. Allows you to calculate number of working hours exclude Holidays. Categories : Calendar, Date Time, PHP, Databases, MySQL
	formating MySQL Timestamp to get a propper Output. related : Timestamp, ereg_replace, mysql, substr Categories : MySQL, PHP, Date Time, Databases
	bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases
	Add, Edit /Update & Delete all in one Contact Management Form Categories : PHP, MySQL, Databases, Beginner Guides
	mysql date/time converters Categories : PHP, MySQL, Databases, Date Time
	This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases, MySQL, Complete Programs, PHP, Databases
	Simple function to return the number of days in a time span between 2 given dates. Categories : PHP, Date Time, MySQL, Databases
	Making a simple Hit-Log using PHP and MySql Categories : PHP, Log Files, Beginner Guides, Databases, MySQL
	Newbie Notes #10 - Generating drop downs Categories : PHP, MySQL, HTML, Beginner Guides, Databases
	Finding the day of the week for a specific date. Categories : PHP, Databases, MySQL, Date Time
	Checks Date-Input from HTML-Forms and converts to YYYY-MM-DD Format for MySQL Date-Fields Categories : MySQL, Date Time, PHP, Databases
	Simple conversion functions to change MySQL dates to arrays, arrays to MySQL dates. Categories : PHP, Arrays, Date Time, Databases, MySQL

User Comments

	Vamshidhar mt wrote : 835 `Hai Saul Peter, U R exampl is simple and easy to Use. I need U R help I had some problem connecting to mysql and I am getting message something like this..... Fatal error: Call to undefined function: mysql_connect() in /var/www/html/DataBase.php on line 9 If U can help me I would be very thank full to U, Do I need to chance any of apache server configuration files if so pls mail me to this ID . Bye Vamshi`
	dragomir laurentiu wrote : 837 `...my php give me something like this :(..Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\phpWeb\date.php on line 3 ...plz give me some idea about mySQL conf.`
	majid hussain wrote : 864 `This exaple print the system date, I want to print what I write into the text field thanks`
	zerin zainal wrote :882 Hai Saul Peter, I need ur help I had some problem connecting to mysql and I am getting message something like this..... Notice: Undefined variable: name in c:\inetpub\wwwroot\php\date.php on line 3 Notice: Undefined variable: db_connection in c:\inetpub\wwwroot\php\date.php on line 3 Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\inetpub\wwwroot\php\date.php on line 3 /If U can help me I would be very thank full to U, Do I need to chance any of apache server configuration files if so pls mail me to this ID . Bye zerin