Single quotes problem

Please support our JavaScript / DHTML / AJAX advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved

Join Date: Jul 2005
Posts: 186
Reputation: aparnesh is an unknown quantity at this point 
Solved Threads: 10
aparnesh's Avatar
aparnesh aparnesh is offline Offline
Junior Poster

Single quotes problem

 
0
  #1
Nov 27th, 2008
I have a database of book titles where string values are stored. A php script reads the data and displays them. The problem is happening when a Book title contains the ' character - as apostrophy let's say. One example is the title "The Devil's Alternative".

So when I write
var Title = <?php echo($Title) ?>;
it's becoming
var Title = 'The Devil's Alternative' ;

and giving an error as the quotes do not match.

How do I avoid this problem ? Also how to avoid some other character combinations (for example // or /* -- javascript will turn them into comments and generate errors)
Reply With Quote Quick reply to this message  
Join Date: Jul 2005
Posts: 186
Reputation: aparnesh is an unknown quantity at this point 
Solved Threads: 10
aparnesh's Avatar
aparnesh aparnesh is offline Offline
Junior Poster

Re: Single quotes problem

 
0
  #2
Nov 27th, 2008
It works if I replace the single quote with a "\'" (backslash before the single quote. So
$Title = str_replace("'", "\'", $Title);

var Title = <?php echo($Title) ?>;
works fine
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC