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
Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag
Checking if field is empty AND using !is_numeric
Hi lads,
Need to be able to display an error message (using isset?) that says "Cant lea
Windows 7
Windows 7 default user account control worries experts. Corporate IT departments should be pleased w
php redirecting
i wont open a new thread but i have a question about redirecting....
i wonder why my code doesnt
Why doesn't this work? (SSH2)
This is my script:
Code: <?php
$connection = ssh2_connect('213.251.167.109', 22);Escaped characters
I have a script that allows you to post news to the home page of my site. Along with the news is the
Display the user's weight lost in the past week
Hello everyone,
I am working on a weight loss app for my site, and I want to display the user
SAP FICO learning materials
Hi all,
I am new to this world of SAP FICO. I have taken training on SAP FICO, but was wonderin
Get content from table into a list, without repeating.
Alright this is kinda an odd thing, so I need some help.
I have a table "quote" wit
Secure pages Sessions vs. Cookies & session_destroy() help
Im new here and new to PHP, I hope you can help me with some questions.
Im writing my web ap
