Web Languages and Standards
Web Languages and Standards

Removing the ' and " marks

Hi all,

I want to store some html/php/javascript in a mySQL database field i.e.

<html>
<p>
<?php echo "hello" ?>
</p>
</html>

and then extract this information and echo it via a php script. i.e.

//conect to db

$info = mysql_query("select * from script where script_id = $script_id", $db);

//if entry exists

echo "$info";

The problem is that the script contains "speech marks" and ultimately ends the echo " " function to early. Any ideas?

-Thanks Chris.

LVL 1

icb01co2Asked: 2004-04-23

Who is Participating?

LVL 6

jkna_gunnCommented: 2004-04-23

try using

http://uk.php.net/manual/en/function.urlencode.php

and

http://uk.php.net/manual/en/function.urldecode.php

http://uk.php.net/manual/en/function.htmlspecialchars.php

LVL 6

Lord_McFlyCommented: 2004-04-23

Before performing the insert do something like..

mysql_query = Replace(mysqlquery,Chr(34),"[quote]")

..then do you insert / update

The just do the reverse Replace when you extract..

myString = Replace(rs("FieldName"),"[quote]",Chr(34))

I can't remember the Chr() num,ber for quotes so just check that out.

LVL 6

Lord_McFlyCommented: 2004-04-28

I was just going over my posts again and realised my suggestion wasn't relavent as you're using php :)

I'm guessing that you are getting a prepared php scripted and just want to display it with your webpage - I think the following might work - replace " with the HTML equiv.

$info = str_replace(chr(34),'"',$info)

LVL 8

hendridmCommented: 2004-04-30

Why not remove the quotes around $info like so:
echo $info;

Not sure why having quotes around it should break it though. Also, beware of SQL injection in your select statement:

if(is_numeric($script_id)) {
$info = mysql_query("select * from script where script_id = $script_id", $db);
}