Grep Again (was: MySQL UPDATE)
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 68870
interpreted = N
texte = Thanks Marc. To clarify, I'm trying to replicate the mysql_real_escape_string() function from PHP5. I have the following grep statement, but it won't put the backslash in front of the pattern. This: [grep search=[\'"]&replace=\\1]\'"[/grep] Should return this: \\\'\" But, I'm getting this: \\\ Ideas? On 4/24/07 5:15 PM, "Marc Thompson"
wrote: > Clint, > As a rule, before writing any user entered data into a database, I > cleanse it. Here's an example: > [replace db=mydb.db&eqSKUdatarq=[cart]][formvariables > name=_&exact=F][getchars start=2][name][/getchars]=[Grep > search=[^,-.%@_A-Za-z0-9 > ]&replace=][url][value][/url][/Grep]&[/formvariables][/replace] > > Here's what I use to clean up form variables passed to a page: > [formvariables] > [text][name]=[Grep search=[^,-.%@_A-Za-z0-9 > ]&replace=][value][/Grep][/text] > [/formvariables] > > Notice the line wrap immediately following the 0-9. That is a space. > > HTH, > Marc > > Clint Davis wrote: > >> I need to use WebDNA to update a MySQL table. Does anyone have some words of >> advice (or code preferably) to "cleanse" the user input before executing the >> SQL UPDATE statement? ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thanks Marc. To clarify, I'm trying to replicate the mysql_real_escape_string() function from PHP5. I have the following grep statement, but it won't put the backslash in front of the pattern. This: [grep search=[\'"]&replace=\\1]\'"[/grep] Should return this: \\\'\" But, I'm getting this: \\\ Ideas? On 4/24/07 5:15 PM, "Marc Thompson" wrote: > Clint, > As a rule, before writing any user entered data into a database, I > cleanse it. Here's an example: > [replace db=mydb.db&eqSKUdatarq=[cart]][formvariables > name=_&exact=F][getchars start=2][name][/getchars]=[Grep > search=[^,-.%@_A-Za-z0-9 > ]&replace=][url][value][/url][/Grep]&[/formvariables][/replace] > > Here's what I use to clean up form variables passed to a page: > [formvariables] > [text][name]=[Grep search=[^,-.%@_A-Za-z0-9 > ]&replace=][value][/Grep][/text] > [/formvariables] > > Notice the line wrap immediately following the 0-9. That is a space. > > HTH, > Marc > > Clint Davis wrote: > >> I need to use WebDNA to update a MySQL table. Does anyone have some words of >> advice (or code preferably) to "cleanse" the user input before executing the >> SQL UPDATE statement? ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Clint Davis
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
PCS Emailer's role ? (1997)
PCS Frames (1997)
Generating a random image, but avoiding repeated images. (1999)
quitting (1997)
Error:Too many nested [xxx] contexts (1997)
pc (1997)
Frames and WebCat (1997)
Grep all content between twp p tags (2006)
[WebDNA] TLS 1.2 and [tcpconnect] (2018)
OT: CSS expert needed for a newbie question (2002)
Problems passing [SKU] with $Replace in 2.0 (1997)
autosensing lanague selection (1997)
TcpConnect get files on ver. 5.x BUG BUG BUG (2004)
php vs WebCatalog (2000)
My slower response (1997)
[WebDNA] Can WebDNA corrupt a db? (2012)
off-topic: SMS interface? (2001)
WebCatalog for Postcards ? (1997)
[SMSI] WebDNA is too good to go away! (2006)
Problem with ShoppingCart.tpl refresh (2000)