homepage Welcome to WebmasterWorld Guest from 54.166.122.65
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
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

5+ Year Member



 
Msg#: 12101 posted 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

WebmasterWorld Senior Member whoisgregg us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 12101 posted 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

5+ Year Member



 
Msg#: 12101 posted 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

10+ Year Member



 
Msg#: 12101 posted 1:21 pm on Mar 14, 2006 (gmt 0)

html_entities(mysql_real_escape_string($variable));

for echoing:

html_entity_decode(stripslashes($variable));

bsaric

5+ Year Member



 
Msg#: 12101 posted 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

WebmasterWorld Senior Member whoisgregg us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 12101 posted 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

5+ Year Member



 
Msg#: 12101 posted 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

WebmasterWorld Senior Member whoisgregg us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 12101 posted 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

5+ Year Member



 
Msg#: 12101 posted 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