RE: [PHP-DB] php maximum characters in text field
I have always called them curly quotes and when I Googled curly quotes in php, I came up with the script I sent yesterday. But, I think you are right. -Original Message- From: Niel Archer [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 17, 2007 5:39 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] php maximum characters in text field Hi Does anyone know how to look for a Curly quote or typographer's quotation mark. Do you mean the equivalent of the left and right double quote entities in HTML (or 66's and 99's as we called them at school)? -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php maximum characters in text field
Does anyone know how to look for a Curly quote or typographer's quotation mark. They are being submitted on our form under customer description. I have created a function that replaces a regular straight quotation mark ($title = str_replace(', , $title);), but do not know what to put in as the look for for the curly mark! -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 3:29 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Do you see those apostrophes in that text? They need to be properly escaped. Date: Mon, 15 Oct 2007 15:09:52 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Here is the exact text he submitted: Please initiate phone lines in the following locations in the Leon County Civic Center to support our home Men's and Women's Basketball games. Meeting room B: activate 4 lines on the North Wall and 4 lines on the South Wall - all lines should have long distance with credit card only. Courtside: 1 - Please re-activate saved phone number 224-8790 along the West side press row. Please include long distance on the phone. 2 - Please activate the ISDN line on the East side scorer's table. 3 - Please re-activate the saved phone number 224-1155 on the East side scorer's table. Work room: Please activate 2 lines in the work room, one for telephone and one for fax. - Both with long distance capability Please call, e-mail or fax the telephone numbers associated with each location to Stuart Pearce at 644-4694 (office), 645-3278 (fax), [EMAIL PROTECTED] Thank you, Stuart Pearce _ Help yourself to FREE treats served up daily at the Messenger Café. Stop by today. http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php maximum characters in text field
Does anyone know how to look for a Curly quote or typographer's quotation mark. They are being submitted on our form under customer description. I have created a function that replaces a regular straight quotation mark ($title = str_replace(', , $title);), but do not know what to put in as the look for for the curly mark! How do you know they are submitting ? Can you copy from that source, then paste it into your str_replace function? Or since it seems to be a two-byte character (I didn't see it at asciitable.com): Maybe you need http://php.he.net/manual/en/ref.mbstring.php mb_ereg_replace _ Peek-a-boo FREE Tricks Treats for You! http://www.reallivemoms.com?ocid=TXT_TAGHMloc=us -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php maximum characters in text field
I was able to copy and paste from the customer's email exactly what they were trying to submit. When I back-spaced out their single quote and put in my own, it worked fine. That's how I narrowed it down to that particular character. With much help from a coworker, I was able to implement some functions, and call them BEFORE php tries to create the new record in the database. That was my biggest problem ... I put the cleanup code in the wrong place, after the new record command. However, here's what the function looks like (it also gets out ~'s: function convert_smart_quotes($string) { $search = array(chr(145), chr(146), chr(147), chr(148), chr(151)); $replace = array(', ', '', '', '-'); return str_replace($search, $replace, $string); } -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 17, 2007 1:54 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Does anyone know how to look for a Curly quote or typographer's quotation mark. They are being submitted on our form under customer description. I have created a function that replaces a regular straight quotation mark ($title = str_replace(', , $title);), but do not know what to put in as the look for for the curly mark! How do you know they are submitting ? Can you copy from that source, then paste it into your str_replace function? Or since it seems to be a two-byte character (I didn't see it at asciitable.com): Maybe you need http://php.he.net/manual/en/ref.mbstring.php mb_ereg_replace _ Peek-a-boo FREE Tricks Treats for You! http://www.reallivemoms.com?ocid=TXT_TAGHMloc=us -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php maximum characters in text field
Hi Does anyone know how to look for a Curly quote or typographer's quotation mark. Do you mean the equivalent of the left and right double quote entities in HTML (or 66's and 99's as we called them at school)? -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php maximum characters in text field
VanBuskirk, Patricia napsal(a): The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit is he got an email back with Undefined variable errors wherever the database was supposed to send back info, and no record was created. I guess you are using get method of http request which is limited by maximum URL Length (2083 chars in IE). Force the browser to use post by form method=post. OKi98 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php maximum characters in text field
varchar maxs out at 255 characters just for clarification, mysql varchar easily can hold more than 255 characters (I remember it was the case in ancient 3.x times) only if one wants to store newlines he must use type text just my 2 cent News to me, so I check the docs. http://dev.mysql.com/doc/refman/5.0/en/char.html Apparently varchar can easily hold more than 255 chars IF YOU USE VERSION 5.0.3 OR LATER. Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions. We assume the OP is using form method=post if he is checking the $_POST variable. Good catch (OKi98) if he is not. _ Windows Live Hotmail and Microsoft Office Outlook – together at last. Get it now. http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=CL100626971033
RE: [PHP-DB] php maximum characters in text field
I am starting to believe it is NOT the character length that is causing the problem. We have received other orders with more in it than that, and they came in ok. I think there may be something in the input that php does not like. I've been searching for code that will clean up input, possibly preg_replace? -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 10:37 AM To: php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field varchar maxs out at 255 characters just for clarification, mysql varchar easily can hold more than 255 characters (I remember it was the case in ancient 3.x times) only if one wants to store newlines he must use type text just my 2 cent News to me, so I check the docs. http://dev.mysql.com/doc/refman/5.0/en/char.html Apparently varchar can easily hold more than 255 chars IF YOU USE VERSION 5.0.3 OR LATER. Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions. We assume the OP is using form method=post if he is checking the $_POST variable. Good catch (OKi98) if he is not. _ Windows Live Hotmail and Microsoft Office Outlook - together at last. Get it now. http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=CL100626971033 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php maximum characters in text field
I am starting to believe it is NOT the character length that is causing the problem. We have received other orders with more in it than that, and they came in ok. I think there may be something in the input that php does not like. I've been searching for code that will clean up input, possibly preg_replace? Was the order received, but the text was shorter than expected? Or was the order not received at all? Check your mysql query log. It may show failed queries where bad characters made the query fail, perhaps using ' or ? Use mysql_real_escape_string. _ Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php maximum characters in text field
It isn't sending to MySql, we use FileMaker Pro 9. A new record did not get made in the d'base... the confirmation email went out, but wherever info was supposed to kick back from the d'base (ie. Order number), it showed an undefined variable error. -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 1:05 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field I am starting to believe it is NOT the character length that is causing the problem. We have received other orders with more in it than that, and they came in ok. I think there may be something in the input that php does not like. I've been searching for code that will clean up input, possibly preg_replace? Was the order received, but the text was shorter than expected? Or was the order not received at all? Check your mysql query log. It may show failed queries where bad characters made the query fail, perhaps using ' or ? Use mysql_real_escape_string. _ Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php maximum characters in text field
VanBuskirk, Patricia napsal(a): It isn't sending to MySql, we use FileMaker Pro 9. A new record did not get made in the d'base... the confirmation email went out, but wherever info was supposed to kick back from the d'base (ie. Order number), it showed an undefined variable error. -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 1:05 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field I am starting to believe it is NOT the character length that is causing the problem. We have received other orders with more in it than that, and they came in ok. I think there may be something in the input that php does not like. I've been searching for code that will clean up input, possibly preg_replace? Was the order received, but the text was shorter than expected? Or was the order not received at all? Check your mysql query log. It may show failed queries where bad characters made the query fail, perhaps using ' or ? Use mysql_real_escape_string. _ Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct post the code (form + script that proccesses passed variables + print_r($_POST) ), it'll make the things much quicker. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php maximum characters in text field
Do you see those apostrophes in that text? They need to be properly escaped. Date: Mon, 15 Oct 2007 15:09:52 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Here is the exact text he submitted: Please initiate phone lines in the following locations in the Leon County Civic Center to support our home Men's and Women's Basketball games. Meeting room B: activate 4 lines on the North Wall and 4 lines on the South Wall - all lines should have long distance with credit card only. Courtside: 1 - Please re-activate saved phone number 224-8790 along the West side press row. Please include long distance on the phone. 2 - Please activate the ISDN line on the East side scorer's table. 3 - Please re-activate the saved phone number 224-1155 on the East side scorer's table. Work room: Please activate 2 lines in the work room, one for telephone and one for fax. - Both with long distance capability Please call, e-mail or fax the telephone numbers associated with each location to Stuart Pearce at 644-4694 (office), 645-3278 (fax), [EMAIL PROTECTED] Thank you, Stuart Pearce _ Help yourself to FREE treats served up daily at the Messenger Café. Stop by today. http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline
RE: [PHP-DB] php maximum characters in text field
varchar maxs out at 255 characters just for clarification, mysql varchar easily can hold more than 255 characters (I remember it was the case in ancient 3.x times) only if one wants to store newlines he must use type text just my 2 cent -- View this message in context: http://www.nabble.com/php-maximum-characters-in-text-field-tf4614039.html#a13191426 Sent from the Php - Database mailing list archive at Nabble.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php maximum characters in text field
Unless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise?Thanks! Trish _ Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122
RE: [PHP-DB] php maximum characters in text field
Yes, that is the HTML and the PHP code to check. What about the php code to go to the db? Bastien Date: Fri, 12 Oct 2007 11:42:25 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field The field on the form is as such: TEXTAREA name=Customer_Description cols=100 rows=10 tabindex=44/TEXTAREA The confirmation page is: ?php echo ($_POST['Customer_Description']); ? From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:26 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text fieldAnd how is the table / field of interest configured? 833 will obviously not fit into a 255 varchar field... Bastien Subject: RE: [PHP-DB] php maximum characters in text field Date: Fri, 12 Oct 2007 11:24:14 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit is he got an email back with Undefined variable errors wherever the database was supposed to send back info, and no record was created.From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text fieldUnless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise?Thanks! Trish Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122 R U Ready for Windows Live Messenger Beta 8.5? Try it today! http://entertainment.sympatico.msn.ca/WindowsLiveMessenger _ Send a smile, make someone laugh, have some fun! Start now! http://www.freemessengeremoticons.ca/?icid=EMENCA122
RE: [PHP-DB] php maximum characters in text field
And how is the table / field of interest configured? 833 will obviously not fit into a 255 varchar field... Bastien Subject: RE: [PHP-DB] php maximum characters in text fieldDate: Fri, 12 Oct 2007 11:24:14 -0400From: [EMAIL PROTECTED]: [EMAIL PROTECTED]; php-db@lists.php.net The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit is he got an email back with “Undefined variable” errors wherever the database was supposed to send back info, and no record was created. From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AMTo: VanBuskirk, Patricia; [EMAIL PROTECTED]: RE: [PHP-DB] php maximum characters in text field Unless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise?Thanks! Trish Express yourself with free Messenger emoticons. Get them today! _ R U Ready for Windows Live Messenger Beta 8.5? Try it today! http://entertainment.sympatico.msn.ca/WindowsLiveMessenger
RE: [PHP-DB] php maximum characters in text field
The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit is he got an email back with Undefined variable errors wherever the database was supposed to send back info, and no record was created. From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Unless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise? Thanks! Trish Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122
RE: [PHP-DB] php maximum characters in text field
The field on the form is as such: TEXTAREA name=Customer_Description cols=100 rows=10 tabindex=44/TEXTAREA The confirmation page is: ?php echo ($_POST['Customer_Description']); ? From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:26 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field And how is the table / field of interest configured? 833 will obviously not fit into a 255 varchar field... Bastien Subject: RE: [PHP-DB] php maximum characters in text field Date: Fri, 12 Oct 2007 11:24:14 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net The info he was trying to submit was 883 characters, including spaces (counted in Word). Many times, people have very detailed descriptions they need to send in. Can you think of a way to work around this limitation? Also, what happened when he tried to submit is he got an email back with Undefined variable errors wherever the database was supposed to send back info, and no record was created. From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Unless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters Post is limited by the php.ini file amounts (usually in the megabyte range). what is the size of the post? Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php maximum characters in text field Is there a maximum number of character $_POST will/can return from a text field. I have an online form that was driving me nuts trying to troubleshoot, as most orders were coming in fine, but this one would not. I narrowed down to the length of the customer description field which has no limits on the form or in the database. I was told there was a limit to how much $_POST could return. Can someone advise? Thanks! Trish Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122 R U Ready for Windows Live Messenger Beta 8.5? Try it today! http://entertainment.sympatico.msn.ca/WindowsLiveMessenger