Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #2208
| From | Jerry Stuckle <jstucklex@attglobal.net> |
|---|---|
| Newsgroups | comp.lang.php |
| Subject | Re: Form fields to database and back? |
| Date | 2011-06-16 21:03 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <ite95t$1b5$2@dont-email.me> (permalink) |
| References | <j48lv6prpshk57ora2dsp6b2lvp16vkvtu@4ax.com> <ite7v0$5jm$1@news.albasani.net> |
On 6/16/2011 8:43 PM, The Natural Philosopher wrote: > bobmct wrote: >> I've run into a situation where the data in a particular set of fields >> on a form contain lots and lots of special characters (they are regex >> notes for a department). >> >> The normal methods I used are failing to retrieve and display the >> original characters. >> >> My google searches come up with some rather conflicting >> recommendataions. So I thought I would ask this group. >> >> What is the most accurate technique for translating, storing, >> retrieving and properly re-displaying such fields with php and mysql? >> >> Thanks >> > try BLOBS > that's good for storage and retrieval. But inserting can be an issue if > the regexp contains 'quotes' Blobs should (almost) never be used to store text (why are they called BINARY LONG OBJECTS?). And quotes are never a problem with any database if you escape the strings properly. -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ==================
Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Form fields to database and back? bobmct <bobm3@worthless.info> - 2011-06-16 20:36 -0400
Re: Form fields to database and back? The Natural Philosopher <tnp@invalid.invalid> - 2011-06-17 01:43 +0100
Re: Form fields to database and back? Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-16 21:03 -0400
Re: Form fields to database and back? Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-16 21:02 -0400
Re: Form fields to database and back? bobmct <bobm3@worthless.info> - 2011-06-16 22:34 -0400
Re: Form fields to database and back? Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-16 23:50 -0400
Re: Form fields to database and back? bobmct <bobm3@worthless.info> - 2011-06-17 07:09 -0400
Re: Form fields to database and back? bobm3@worthless.info - 2011-06-17 15:18 +0000
Re: Form fields to database and back? Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-17 16:44 -0400
Re: Form fields to database and back? "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid> - 2011-06-17 13:28 +0200
Re: Form fields to database and back? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-06-17 22:03 +0200
Re: Form fields to database and back? bobmct <bobm3@worthless.info> - 2011-06-17 19:52 -0400
Re: Form fields to database and back? Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-17 21:01 -0400
Re: Form fields to database and back? Captain Paralytic <paul_lautman@yahoo.com> - 2011-06-22 09:05 -0700
Re: Form fields to database and back? Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-22 13:15 -0400
Re: Form fields to database and back? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-06-18 08:35 +0200
csiph-web