TalkPHP
 
 
Account Login
Latest Articles
» The basic usage of PHPTAL, a XML/XHTML template library for PHP
» Vulnerable methods and the areas they are commonly trusted in.
» Simple way to protect a form from bot
» The Basics On: How Session Stealing Works
» How to keep your forms from double posting data
IRC Channel
IRC Speech Bubble Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.
Associates
Associates
CSS Tutorials
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 11-10-2009, 08:51 PM   #1 (permalink)
The Acquainted
 
captainmerton's Avatar
 
Join Date: May 2009
Posts: 178
Thanks: 9
captainmerton is on a distinguished road
Default real_escape_string

I'm having issues with the way this php function works. Its worked fine on PHP5, MYSQL5 on my XP laptop. I'm using it for comment text entered into a comment form. When i handle strings like "jim's comment" or "Jim\s comment" etc it makes sure the exactly what has been entered appears in the database. However I have implemented the code onto Linux and now it goes nuts when i add comments etc it is adding in backslashes etc any idea why this would be. The code is:

PHP Code:
$this->commenttext $this->mysqli->real_escape_string($this->commenttext); 

Last edited by captainmerton : 11-11-2009 at 10:12 AM.
captainmerton is offline  
Reply With Quote
Old 11-10-2009, 09:04 PM   #2 (permalink)
The Acquainted
 
captainmerton's Avatar
 
Join Date: May 2009
Posts: 178
Thanks: 9
captainmerton is on a distinguished road
Default

I am guessing this might be character set related as they appear to differ between the two databases:

The hosted web space database server:
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8

My laptap:
character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8

Would this cause my problem and if so how do i resolve and what are the implications?
captainmerton is offline  
Reply With Quote
Old 11-11-2009, 10:13 AM   #3 (permalink)
The Acquainted
 
captainmerton's Avatar
 
Join Date: May 2009
Posts: 178
Thanks: 9
captainmerton is on a distinguished road
Default

Ignore this I'm certain this is related to Character sets in mysql so have raised a seperate thread in the mysql forum.
captainmerton is offline  
Reply With Quote
Old 03-30-2013, 07:57 AM   #4 (permalink)
The Acquainted
 
Join Date: Mar 2013
Posts: 131
Thanks: 1
caiyanfang is on a distinguished road
Default

Retro can is an work in nike free run shoes genre and music, and also cricket it only translates to the worst numbers through a score-sheet. At the lower part of the Mack Bridge Test, India's digits were dire: 0-2 inside of a four-Test series, is better than by 196 this kind of 319 runs, and get totals of 285, 261, 288 and 158 so far. This was no way the India for their perpetual scrap, advantages bouncebackability quotient, the no. 1 Test review (in that precise order through significance). On what develop into the nike free run 3 final afternoon linked with an Test, as the wickets column on line giant scoreboard eventually left of the pavilion ticked in place ominously, Sachin Tendulkar, emerges for 56, could have been playing in an increased grim 1990s. At one end of the pitch was regular posting intent of top quality. At the all, a revolving door.
caiyanfang is offline  
Reply With Quote
Old 04-07-2013, 06:35 AM   #5 (permalink)
The Visitor
 
Join Date: Apr 2013
Posts: 3
Thanks: 0
startmeng0215 is on a distinguished road
Default

The essence of the combination of Master and milk riding dual control, monks drink horde current target, FS put the ball to a point outbreak wave away, mostly due to diminishing 3 people very serious, Ice bomb talent (based on a combination of the barrier may change Netherstorm) FS to all combinations of the battle as long as milk riding are single solo Monk is holding another 2 people, if the Master to break out diablo 3 gold normal mode, milk riding cross chapter, be said that the dead, ice ring, Qiang Shen, put the ball, Ice bomb, then deep end, double storm, 2 shots, do not pay skills quasi-dead, this is indeed a personal experience, because this play milk riding do not think will be seconds, I hope that we can try to about
startmeng0215 is offline  
Reply With Quote
Old 04-11-2013, 06:46 AM   #6 (permalink)
The Contributor
 
Jack Hard's Avatar
 
Join Date: Dec 2012
Posts: 25
Thanks: 0
Jack Hard is on a distinguished road
Default

Are combinations of masters and dual control of drinking mare's milk monks empty Horde current FS put the ball when the epidemic, mainly due to a decrease of 3 people seriously pump ice talented (based on a combination combination of barriers to change Nil) OS battle of milk, while the monks have only one horse for 2, if a teacher breaks Diablo 3 milk or normal driving section, said he died rink Qian Shen, concise, ice bomb, depth, Double storm 2 shots, not paying capacity, apparently dead, truly personal experience because milk is a game of horse, I do not think there will be a second, I hope we prove
Jack Hard is offline  
Reply With Quote
Old 05-13-2013, 12:38 PM   #7 (permalink)
The Wanderer
 
programmingservices's Avatar
 
Join Date: Dec 2012
Posts: 20
Thanks: 0
programmingservices is on a distinguished road
Default

I agree like that all these basic concepts were covered very efficiently for PHP tutorial at here so; I want to thanks for sharing that.
programmingservices is offline  
Reply With Quote
Old 05-22-2013, 08:21 AM   #8 (permalink)
The Acquainted
 
Join Date: Mar 2013
Posts: 146
Thanks: 0
jersey wholesale is on a distinguished road
Default

Wholesale nfl Nike Jerseys,Jerseys For sale Cheap,Cheap NBA Jerseys,cheap Jerseys Wholesale,Wholesale NFL Jerseys,Nike nfl jerseys cheap, MLB Jerseys For Sale,MLB Jerseys For Sale, Cheap Jerseys on sale,NBA Jerseys Wholesale,Nike nfl jerseys Wholesale
__________________
nfl nike jerseys cheap ,Wholesale MLB Jerseys
MLB Jerseys For Sale,Cheap NBA Jerseys
jersey wholesale is offline  
Reply With Quote
Reply



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

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 07:16 AM.

 
     

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Inactive Reminders By Icora Web Design