Re: Re: Insert Data Into Mysql

Sincerely, Jasper Kips Op 11 jan. 2014, om 04:43 heeft Richard L. Buskirk <admin@buskirkgraphics.com> het volgende geschreven: >> On Fri, 10 Jan 2014 17:36:27 -0500, Jim Giner wrote: >>> On 1/10/2014 4:53 PM, Robert wrote: >>>> >>>> I have a date field on an html form that users may leave blank. If >>>> they do leave it blank I want to write the date 01/01/1901 into the >>>> mysql table. How can I accomplish this and where in my .php script >>>> file should I put the code? >>>> >>>> Thank You, >>>> Robert >>>> flahurr@comcast.net >>> Why would you want to put any value in there? Leave it blank. Are >> you >>> editing the input to prevent someone from actually entering that >> date? >>> >>> Where to put this in your php script? That's up to you certainly, >> but >>> I would make sure it was done before I posted my record. >> >> It looks like a new semester has started.... >> > > > MySQL > You can set the value to NOW() or CURRENT_TIMESTAMP(), mysql functions and > format the date the way you want. > > if(!empty$_POST['formdatefield'])) { // POST is just an example > $sql = "INSERT INTO yourtable SET datefield=DATE_FORMAT(NOW(),'%m\%d\%Y') > "; > } > > > > PHP > Validate the date has been set. If not set then set the value to system > current system date. > > if(!empty($_POST['formdatefield'])) { // POST is just an example > $formdatefield = date("m/d/Y"); > $sql = 'INSERT INTO yourtable SET datefield='.$formdatefield; > } > > There are many way to validate POST or GET variables and declare a new > value. > > Richard L. Buskirk > Oracle Certified MySQL 5.6 DBA (OCP) And of course, it is almost mandatory to use prepared statements. Especially if the source of the data is the internet. > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php

Attachment: [application/pgp-signature] Message signed with OpenPGP using GPGMail signature.asc