need help with date function


Posted on 16th Feb 2014 07:03 pm by admin

i have following form for date

Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
Did you know?Explore Trending and Topic pages for more stories like this.
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Untitled Document</title>
</head>

<body>
<form name="form1" method="post" action="date.php">
<label>Date:
<select name="day" id="day">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</label>
-
<label>
<select name="month" id="month">
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4">Apr</option>
<option value="5">May</option>
</select>
</label>
-
<label>
<select name="year" id="year">
<option value="2000">2000</option>
<option value="2001">2001</option>
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
</select>
</label>
<p>
<label>
<input type="submit" name="button" id="button" value="Submit">
</label>
</p>
</form>
</body>
</html>

and here is the php page

Code: <?php
$day = $_POST["day"];
$month = $_POST["month"];
$year = $_POST["year"];

$date = date($day." ".$month." ".$year);
//$date = date("Y m d");
echo $date;
$db = mysql_connect("localhost");
mysql_select_db("test", $db);
$query = "insert into date
(
date
)
values
(
'".$date."'
)";
//echo $query;
$result = mysql_query($query) or die(mysql_error());

echo "your date is added";
?>
when i select any date from form and press submit button it adds only this 0000-00-00 to my table. i want date to be inserted to my table not 0s. how can i solve this problem
Trending TodaySee what people are reading
No comments posted yet

Your Answer:

Login to answer
78 Like 11 Dislike
Previous forums Next forums
Other forums

Two warning messages
Quote<b>Warning</b>: mysql_real_escape_string() expects parameter 1 to

Help Ordering Arrays
Hi, I have 3 arrays as shown below.

Code: $users = $this->get_latest_users();
$flir

How to create a static html menu from a database
Hi,

I have built a small cms which allows me to create simple html pages and then upload them

Text Not Displaying Correctly With PHP:GD
I recently moved servers and since then I have noticed that one line of text is showing weirdly.

Place specific image in html page when specific name is typed.
Hello,

Fairly new to PHP and was curious if someone might know how to solve a fairly simple r

Displaying data from MySql a different way
Hi all,
I'm pretty new to php and MySql and have hit a problem.

I am able to display data

this code is not working????
it says this error.. Warning: Division by zero in ..

the variables are correct, so why is th

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

date function help
i need help with date function

Code: [Select]<!DOCTYPE HTML PUBLIC "-//W3C//DTD H

User feedback after MySQL query has been executed
Hi all, I've just registered on PHPFreaks because I've got a question that I simply can't work out b

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



 
© indyaspeak.com. All Rights Reserved.
Play Free Quiz and Win Cash