Why Triple Slashes Still ?

d-woo

In one of my PHP guestbooks I have a filter to remove the triple slash with a hyphen.

When visitors sign the guestbook using the hyphen, every now and then there is an entry that contains a triple slash.

Why?

adrian_quah

how abt posting the code so we may be able to better pin-point the issue 🙂

d-woo

Here is the portion of code:


# this, obviously, is not all of the code
# a form field, $comment, is a textarea field that is completed in the form
# along with other variables (indicated in code below)


#========================================
# Check and Fix Comment Content
#----------------------------------------
# To check for any < and > and change them
# to special HTML tag to prevent harm to
# the guestbook. And change newline to <BR>
# which is to support for multiple lines.
#========================================

$trans = get_html_translation_table (HTML_ENTITIES);	# get HTML_ENTITIES
$encoded = strtr ($comment, $trans);			# change it
# go down a bit to see code for line transititions
$encoded = ereg_replace("\\\'", "'", $encoded);		# replace \' to '

#========================================
# mySQL Connect and Insert 
#----------------------------------------
# Connecting to mySQL server, open database
# and insert data into tables.
#========================================

mysql_connect ("localhost", "$sqlname", "$sqlpw");	# connection mySQL
mysql_select_db("$sqldb");				# select database

$insertString = 
"INSERT INTO MessageBoardAll( fullname, email, homepage, phone, nameshow, video, theatre, rating, location, comment, date ) VALUES "  .
" ( \"$fullname\", \"$email\", \"$homepage\", \"$phone\", \"$nameshow\", \"$video\", \"$theatre\", \"$rating\", \"$location\" , \"$encoded\",\"$date\");";

mysql_query( $insertString);				# add the data to table 

#========================================
# Confirm all fields signed and Preview
#----------------------------------------
# If passed all checking, add the entry into
# database and display message and preview.
#========================================

the weird thing is that only some people's entry have the triple slash...not all...is that ISP-related, browser-related or something? 😕