RE: [PHP] Forms and MySql date
I apologize the correct order is -MM-DD so you would do: $mysqldate = $_POST["year"]."-".$_POST["month"]."-".$_POST["date"]; -Original Message- From: v0idnull [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 4:37 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] Forms and MySql date To avoid user error (remember, 90% of internet users are stupid and illogical and don't know anything), just have drop down menus for the dates and months and allow the user to enter in the year then just do: $mysqldate = $_POST["month"]."-".$_POST["date"]."-".$_POST["year"]; -Original Message- From: Frank Keessen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 1:21 AM To: Philip Hallstrom Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Forms and MySql date Hi, You can let the users enter a date as 20-02-2003 into a textfield with the name $userdate Then you can use this function to convert it; $date_array = split("-", $userdate); $mysqldate = $date_array[2]."-".$date_array[1]."-".$date_array[0]; Store $mysqldate into the database! Regards, Frank - Original Message - From: "Philip Hallstrom" <[EMAIL PROTECTED]> To: "Mike Tuller" <[EMAIL PROTECTED]> Cc: "php mailing list list" <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 11:48 PM Subject: [PHP] Re: Forms and MySql date > You could use the TO_DATE function to convert that text string into a > date, or reformat it in PHP to -mm-dd which mysql will take > automatically (at least I think so) > > On Thu, 20 Feb 2003, Mike Tuller wrote: > > > I have a form that I want to enter a date into a MySql database. I > > currently have the column in the database set as Date, and can't seem > > to get the date I enter into the text field to go into the database > > using the format yymmdd. I could change the column to varchar, and then > > it would enter, but this will be a database that I want to keep track > > of purchases, and if it is entered in as text, I wouldn't be able to do > > calculations such as showing how old something is. > > > > How can I have a text field where a person enters the date and have > > that information entered into the database? > > > > Mike > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Forms and MySql date
To avoid user error (remember, 90% of internet users are stupid and illogical and don't know anything), just have drop down menus for the dates and months and allow the user to enter in the year then just do: $mysqldate = $_POST["month"]."-".$_POST["date"]."-".$_POST["year"]; -Original Message- From: Frank Keessen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 1:21 AM To: Philip Hallstrom Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Forms and MySql date Hi, You can let the users enter a date as 20-02-2003 into a textfield with the name $userdate Then you can use this function to convert it; $date_array = split("-", $userdate); $mysqldate = $date_array[2]."-".$date_array[1]."-".$date_array[0]; Store $mysqldate into the database! Regards, Frank - Original Message - From: "Philip Hallstrom" <[EMAIL PROTECTED]> To: "Mike Tuller" <[EMAIL PROTECTED]> Cc: "php mailing list list" <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 11:48 PM Subject: [PHP] Re: Forms and MySql date > You could use the TO_DATE function to convert that text string into a > date, or reformat it in PHP to -mm-dd which mysql will take > automatically (at least I think so) > > On Thu, 20 Feb 2003, Mike Tuller wrote: > > > I have a form that I want to enter a date into a MySql database. I > > currently have the column in the database set as Date, and can't seem > > to get the date I enter into the text field to go into the database > > using the format yymmdd. I could change the column to varchar, and then > > it would enter, but this will be a database that I want to keep track > > of purchases, and if it is entered in as text, I wouldn't be able to do > > calculations such as showing how old something is. > > > > How can I have a text field where a person enters the date and have > > that information entered into the database? > > > > Mike > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] NULL character help
http://www.psikon.com/vartest.php http://www.psikon.com/vartest.phps how can I get rid of that null character or am I forced to use sub_str in this case? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Arrays as pointers?
A friend of mine showed me this code recently. function firstLogin_string() { mt_srand(make_seed()); $pool = "AaBbCcDdEeFfGgHhIiJjKkLlM"; $length = 26; for($i=0; $i < $length; $i++) { $key .= $pool[mt_rand(0,strlen($pool)-1)]; } return $key; } look at the for loop. $pool is not an array but is being treated as such and the key happens to be the position in $pool and it'll take that letter and save it to $key. I've never seen this done before. What is this method called and what other neat tricks can you do in respect to this? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]