Ad:

PHP Discussion Thread
Marked Solved
Views: 702

Page 1
2
3
Next

You are currently viewing page 1 of this multi-page discussion thread

Permalink

Jul 29th, 2010

getting date value

Expand Post »

I don't know where to start so I just got to ask from the experts

. From my MySQL (database) I got a date formatted mm-dd-yyyy (i.e. 01/01/2010), now from my php page there are 3 dropdown/list menus which are for [Month]-[Day]-[Year] and a [TextField] then a [Submit Button]. When I click the [Submit Button] I got to retrieve the date then it will be shown in my texfield. Now the textfield having the value of the date = 01/01/2010 will be the one passing the values on my dropdowns {[Month = January] - [Day = 01] - [Year = 2010]} I just needed the help to how will I start programming as well the design for my database, do I get to have different tables for the parts of the date or what? Thank You for your help.

Last edited by ekseks; Jul 29th, 2010 at 10:58 pm.

Similar Threads

Checking on Date and Time (C#) in C#
Range from start and end date and find date in this range in PHP
Date/Time from DB in C#
Saving a date in MySQL with PHP in PHP

ekseks

Reputation Points: 8

Solved Threads: 0

Junior Poster in Training

Offline

61 posts
since May 2010

Permalink

Jul 29th, 2010

Re: getting date value

Formatting Dates and Times

DATE_FORMAT(date, format) and TIME_FORMAT assist in the representation of dates and times in formats other than the MySQL default format. Three examples illustrate the syntax:

SELECT DATE_FORMAT('2005-12-31', '%M %d %Y')
December 31 2005

SELECT DATE_FORMAT('2005-12-31', '%D of %M')
31st of December

SELECT TIME_FORMAT('02:17', '%H')
02

rch1231

Reputation Points: 101

Solved Threads: 134

Practically a Posting Shark

Offline

870 posts
since Sep 2009

Permalink

Jul 30th, 2010

Re: getting date value

Thank You Sir rch1231, I'll be posting the code that I'm currently working right now that I also found here in the forums. Thank You again.

ekseks

Reputation Points: 8

Solved Threads: 0

Junior Poster in Training

Offline

61 posts
since May 2010

Permalink

Jul 30th, 2010

Re: getting date value

I found this here in the forums, so yah it's working but when I changed the format of my date to mm-dd-yyyy, it's entering 00-00-0000, why is that? then as you can see I also have 3 inputfields when I clicked the submit button. I want to get a certain date from my database thus putting [Name of the Month] - [Day] - [Year]. Is that possible? Thanks.

My HTML code:

PHP Syntax (Toggle Plain Text)
<html>
<meta content= "text/html; charset= utf-8" http-equiv="Content-Type"/>
<head>
 
<link type="text/css" href="development-bundle/themes/base/ui.all.css" rel="stylesheet">
	<script type="text/javascript" src="development-bundle/jquery-1.3.2.js"></script>
	<script type="text/javascript" src="development-bundle/ui/ui.core.js"></script>
	<script type="text/javascript" src="development-bundle/ui/ui.datepicker.js"></script>
	<script type="text/javascript">
	$(function() {
		$("#datepick").datepicker({
			dateFormat: 'yy-m-d'
		});
	});
	</script>
 
</head>
 
<body>
 
<div>
<form action="insert_db.php" method="post">
 
Date:
<input name="mydate" id="datepick" type="text">
 
<input name="submit" type="submit">
<br>
 
<input name="month" type="text">
<input name="day" type="text">
<input name="year" type="text">
 
<input name="submit" type="submit">
 
</form>
</div>
 
</body>
</html>
<html>
<meta content= "text/html; charset= utf-8" http-equiv="Content-Type"/>
<head>

<link type="text/css" href="development-bundle/themes/base/ui.all.css" rel="stylesheet">
	<script type="text/javascript" src="development-bundle/jquery-1.3.2.js"></script>
	<script type="text/javascript" src="development-bundle/ui/ui.core.js"></script>
	<script type="text/javascript" src="development-bundle/ui/ui.datepicker.js"></script>
	<script type="text/javascript">
	$(function() {
		$("#datepick").datepicker({
			dateFormat: 'yy-m-d'
		});
	});
	</script>

</head>

<body>

<div>
<form action="insert_db.php" method="post">

Date:
<input name="mydate" id="datepick" type="text">

<input name="submit" type="submit">
<br>

<input name="month" type="text">
<input name="day" type="text">
<input name="year" type="text">

<input name="submit" type="submit">

</form>
</div>

</body>
</html>

PHP Code:

PHP Syntax (Toggle Plain Text)
<?php
	$mydate=$_POST['mydate'];
	echo $mydate;
	$mydate = date("d/m/Y", strtotime($mydate));
 
	$connection = mysql_connect("localhost","root","");
	if (!$connection){
		die('Could not connect: ' . mysql_error());
	}
    mysql_select_db("enterdate", $connection);
   $sql="INSERT INTO testing (date) VALUES('$mydate')";
echo $sql;
   $flag=mysql_query($sql);
    if ($flag){
		echo "Record Entry successfull. ";
   }else{
		echo "Record Entry failed. ";
  }
	mysql_close($connection);
?>
<?php
	$mydate=$_POST['mydate'];
	echo $mydate;
	$mydate = date("d/m/Y", strtotime($mydate));

	$connection = mysql_connect("localhost","root","");
	if (!$connection){
		die('Could not connect: ' . mysql_error());
	}
    mysql_select_db("enterdate", $connection);
   $sql="INSERT INTO testing (date) VALUES('$mydate')";
echo $sql;
   $flag=mysql_query($sql);
    if ($flag){
		echo "Record Entry successfull. ";
   }else{
		echo "Record Entry failed. ";
  }
	mysql_close($connection);
?>

ekseks

Reputation Points: 8

Solved Threads: 0

Junior Poster in Training

Offline

61 posts
since May 2010

Permalink

Jul 30th, 2010

Re: getting date value

ok,now while creating database table(testing),what datatype(like integer etc..) you had given.

niths

Reputation Points: 9

Solved Threads: 2

Posting Whiz in Training

Offline

299 posts
since Mar 2010

Permalink

Jul 30th, 2010

Re: getting date value

I required an ID which is INT then a date which is a date type

ekseks

Reputation Points: 8

Solved Threads: 0

Junior Poster in Training

Offline

61 posts
since May 2010

Permalink

Jul 30th, 2010

Re: getting date value

now change that date type to varchar in your database and then check.

niths

Reputation Points: 9

Solved Threads: 2

Posting Whiz in Training

Offline

299 posts
since Mar 2010

Permalink

Jul 30th, 2010

Re: getting date value

i thing change date format here. i dont know it works. try once.

PHP Syntax (Toggle Plain Text)
 
$("#datepick").datepicker({
 
dateFormat: 'yy-m-d'
 
});
 
});
$("#datepick").datepicker({

dateFormat: 'yy-m-d'

});

});

muralikalpana

Reputation Points: 21

Solved Threads: 35

Posting Pro

Offline

534 posts
since Sep 2009

Permalink

Jul 30th, 2010

Re: getting date value

it's working though i wanted to have my data type as a date, ow well I think this will work for now. so now to my next problem i want to put my selected date (assume that it's only one) in a text box and to different fields [Month] - [Day] - [Year] is it possible?

PHP Syntax (Toggle Plain Text)
<html>
<meta content= "text/html; charset= utf-8" http-equiv="Content-Type"/>
<head>
</head>
 
<body>
 
<div>
<form action="insert_db.php" method="post">
 
 
<input name="month" type="text">
<input name="day" type="text">
<input name="year" type="text">
 
<input name="wholedate" type="text">
 
<input name="submit" type="submit">
</form>
</div>
 
</body>
</html>
<html>
<meta content= "text/html; charset= utf-8" http-equiv="Content-Type"/>
<head>
</head>

<body>

<div>
<form action="insert_db.php" method="post">


<input name="month" type="text">
<input name="day" type="text">
<input name="year" type="text">

<input name="wholedate" type="text">

<input name="submit" type="submit">
</form>
</div>

</body>
</html>

Last edited by ekseks; Jul 30th, 2010 at 2:38 am.

ekseks

Reputation Points: 8

Solved Threads: 0

Junior Poster in Training

Offline

61 posts
since May 2010

Permalink

Jul 30th, 2010

Re: getting date value

yes, use explode fuction , slipt the date and display the fields . see this link

raju_boini525

Reputation Points: 10

Solved Threads: 7

Junior Poster in Training

Offline

53 posts
since Aug 2009

Page 1
2
3
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: PHP Vending Machine

Next Thread in PHP Forum Timeline: mail() function: how to add <br /> in the $message received

DaniWeb Message

Cancel Changes

User Name
Password