Why do I get a \ in front of '
01-15-04, 02:59 PM
Coding Addict
Join Date: Jan 2004
Posts: 267
Thanks: 0
Thanked 0 Times in 0 Posts
Why do I get a \ in front of '
I'm using a small admin system to insert text to a table (Type : TEXT) and when I use ' symbol I get a \ in ront of it.
Anyway to avoid this.
Do\'s dont\'s
Update Script
PHP Code:
<?php
// Connect to database
$link = mysql_connect ( 'localhost' , 'user' , 'password' )
"Could not connect" );
mysql_select_db ( 'select_db' )
"Could not select database" );
//Set the Sort method for the sort=name? function - default on name
if (isset( $_GET [ 'club' ]))
$club = $_GET [ 'club' ];
$club = '' ;
//Query function ( Must be here)
$result = mysql_query ( "SELECT * FROM `central` WHERE 1 AND `name` LIKE ' $club ' LIMIT 0 , 30" )
mysql_error ());
$single = mysql_fetch_assoc ( $result );
$submitted = date ( "d/m/Y H:i:s" );
$_POST [ 'submit' ])) {
'<BODY bgColor=#155271 leftMargin=0 topMargin=0 rightMargin=0 bottomMargin=0 marginwidth="0" marginheight="0" onLoad="MM_preloadImages(\'guestlistOver.jpg\',\'mapOver.jpg\',\'galleryOver.jpg\',\'writeOver.jpg\')">
, $single [ 'thumb' ], '" width=109 border=0></TD>
, $single [ 'name' ], '<br>
, $single [ 'address' ], ')</span><br>
, $single [ 'description' ], '</span></p>
, $single [ 'tube' ], '</TD>
, $single [ 'times' ], '</TD>
, $single [ 'tel' ], '</TD>
, $single [ 'capacity' ], '</TD>
, $single [ 'rate' ], '.gif" alt="' , $single [ 'rate' ], ' Rating" width="109" height="20"></TD>
, $single [ 'name' ], '" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage(\'Guestlist\',\'\',\'guestlistOver.jpg\',1)"><img src="guestlist.jpg" alt="Guestlist" name="Guestlist" width="109" height="20" border="0"></a></TD>
, $single [ 'map' ], '" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage(\'Map\',\'\',\'mapOver.jpg\',1)"><img src="map.jpg" alt="Map" name="Map" width="109" height="20" border="0"></a></TD>
, $single [ 'gallery' ], '" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage(\'Gallery\',\'\',\'galleryOver.jpg\',1)"><img src="gallery.jpg" alt="Gallery" name="Gallery" width="109" height="20" border="0"></a></TD>
. $_SERVER [ 'PHP_SELF' ]. '">
, $single [ 'name' ], '">
. $submitted . '">
;
?>
<?PHP
echo ' </td>
;
$idClub = trim ( addslashes ( $_POST [ 'idClub' ]));
$submitted = trim ( addslashes ( $_POST [ 'submitted' ]));
$comments = trim ( addslashes ( $_POST [ 'comments' ]));
$authorName = trim ( addslashes ( $_POST [ 'authorName' ]));
$location = trim ( addslashes ( $_POST [ 'location' ]));
$authorRating = trim ( addslashes ( $_POST [ 'authorRating' ]));
$insert = mysql_query ( "INSERT INTO comments (idClub, comments, authorName, location, authorRating, submitted) VALUES (' $idClub ', ' $comments ', ' $authorName ', ' $location ', ' $authorRating ', ' $submitted ')" )or
'couldn\'t Insert record into Comments database :' . mysql_error ());
'<meta http-equiv=\'refresh\' content=\'1; url=http://www.selectguestlist.com/index/comments.php?club=' . $idClub . '\'>' ;
?>
01-15-04, 03:04 PM
Coding Addict
Join Date: Dec 2003
Posts: 307
Thanks: 0
Thanked 0 Times in 0 Posts
Its because ' is a special character in PHP. cuz you can use '' in echos
01-16-04, 04:23 AM
New Member
Join Date: Jun 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
this is because you have magic quotes enabled.
__________________
WEBSITES:
- Nick
01-16-04, 10:20 AM
Community VIP
Join Date: Oct 2003
Location: Chicago, IL
Posts: 2,167
Thanks: 3
Thanked 8 Times in 8 Posts
It may be easier to use the stripslash function:
Quote:
Originally Posted by Nick
this is because you have magic quotes enabled.
01-25-04, 01:35 PM
Coding Addict
Join Date: Jan 2004
Posts: 267
Thanks: 0
Thanked 0 Times in 0 Posts
Do I just place that on the php script?
01-25-04, 02:58 PM
Community VIP
Join Date: Aug 2003
Location: K.S.A
Posts: 2,257
Thanks: 0
Thanked 2 Times in 1 Post
where ever you used addslashes when you wanted to insert a string into database, now use stripslashes when you want to echo/print it:
__________________
PHPSimplicity FF9 ]
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes
Linear Mode
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
Linear Mode
