RE: [PHP-DB] Variables Forms
Ron, The email subject line should not have a br / tag in it at all. It is not allowed under the specifications if I remember correctly. I would suggest that when you suck the message in, first thing to do is to remove the br / tag with str_replace... Would this get you on your way? Bastien From: [EMAIL PROTECTED] To: php-db@lists.php.net Date: Tue, 16 Oct 2007 09:47:13 -0500 Subject: [PHP-DB] Variables Forms I am programming a form this morning. I don't understand arrays really well. I think this is what I am needing to use, but I am really not sure. I have a PHP script that checks a POP e-mail address and is suppose to take the incoming message and save it to a mySQL table based on the subject line. Every now and then the subject line is broken with something like a br / and so I have a handful of messages that need to be indexed manually. IE my script can't see a Subject: Correspondence for message 123 --- it is being received as Subject: Correspondence for br /message 123 I am trying to update the mySQL table with a form instead of continuing to use phpmyadmin to do these updates. What I am wanting to do in my form is call up all the incoming messages that have a message value of 0 and I can read through the incoming message to see what their reference number is and type it in the field that I have called new_correspondence_received. An example of my HTML code is below. Where I am getting stuck is if I have more than 1 message that wasn't indexed automatically I am not sure how to retrieve the values of: correspondence_reference and new_correspondence_reference. (The only reason I am displaying correspondence_received is to look for the reference number) Can what I am trying to do be accomplished through an array to find out the values submitted? What changes need to be made to my form so I can find out the values being submitted? Each message received that isn't automatically index is dispayed through this form, one TR per message, thanks for your help. Ron trtd width=200 font face=times new roman center input id=all type=checkbox name=correspondence_reference value=172 checked 172 /center /tdtd width=200 font face=times new roman center input type=text name=new_correspondence_reference size=6 maxlength=30 value = 0 /center /tdtd width=400 textarea COLS=50 ROWS=10 name=correspondence_receivedMessage here/textarea /td/tr _ Have fun while connecting on Messenger! Click here to learn more. http://entertainment.sympatico.msn.ca/WindowsLiveMessenger
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] Variables Forms
Hi Ron br / is perfectly legitimate in an e-mail header field like Subject:. All headers may contain any combination of ASCII characters except CR and LF which are used to terminate the field (See RFC8222 section 2.2). There is also defined a means to fold lines which involves using the CR+LF+white-space combination to indicate multiple line entries. Is it possible your e-mail header fields are doing this and your access to the headers does not take this possibility into account? Without your POP handling code it's impossible to say whether this is your problem or not. -- 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
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