homepage Welcome to WebmasterWorld Guest from 50.16.130.188
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Inserting special characters in MySql with PHP
Inserting special characters in MySql with PHP
bsaric




msg:1282218
 4:27 pm on Mar 13, 2006 (gmt 0)

I got problem with inserting following code in mysql:

<?
Header( "HTTP/1.1 301 Moved Permanently" );
Header( "Location: [new-url.com"...] );
?>

or

<%@ Language=VBScript %>
<%
Response.Status="301 Moved Permanently" Response.AddHeader "Location", " [new-url.com"...]
>

i want that this code is shown like this on page, any suggestion?

 

whoisgregg




msg:1282219
 10:14 pm on Mar 13, 2006 (gmt 0)

Welcome to WebmasterWorld [webmasterworld.com], bsaric!

What problem are you experiencing?

Don't forget that you can't send a header [php.net] if you've already sent any output. In other words, header() must come BEFORE any echo or print statements.

FalseDawn




msg:1282220
 12:54 am on Mar 14, 2006 (gmt 0)

I think they are referring to storing special characters in mysql - look up the "mysql_real_escape_string" function

dmmh




msg:1282221
 1:21 pm on Mar 14, 2006 (gmt 0)

html_entities(mysql_real_escape_string($variable));

for echoing:

html_entity_decode(stripslashes($variable));

bsaric




msg:1282222
 3:12 pm on Mar 14, 2006 (gmt 0)

yes, im talking about inserting special characters in mysql, and im trying to pull it out in my tutorials as example code, without code execution

whoisgregg




msg:1282223
 7:03 pm on Mar 14, 2006 (gmt 0)

Ahhh, now I understand. The different header code confused me into thinking it was a header problem. dmmh has the answer then, html_entities(). (Although I think that bsaric plans on displaying the actual code on the page, like in a PHP tutorial, in which case he will not need html_entity_decode().)

bsaric




msg:1282224
 7:09 pm on Mar 14, 2006 (gmt 0)

yes, im trying to do that, and i just can't find solution for this code above

whoisgregg




msg:1282225
 9:44 pm on Mar 14, 2006 (gmt 0)

html_entities() [php.net] will turn all the <,>,and every other bit of special code into it's respective html entities: &lt;, &gt;, etc.

Then you just echo the actual data you inserted into the database.

bsaric




msg:1282226
 8:22 am on Mar 15, 2006 (gmt 0)

thanks i will try :)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved