Another PHP problem

TwiztedFake · 12-24-2005, 12:07 AM

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-24-2005, 12:16 AM

put a \ infront of each special character.

Peter · 12-24-2005, 01: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, 09: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, 09:40 AM

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

12-24-2005, 12:07 AM	THREAD STARTER #1 (permalink)
TwiztedFake NamePros Regular Join Date: Apr 2004 Location: IL Posts: 348	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? __________________ -TwiztedFake- RTard Tutorials Digital-Dummy to Total-Techie

12-24-2005, 12:16 AM	#2 (permalink)
aznchong91 Senior Member Join Date: Nov 2005 Location: Hong Kong Posts: 1,154	put a \ infront of each special character. __________________ If you're as bored as I am, join me in Fallensword! (I swear, this game is actually pretty fun :P)

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 08:51 PM
Problem with PHP	monRa	Programming	15	09-12-2005 05:28 AM
local server installations, urgent help needed.	Porte	Web Hosting Discussion	1	06-23-2005 04:05 PM
PHP Problem on a website?	aal814	Web Design Discussion	1	12-29-2004 11:53 AM

12-24-2005, 01:54 AM	#3 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	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, 09:40 AM	#5 (permalink)
mch NamePros Regular Join Date: Nov 2005 Location: EU Posts: 248	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)