Um.. Apostrophes and PHP..

[Coolj]

Um.. Apostrophes and PHP..

I use ashnews

and recently in my new host when I submit something with an apostrophe it gives me a mysql connect error, but when I put a \ in front it goes through.. ex

He's a good fella.

Will not go through..

He \ ' s a good fella.

Will go through.

[mr e]

i dont know what the question was, but if you do an apostrophe or a quote you have to escape it with a \ before it

[Coolj]

If there any way around this? Like by using str_replace?

[mr e]

oh ok, well to automatically escape EVERYTHING you surround the string with '' (single quotes) but if you do

PHP Code:

<?
$test = blue;
print 'the sky is $test';
?>

that wont work because $test is automatically escaped, but if you dont have any variables in it then single quotes would work

[Coolj]

Hmm..

[Coolj]

Everytime I submitted something with an apostrophe, i'd get a mysql cannot connect error. A friend of mine told me how to fix it..

<?php
$textarea = addslashes($textarea);
?>

[Ajay]

use stripslashes()
i.e

PHP Code:

$bad = 'good'; 
$string = 'Cupcakes are $bad"'; 
echo $string; 

$string = addslashes($string); 
eval("\$string = \"$string\";"); 
$string = stripslashes($string); 

echo $string;