Another PHP problem

TwiztedFake · 12-23-2005, 11:07 PM

I'm writing my first major site using a database and php. Of course I keep running into things I don't know yet. So here is my latest problem. I'm working on an article submission and get an error anytime there is a ' , " : ; and other common punction. I know I need to do something in the processing part of the code.

Help please?

aznchong91 · 12-23-2005, 11:16 PM

put a \ infront of each special character.

Peter · 12-24-2005, 12:54 AM

if the error is occuring when you try and input them into the database you can use mysql_real_escape_string() if you are using mysql (there are similar functions for other databases)

In addition if the string is to be displayed on a web page then you could also run it through htmlentities() which will stop the browser processing any html instead of displaying it.

TwiztedFake · 12-24-2005, 08:14 AM

Quote:

put a \ infront of each special character.

That doesn't solve the problem when I'm using an input field that members will be able to write in. I use that in my hard coding of course to take care of situtaions like I stated on my side. I can't expect members of my site to put \ in front on all special characters when the type up an article.

Quote:

if the error is occuring when you try and input them into the database you can use mysql_real_escape_string() if you are using mysql (there are similar functions for other databases)

Thats what I was thinking but thought there might be a better way of doing it. Thanks for the help guys.

mch · 12-24-2005, 08:40 AM

Yeah you just need to escape the string or convert those characters to XHTML entities.

12-23-2005, 11:07 PM	#1 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 339 50.00 NP$ (Donate)	Another PHP problem I'm writing my first major site using a database and php. Of course I keep running into things I don't know yet. So here is my latest problem. I'm working on an article submission and get an error anytime there is a ' , " : ; and other common punction. I know I need to do something in the processing part of the code. Help please? __________________ Four Seasons Outfitters [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month ] [ 25 $NP/Month] [ 25 $NP/Month]

12-23-2005, 11:16 PM	#2 (permalink)
aznchong91 Senior Member Join Date: Nov 2005 Location: Hong Kong Posts: 1,150 2,523.40 NP$ (Donate)	put a \ infront of each special character. __________________ ----------------------------------------------------- \|-----FREE BANNER EXCHANGE! 1:1 RATIO!!!!-----\| \|-------------www.bannercenter.info-------------\| -----------------------------------------------------

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Annual Christmas Sale @ Erudnet \| Hot Deals \| PHP 5 HOSTING!	iNod	Web Hosting Offers	0	12-01-2005 07:51 PM
Problem with PHP	monRa	Programming	15	09-12-2005 04:28 AM
local server installations, urgent help needed.	Porte	Web Hosting Discussion	1	06-23-2005 03:05 PM
PHP Problem on a website?	aal814	Web Design Discussion	1	12-29-2004 10:53 AM

12-24-2005, 12:54 AM	#3 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	if the error is occuring when you try and input them into the database you can use mysql_real_escape_string() if you are using mysql (there are similar functions for other databases) In addition if the string is to be displayed on a web page then you could also run it through htmlentities() which will stop the browser processing any html instead of displaying it.

12-24-2005, 08:40 AM	#5 (permalink)
mch NamePros Regular Join Date: Nov 2005 Location: EU Posts: 248 99.25 NP$ (Donate)	Yeah you just need to escape the string or convert those characters to XHTML entities.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)