Page 1 of 1

date from textbox

Posted: Thu Jul 07, 2005 2:58 am
by pleigh
i know hot to format date from database...but i need to know this one, if i have a textbox, i want to input,for example, the enddate of a certain task (11-11-2005)...my idea is if i type it and click submit button, the text i typed will automatically generate the date that i typed...can somebody help me with this?

thanks in advance...:)

Posted: Thu Jul 07, 2005 3:04 am
by harrisonad
Give us sample input that will be generated to date.

Posted: Thu Jul 07, 2005 3:09 am
by pleigh
my sample code below....

Code: Select all

if (isset($_POST['submit']))
{
	$message = NULL;
	
	if (empty($_POST['sample']))
	{
		$s = false;
		$message .= 'no sample<br>';
	}
	else
	{
		$s = strtotime($_POST['sample']);
	}
if ($s)
	{
	$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
		$result = @mysql_query($query) or die(mysql_error());
		
		if ($result)
		{
			echo 'written to db';
			exit();
		}
		else
		{
			$message .= 'no data written in the db';
			
		}
		mysql_close();
	}
	else
	{
		$message .= 'please try again';
	}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
  <p><b/>sample
    <input type="text" name="sample" value="<? if (isset($_POST['sample'])) echo $_POST['sample']; ?>" />
    
  </p>
<input type="submit" name="submit" value="submit" />
</form>
br>';
}
else
{
$s = strtotime($_POST['sample']);
}
if ($s)
{
$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post"&gt;
&lt;p&gt;&lt;b/&gt;sample
&lt;input type=&quote;text&quote; name=&quote;sample&quote; value=&quote;&lt;? if (isset($_POSTї'sample'])) echo $_POSTї'sample']; ?&gt;&quote; /&gt;

&lt;/p&gt;
&lt;input type=&quote;submit&quote; name=&quote;submit&quote; value=&quote;submit&quote; /&gt;
&lt;/form&gt;
[/php:1mp;quote;>
<p><b/>sample
<input type=&quote;text&quote; name=&quote;sample&quote; value=&quote;&lt;? if (isset($_POSTї'sample'])) echo $_POSTї'sample']; ?&gt;" />

</p>
<input type="submit" name="submit" value="submit" /&gt_POST['submit']))
{
$message = NULL;

if (empty($_POST['sample']))
{
$s = false;
$message .= 'no sample<br>';
}
else
{
$s = strtotime($_POST['sample']);
}
if ($s)
{
$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

&lt;form action=&quote;&lt;? echo $_SERVERї'PHP_SELF']; ?&gt;&quote; method=&quote;post&quote;&gt;
&lt;p&gt;&lt;b/&$s = false;
$message .= 'no sample<br&gt;';
}
else
{
$s = strtotime($_POSTї'sample']);
}
if ($s)
{
$query = &quote;INSERT INTO sample(samplefield) VALUES ('$s')&quote;;
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

&lt;form action=&quote;&lt;? echo $_SERVERї'PHP_SELF']; ?&gt;&quote; method=&quote;post&quote;&gt;
&lt;p&gt;&lt;b/&gt;sample
&lt;input type=&quote;text&quote; name=&quote;sample&quote; value=&quote;&lt;? if (isset($_POSTї'sample'])) echo $_POSTї'sample']; ?&gt;&quote; /&gt;

&lt;/p&gt;
&lt;input type=&quote($_POST['submit']))
{
$message = NULL;

if (empty($_POST['sample']))
{
$s = false;
$message .= 'no sample<br>';
}
else
{
$s = strtotime($_POST['sample']);
}
if ($s)
{
$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
<p><b/>sample
<input type="text" name="sample" value="<? if (isset($_POST['sample'])) echo $_POST['sample']; ?>" />

</p>
<input type="submit" name="submit" value="submit" />
</form>
written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
<p><b/>sample
<input type="text" name="sample" value="<? if (isset($_POST['sample'])) echo $_POST['sample']; ?>" />

</p>
<input type="submit" name="submit" value="submit" />
</form>
ssage .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
<p><b/>sample
<input type="text" name="sample" value="<? if (isset($_POST['sample'])) echo $_POST['sample']; ?>" />

</p>
<input type="submit" name="submit" value="submit" />
</form>
1;'sample']))
{
$s = false;
$message .= 'no sample<br>';
}
else
{
$s = strtotime($_POST['sample']);
}
if ($s)
{
$query = &quote;INSERT INTO sample(samplefield) VALUES ('$s')&quote;;
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

&lt;form action=&quote;&lt;? echo $_SERVERї'PHP_SELF']; ?&gt;&quote; method=&quote;post&quote;&gt;
&lt;p&gt;&lt;b/&gt;sample
&lt;input type=&quote;text&quote; name=&quote;sample&quote; value=&quote;&lt;? if (isset($_POSTї'sample'])) echo $_POSTї'sample']; ?&gt;&quote; /&gt;

&lt;/p&gt;
&lt;input type=&qu))
{
$s = false;
$message .= 'no sample<br>';
}
else
{
$s = strtotime($_POST['sample']);
}
if ($s)
{
$query = &quote;INSERT INTO sample(samplefield) VALUES ('$s')&quote;;
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

&lt;form action=&quote;&lt;? echo $_SERVERї'PHP_SELF']; ?&gt;&quote; method=&quote;post&quote;&gt;
&lt;p&gt;&lt;b/&gt;sample
&lt;input type=&quote;text&quote; name=&quote;sample&quote; value=&quote;&lt;? if (isset($_POSTї'sample'])) echoow....

Code: Select all

if (isset($_POST['submit']))
{
	$message = NULL;
	
	if (empty($_POST['sample']))
	{
		$s = false;
		$message .= 'no sample<br>';
	}
	else
	{
		$s = strtotime($_POST['sample']);
	}
if ($s)
	{
	$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
		$result = @mysql_query($query) or die(mysql_error());
		
		if ($result)
		{
			echo 'written to db';
			exit();
		}
		else
		{
			$message .= 'no data written in the db';
			
		}
		mysql_close();
	}
	else
	{
		$message .= 'please try again';
	}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method=&quo06ea10212f]
if (isset($_POST['submit']))
{
	$message = NULL;
	
	if (empty($_POST['sample']))
	{
		$s = false;
		$message .= 'no sample<br>';
	}
	else
	{
		$s = strtotime($_POST['sample']);
	}
if ($s)
	{
	$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
		$result = @mysql_query($query) or die(mysql_error());
		
		if ($result)
		{
			echo 'written to db';
			exit();
		}
		else
		{
			$message .= 'no data written in the db';
			
		}
		mysql_close();
	}
	else
	{
		$message .= 'please try again';
	}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
  <p><b/>sample
    <input type="text" name="sample" value="<? if (isset($_POST['sample'])) echo $_POST['sample']; ?>" /&ST['sample']);
	}
if ($s)
	{
	$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
		$result = @mysql_query($query) or die(mysql_error());
		
		if ($result)
		{
			echo 'written to db';
			exit();
		}
		else
		{
			$message .= 'no data written in the db';
			
		}
		mysql_close();
	}
	else
	{
		$message .= 'please try again';
	}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
  <p><b/>sample
    <input type="text" name="sample" value="<? if (isset($_POST['sample'])) echo $_POST['sampl
	else
	{
		$s = strtotime($_POST['sample']);
	}
if ($s)
	{
	$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
		$result = @mysql_query($query) or die(mysql_error());
		
		if ($result)
		{
			echo 'written to db';
			exit();
		}
		else
		{
			$message .= 'no data written in the db';
			
		}
		mysql_close();
	}
	else
	{
		$message .= 'please try again';
	}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
  <p><b/>sample
    <input type=&quotbmit']))
{
	$message = NULL;
	
	if (empty($_POST['sample']))
	{
		$s = false;
		$message .= 'no sample<br>';
	}
	else
	{
		$s = strtotime($_POST['sample']);
	}
if ($s)
	{
	$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
		$result = @mysql_query($query) or die(mysql_error());
		
		if ($result)
		{
			echo 'written to db';
			exit();
		}
		else
		{
			$message .= 'no data written in the db';
			
		}
		mysql_close();
	}
	else
	{
		$message .= 'please try again';
	}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
  <p><b/>sample
    <input type="text" name="sample" value="<? if (isset($_POST['sample'])) echo $_POST['sample']; ?>" />
    
  </p>
<input type="submit" name="submit" value="submit" />
</form>
sample']);
}
if ($s)
{
$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

&lt;form action=&quote;&lt;? echo $_SERVERї'PHP_SELF']; ?&gt;&quote; method=&quote;post&quote;&gt;
&lt;p&gt;&lt;b/&gt;sample
&am;

if (empty($_POST['sample']))
{
$s = false;
$message .= 'no sample<br>';
}
else
{
$s = strtotime($_POSTї'sample']);
}
if ($s)
{
$query = &quote;INSERT INTO sample(samplefield) VALUES ('$s')&quote;;
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

&lt;form action=&quote;&lt;? echo $_SERVERї'PHP_SELF']; ?&gt;&quote; method=&quote;post&quote;&gt;
&lt;p&gt;&lt;b/&gt;sample
&lt;input type=&quote;text&quote; name=&quote;sample&quote; value=&quote;&lt;? if (isset($_POSTї'sample'])) echo $_POSTї'sample']; ?&gt;&quote; /&gt;
ow....

Code: Select all

if (isset($_POST['submit']))
{
	$message = NULL;
	
	if (empty($_POST['sample']))
	{
		$s = false;
		$message .= 'no sample<br>';
	}
	else
	{
		$s = strtotime($_POST['sample']);
	}
if ($s)
	{
	$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
		$result = @mysql_query($query) or die(mysql_error());
		
		if ($result)
		{
			echo 'written to db';
			exit();
		}
		else
		{
			$message .= 'no data written in the db';
			
		}
		mysql_close();
	}
	else
	{
		$message .= 'please try again';
	}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
  <p><b/>sample
    <input type="text" name="sample" value="<? if (isset($_POST['sample'])) echo $_POST['sample']; ?>" />
    
  </p>
<input type="submit" name="submit" value="submit" />
</form>
0212f]
if (isset($_POST['submit']))
{
$message = NULL;

if (empty($_POST['sample']))
{
$s = false;
$message .= 'no sample<br>';
}
else
{
$s = strtotime($_POST['sample']);
}
if ($s)
{
$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

<form action="<? echo $_SERVERї'PHP_SELF']; ?&gt;&quote; method=&quote;post&quote;&gt;
&lt;p&am';
}
else
{
$s = strtotime($_POST['sample']);
}
if ($s)
{
$query = &quote;INSERT INTO sample(samplefield) VALUES ('$s')";
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

&lt;form action=&quote;&lt;? echo $_SERVERї'PHP_SELF']; ?&gt;&quote; method=&quote;post&quote;&gt;
&lt;p&gt;&lt;b/&gt;sample
&lt;inpu
if (isset($_POST['submit']))
{
$message = NULL;

if (empty($_POST['sample']))
{
$s = false;
$message .= 'no sample<br>';
}
else
{
$s = strtotime($_POST['sample']);
}
if ($s)
{
$query = "INSERT INTO sample(samplefield) VALUES ('$s')";
$result = @mysql_query($query) or die(mysql_error());

if ($result)
{
echo 'written to db';
exit();
}
else
{
$message .= 'no data written in the db';

}
mysql_close();
}
else
{
$message .= 'please try again';
}
}

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">
<p><b/>sample
<input type="text" name="sample" value="<? if (isset($_POST['sample'])) echo $_POST['sample']; ?>" />

</p>
<input type="submit" name="submit" value="submit" />
</form>

Posted: Thu Jul 07, 2005 3:26 am
by harrisonad
Using strtotime() function is really neat but it has some limitations
PHP Manual wrote:The function expects to be given a string containing a US English date format and will try to parse that format into a Unix timestamp
What if the user did not followed the right format? then the date created will not be equivalent to what the user expected.
My suggestion is to create your own function to parse the content of input so that any format will do. it must be user-friendly, like 'July 7,2005'.

But why use textbox to input date if you can just create a 'calendar' using javascript, or make 3 selectboxes for each part of the date(month,day,year), so that the user will never go wrong in inputting date.

Posted: Thu Jul 07, 2005 3:29 am
by pleigh
or use dropdown list instead of checkbox??

Posted: Thu Jul 07, 2005 3:31 am
by harrisonad
yes, sorry again for that.
Note: I edited my post. I really mean 'select boxes'.

Posted: Thu Jul 07, 2005 3:33 am
by pleigh
oh ok...that's cool....thanks for your help pal... :wink: