Please support our PHP advertiser: Lunarpages PHP Web Hosting
 |
•
•
Join Date: Oct 2007
Posts: 194
Reputation: 
Rep Power: 2
Solved Threads: 2
Junior Poster
Hi there
I'm using preg_replace to replace ' and " with a backslash in front of them so that I don't get problems with my MySQL INSERT queries. But at the moment I can only replace them with one charater as below:
At the moment that just replaces both ' and " with ' which isn't ideal. Can anyone tell me how I'd be able to replace them with the respective charater. (e.g. ' would be replaced with \' and " would be replaced with\")
I'm using preg_replace to replace ' and " with a backslash in front of them so that I don't get problems with my MySQL INSERT queries. But at the moment I can only replace them with one charater as below:
php Syntax (Toggle Plain Text)
At the moment that just replaces both ' and " with ' which isn't ideal. Can anyone tell me how I'd be able to replace them with the respective charater. (e.g. ' would be replaced with \' and " would be replaced with\")
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 9
Solved Threads: 240
Umm.. I am not sure about preg_replace. But you can do the same with str_replace!
Hope it helps!
Naveen
php Syntax (Toggle Plain Text)
Hope it helps!
Naveen
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Apr 2007
Location: Birmingham
Posts: 397
Reputation:
Rep Power: 2
Solved Threads: 40
Posting Whiz
you dont need str_replace inside str_replace etc etc.
use two arrays
this way you can have two arrays and no messy inner replacements inside replacements.
although nav33n may have shown you his way as at first it appears easier (both do the same trick).
use two arrays
$your_txt = "Hello 'WORLD'";
$txt = array("'", "\"");
$txt_replace = array("\'", "\\\"");
$x=str_replace($txt, $txt_replace, $your_txt);
echo $x;this way you can have two arrays and no messy inner replacements inside replacements.
although nav33n may have shown you his way as at first it appears easier (both do the same trick).
When Autumn Falls [ http://www.whenautumnfalls.co.uk ] &&
Designdotworks [ http://www.designdotworks.co.uk ] Web / Graphic / Software Design
Designdotworks [ http://www.designdotworks.co.uk ] Web / Graphic / Software Design
•
•
Join Date: Apr 2005
Location: New York state
Posts: 525
Reputation:
Rep Power: 6
Solved Threads: 80
Code Monkey
... I'm not entirely sure why'd you write your own function when the built-in addslashes function works perfectly well.
GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h-->++ r z+*
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h-->++ r z+*
•
•
Join Date: Jan 2008
Posts: 57
Reputation:
Rep Power: 2
Solved Threads: 5
Junior Poster in Training
•
•
•
•
Originally Posted by ShawnCplus 
... I'm not entirely sure why'd you write your own function when the built-in addslashes function works perfectly well.
Aye, I was wondering the same thing.
addslashes() is slightly different - it escapes a couple of extra characters (including '\' and NUL). However, these (especially \) need to be escaped anyway.
So, to fill in the original example...
$unedited = $_POST['content']; $content = addslashes($unedited);
However, you might be looking to learn how to use preg_replace... so we'll go back to the original example.
You can use preg_replace() like Fungus did with str_replace - sending an array as the search and replacement parameters.
The problem with your example is that you're only presenting one thing for the replacement parameter - "\'".
In order to replace ' with \' and " with \" you need to do one of a few things - perform two preg_replaces (one for each replacement), use arrays within the preg_replace, or use a variable in the regex to print the quote based on what the search found. I'm not that good with regex, so I'm not sure if you can do that... but I think you can.
Anyhow, here's an example of how you could use arrays to perform the desired function with preg_replace.
$string = "\"You're not very wise,\" said the wise man.";
$string = preg_replace(array("/'/", '/"/'), array("\'", '\"'), $string);
echo $string;That appears to escape both the single and double quotes just fine.
Good luck,
- Walkere
•
•
Join Date: Oct 2007
Posts: 194
Reputation:
Rep Power: 2
Solved Threads: 2
Junior Poster
All I can say is WOW. I have to admit that I'm somewhat of a noob to PHP and that addslashes function is the best thing since sliced bread 
Thanks to all of you for your response and especially to you Walkere (extra rep for you ) for taking the time to give an example using pre_replace. Much appreciated.
Thanks to all of you for your response and especially to you Walkere (extra rep for you
) for taking the time to give an example using pre_replace. Much appreciated. |
Other Threads in the PHP Forum
- Previous Thread: Need help NEWSLETTER
- Next Thread: creating pdf in php
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
