wats the deal with \"blah\" and \'blah\' ??

[megapuzik]

tru to change this line :

<input type=hidden name="usr_joke" value="<?php echo $usr_joke;?>">

into this :

<input type=hidden name="usr_joke" value="<?php echo stripslashes($usr_joke);?>">

 

[ozefrog]

no luck still

 

[megapuzik]

Originally posted by ozefrog
no luck still

the problem is when you write " you get \" right ??

 

[ozefrog]

Originally posted by megapuzik

the problem is when you write " you get \" right ??

yeah, and in the preview it shows as

joke here \"quote\"

but when u view if from the database it looks like this

joke here \

 

[megapuzik]

Originally posted by ozefrog


yeah, and in the preview it shows as

joke here \"quote\"

but when u view if from the database it looks like this

joke here \

well, you can always try use srt_replace ->

<?php $usr_joke = str_replace('\"','"',$usr_joke);?>
<input type=hidden name="usr_id" value="<?php echo $usr_id;?>"> 
<input type=hidden name="usr_joke" value="<?php echo $usr_joke;?>"> 
<input type=hidden name="usr_ans" value="<?php echo $usr_ans;?>">

Not sure that this will work cuz you maybe needed to change the signs to the ascii ! (< = &lt ..............)

 

[megapuzik]

Originally posted by megapuzik

well, you can always try use srt_replace ->

<?php $usr_joke = str_replace('\"','"',$usr_joke);?>
<input type=hidden name="usr_id" value="<?php echo $usr_id;?>"> 
<input type=hidden name="usr_joke" value="<?php echo $usr_joke;?>"> 
<input type=hidden name="usr_ans" value="<?php echo $usr_ans;?>">

Not sure that this will work cuz you maybe needed to change the signs to the ascii ! (< = &lt ..............)

bah, this board convert ascii, < will be & l t [without the spaces]

 

[ozefrog]

it works, but now it has gotten rid of the quotes when it opens it fromt the sql

 

[megapuzik]

Originally posted by ozefrog
it works, but now it has gotten rid of the quotes when it opens it fromt the sql

Is that a problem ?

 

[ozefrog]

yes cos i run a joke site, and a lot of jokes have quotes and stuff in it

 

[megapuzik]

Originally posted by ozefrog
yes cos i run a joke site, and a lot of jokes have quotes and stuff in it

ok, let me understand, when someone sumbit a joke, in the preview there is no problems with the ", but after the preview, the problems appear again.
then you should use the str_replace in the script that sumbit your joke ! (not only to the preview.

Im going to sleep now, talk with later

 

[ozefrog]

i can get it to parse ' alright but it wont parse anything after the "

 

[ozefrog]

ok

but the script doesnt have the $usr_joke variable

 

[agent007]

Originally posted by ozefrog
ok

but the script doesnt have the $usr_joke variable

Then just replace $usr_joke with the name of your textarea.

 

[ozefrog]

$usr_joke is the name of the text area

 

[ozefrog]

if u like, go to http://www.cheaphumour.com.kg/joke4.php and add some test posts in there using "blah" and 'blah' with both types of quotes in your post, and then u will see my problem.

also i have determined that the " fail to insert into the SQL

 

[megapuzik]

Show me the script that insert the joke into the mySQL

 

[ozefrog]

<?php


include("joke4cfg.php");
$date_post = date("Y-m-d H:i:s");
$connection = mysql_connect($serverAddress,$databaseName,$serverPass)or die("Couldn't make connection.");
$db = mysql_select_db($databaseName,$connection)or die("Couldn't select database");
$insertSql ="insert into joke4 values ('".$usr_name."','".$usr_id."','".$usr_joke."','".$usr_ans."','".$date_post."')";
mysql_query($insertSql);
mysql_close($connection);
include '/usr/home/o/z/ozefrog/public_html/lib/header.inc';
echo "\n\n<font face=verdana size=2><center><strong>Your joke has been added into the joke archive!</center></strong></font><br><br>";
echo "<br><br><br><br><font size=2><center>Click <a href=joke4.php>Here</a> to go back to the joke archive.</font></center>";
include '/usr/home/o/z/ozefrog/public_html/lib/footer.inc';
?>

that was the add code

 

[megapuzik]

Remove the str_replace and in this code, put this in the top :

$usr_joke = stripslashes(htmlspecialchars($usr_joke)) ;

and also, put this code at the top of the page where you preview your joke, it shold work !!

 

[ozefrog]

works in perview but it wont add the joke now

 

[megapuzik]

Originally posted by ozefrog
works in perview but it wont add the joke now

so remove this when you add to the database, and add this line in the top of the page that show the joke.