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>
<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
No comments posted yet
Your Answer:
Login to answer
78 
11 
Other forums
PHP Redirecting
Hello everyone. Is there a way to redirect people to pages within a statement in PHP? Since there is
problems with script
I made a small script wich exchanges points in my website:
<?php
session_start
how to populate a drop down box
Hi buddies!
PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar)
is
begin
DOWNLO
please help me... my password gets encrypted but not able to get in database
hai guys,
please help me... in the following function my password gets encrypted but no
SESSION question
I am building an application , a directory for auctions.
For SEO i made a script which copies a p
Cloud Computing?
Hello,
I was wondering if anyone could help explain this term to me. I'm starting to hear it
Material Issuing for receiving batch
Dear All experts in MM/ PP,
Material issuing from main stores to factory is currently usi
Which practice of iteration through containers is preferred
In the "real world" what kind of loop do most people use to iterate through a container like a vecto
Placing and array within an array then sorting it!
I have a page that runs two large mysql queries and saves the results into arrays, in php I then per
Do something every fifth time?
I'm trying to write a loop, but I want it to do something different after every fifth instance. Like
