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
13 days, 23 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
This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
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…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing.
Set up your basic HTML file. Open your form tag and set the method and action attributes.:
(CODE)
Set up your first few inputs one for the name and …
Suggested Courses
Course of the Month13 days, 23 hours left to enroll
801 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.