MySQL output to PHP page showing a backslash

Question

I have a form that asks for a name. The php to process it is:

$name = mysqli_real_escape_string($dbc, trim($_POST['name']));

When someone inserts a name with an apostrophe e.g. Dan O'Shea it shows up in the mysql database fine, but on the webpage it's output shows up as Dan O\Shea.

How do I get rid of the \ backslash and show the ' apostrophe on the webpage? Can I use str_replace('/','', $string) with mysqli_real_escape_string, and if so how?

Thanks for any help,

Andy ;-)

joaofgf · Accepted Answer · 2014-06-25 19:40:33Z

1

use stripslashes() to remove extra backslashes.

answered Jun 25, 2014 at 19:40

joaofgf

3481 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Andy R Over a year ago

Thanks joaofgf, is that with or without the mysqli_real_escape_string?

joaofgf Over a year ago

with mysqli_real_escape_string()

Zerquix18 Over a year ago

@AndyR Use it when you're showing the data in the page. stripslashes($row['name']);

Andy R Over a year ago

Hi Zerquix18 and joaofgf, when using the localhost I don't have the problem, it's only on a free hosting account that it occurs. So are they being extra cautious or what?

joaofgf Over a year ago

your hosting provider has gpc_magic_quotes enabled and your local server doesn't.

Andy Lester · Accepted Answer · 2014-06-25 19:42:43Z

0

Sounds like you have gpc_magic_quotes turned on.

http://php.net/manual/en/security.magicquotes.php

answered Jun 25, 2014 at 19:42

Andy Lester

94.2k16 gold badges106 silver badges162 bronze badges

2 Comments

Andy R Over a year ago

Thanks Andy. The problem is not on my localhost - it works fine there. The problem seems to arise only when I put the code up on a free hosting provider. Eventually I will go with paid hosting once the site is complete, I am just testing and found this problem. Is this common? Thanks again Andy ;-)

Andy Lester Over a year ago

I don't know how common things may be. I only work with servers that I admin directly.

Collectives™ on Stack Overflow

MySQL output to PHP page showing a backslash

2 Answers 2

5 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related