| Re: Problem setting Date field in MySQL [message #178275 is a reply to message #178271] |
Sat, 26 May 2012 03:16   |
Jeff North
Messages: 58
Registered: November 2010
Karma:
|
Member |
|
|
On 25 May 2012 23:56:29 GMT, in comp.lang.php Robert
<m@@reservices(dot)ytg(at)gmail(dot)com>
<4fc01c2d$0$1765$c3e8da3$66d3cc2f(at)news(dot)astraweb(dot)com> 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
Your dates need to be in yyyy-mm-dd format
> | ============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!!!
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]