PHP MySQL Date Update

Shortly after starting to use the PHP/MySQL Server Model in Dreamweaver MX, it occurred to me that the DATE type in the insert/update behaviors did not work properly in some cases. We were constantly adding code to the behavior to make it work correctly. This extension updates the edml file responsible for setting the DATE type and makes sure it is in the YYYY-MM-DD format.

The advantage you ask? A user can enter a date in almost ANY format and it will be properly formatted to the MySQL date format!

March 14, 2004 - I've made an alternate version which stores the MySQL date in the YYYY-DD-MM format as so many european users have requested. Please see:

http://www.dmxzone.com/ShowDetail.asp?NewsId=6391

February 4, 2005 - Fixed a bug that kept upDate from recognizing previously used INSERT or UPDATE behaviors. You will still need to remove and re-add the behavior, but now it doesn't leave any artifacts behind.

Overview

UI Access

This update is automatically added to the Insert/Update Record Server Behaviors of the PHP/MySQL Server Model.

Requirements

Type: Server Behavior
Product: Dreamweaver MX, Dreamweaver MX 2004
Server Model: PHP MySQL
Database: MySQL
Platform: Win XP/2000/2003/2008/7, Mac OS 8.6 or higher, Mac OS X
Browser: All

Greg Olone

Greg OloneGreg is the President & Owner of Stretched Out Software Inc, a flourishing web & multimedia programming company located in Jacksonville, FL USA. With a background in programming and a degree in Computer Animation, the internet has become my playground.

Unless otherwise noted, all of Greg's extensions are Mac & PC compatible!

See All Postings From Greg Olone >>

Reviews

How to use this new behavior ?

May 23, 2003 by perissat isabelle

hello,

I downloaded the file (.mxp), I installed the extension tool and restarted my computer. But no added date format menu is available anywhere and I wonder how to use this tool ?

Thanks in advance for your reply

Isabelle

RE: How to use this new behavior ?

May 23, 2003 by Greg Olone

This extension alters the record insert and update behaviors so that your users can enter a date in almost any format and have it automatically changed to YYYY-MM-DD before inserting/updating into the database.

Greg

Date Update Extensions

May 29, 2003 by priya var

Hi Greg,

Thanks for the information you have provided..Great Job!!

Thanks..

 

RE: RE: How to use this new behavior ?

October 2, 2003 by Kent Livingston
Are you are saying that you don't do anything with behaviors this acts automatically in edit/update foms? 
See all 24 Reviews

You must me logged in to write a review.