We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
7 days, 2 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Removing the ' and " marks
Posted on 2004-04-23
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.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
- +1
8 Comments
Before performing the insert do something like..
mysql_query = Replace(mysqlquery,Chr(34)
..then do you insert / update
The just do the reverse Replace when you extract..
myString = Replace(rs("FieldName"),"[
I can't remember the Chr() num,ber for quotes so just check that out.
mysql_query = Replace(mysqlquery,Chr(34)
..then do you insert / update
The just do the reverse Replace when you extract..
myString = Replace(rs("FieldName"),"[
I can't remember the Chr() num,ber for quotes so just check that out.
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),'"
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),'"
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Problem to page | 4 | 104 | |
| Grunt Copy file to another destination. | 1 | 95 | |
| Make Line Items Look Good Over Mobile | 2 | 126 | |
| Unexpected End of File | 11 | 84 |
Shoutout to Emily Plummer (http://www.experts-exchange.com/members/eplummer26.html) for giving me this article! She did most of it, I just finished it up and posted it for her :)
Introduction
In a previous article (http://www.experts-exchang…
Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5.
As we learned in our last micr…
The viewer will learn the basics of jQuery including how to code hide show and toggles.
Reference your jQuery libraries:
(CODE)
Include your new external js/jQuery file:
(CODE)
Write your first lines of code to setup your site for jQuery…
Suggested Courses
Course of the Month7 days, 2 hours left to enroll
732 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.