RE: [PHP] Re: Insert Data Into Mysql
| From: | Richard L. Buskirk | Date: | Sat, 11 Jan 2014 03:43:19 +0000 |
| Subject: | RE: [PHP] Re: Insert Data Into Mysql | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-322670@lists.php.net to get a copy of this message | ||
> 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)