| Re: Problem setting Date field in MySQL [message #178273 is a reply to message #178271] |
Sat, 26 May 2012 00:10   |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 5/25/2012 7:56 PM, Robert wrote:
> Hello,
> I am having an issue with creating a database record and saving dates into the record. I have a form the user
> enter's dates. That form calls the 'updateArticle.php' file and to update or create a new recod. Currently I'm
> only working on the create record side of the program right now. All of the field's are passed from the form to
> the PHP program throught the $_POST method. After that I assign the $_Post variable to a standard PHP variable,
> then create the query and execute it on the database. When I look at the new record in the database, all dates are
> set to '0000-00-00'. I've attempted to use the Date() function and change the format of the dates to 'Y-m-d',
> however that does not work either. I've included the code below, if there is anything unclear or any help anyone
> can provide, please feel free to ask or email me. I've been pulling my hair out tring to figure out where I've
> screwed this up. Thanks!!!
>
> FYI, $_POST['subDate'], $_POST['pubDate'] all echo out to 05-25-2012. The third date (remDate) is left blank on
> purpose. The last echo result in the below code is:
> INSERT INTO `ARTICLES`(`id`, `title`, `sub_date`, `pub_date`, `rem_date`, `body`, `imgname`) VALUES (NULL,'','05-
> 25-2012','05-25-2012','','',NULL)
> 1
>
> ============CODE==============
> $id = sanitizeString($_POST['id']);
> $title = sanitizeString($_POST['title']);
> $subDate = sanitizeString($_POST['subDate']);
> $pubDate = sanitizeString($_POST['pubDate']);
> $remDate = sanitizeString($_POST['remDate']);
> $body = sanitizeString($_POST['body']);
> $imgFileName = sanitizeString($_POST['imgFileName']);
> $query = "INSERT INTO `ARTICLES`(`id`, `title`, `sub_date`, `pub_date`, `rem_date`, `body`, `imgname`)
> VALUES (NULL,'$title','$subDate','$pubDate','$remDate','$body',NULL)";
> $results = mysql_query($query);
> echo $query."<br />".$results;
> remove the @@ and replace with OO to get my email address.
>
> Thanks!!!
>
Echo the actual query you're sending to MySQL, then fix it.
And remember to check how MySQL requires dates to be entered (this is
the wrong newsgroup for that).
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]