<script language=\"javascript\"> Display problem with PHP & MYSQL

Reply

Join Date: Sep 2004
Posts: 3
Reputation: dr_dumb99 is an unknown quantity at this point 
Solved Threads: 0
dr_dumb99 dr_dumb99 is offline Offline
Newbie Poster

<script language=\"javascript\"> Display problem with PHP & MYSQL

 
0
  #1
Jul 17th, 2006
Hi !
When I want to display following code by assigning it to $res["description"] , in the following mentioned way, it works fine and displays properly. The code is :
/************START CODE*****************/
<script language=\"javascript\">
var uri = 'http://impgb.tradedoubler.com/imp/img/16173558/1014659?' + new String (Math.random()).substring (2, 11);
document.write('<a href=\"http://clkuk.tradedoubler.com/click?p=37983&a=1014659&g=16173558&epi=$_SESSION[UID]\" target=\"_blank\"><img src=\"'+uri+'\" border=0></a>');
</script>
/***********END CODE******************/

<tr>
<td colspan="4"><div align="center">
<?php
$res["description"] = "<script language=\"javascript\">
var uri = 'http://impgb.tradedoubler.com/imp/img/16173558/1014659?' + new String (Math.random()).substring (2, 11);
document.write('<a href=\"http://clkuk.tradedoubler.com/click?p=37983&a=1014659&g=16173558&epi=$_SESSION[UID]\" target=\"_blank\"><img src=\"'+uri+'\" border=0></a>');
</script>";

echo $res["description"];

?>
</div></td>
</tr>



But when I get the value of $res["description"] from database , then nothing displays. I am using PHP and MYSQL and I have also confirmed that there is an entry in database with same code.

Thanks in advance
Reply With Quote Quick reply to this message  
Join Date: Jul 2004
Posts: 166
Reputation: Lafinboy is an unknown quantity at this point 
Solved Threads: 7
Lafinboy's Avatar
Lafinboy Lafinboy is offline Offline
Junior Poster

Re: <script language=\"javascript\"> Display problem with PHP & MYSQL

 
0
  #2
Jul 17th, 2006
Have a look at the source that is generated by the above code. You will no doubt see that there are errors in the generated source caused by escaped/unescaped characters from the database.
If I've been a help please confirm by clicking the Add to Lafinboy's Reputation link in the header of this reply.

Lafinboy Productions
:: Website Design :: Website Development ::

Reply With Quote Quick reply to this message  
Join Date: Mar 2005
Posts: 22
Reputation: Mr Violent is an unknown quantity at this point 
Solved Threads: 0
Mr Violent Mr Violent is offline Offline
Newbie Poster

Re: <script language=\"javascript\"> Display problem with PHP & MYSQL

 
0
  #3
Jul 19th, 2006
Some characters do not get saved to a MySQL database, due to the way MySQL handles information. If your string you're inputting into a text or varchar field includes one of these symbols, ' for example, none of your information will be placed into the database.

You can solve this by using the html_special_chars() function to convert your code into HTML characters that are safe for storage.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the PHP Forum
Thread Tools Search this Thread



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

©2003 - 2009 DaniWeb® LLC