Mysql Update and Replace Syntax in PHP

Question

I need to eliminate the character (") from a column in my database. I can do in mysql command line by the following command:

mysql> UPDATE tName SET colName=REPLACE(colName, '"','');

and it works perfectly. Since i need run in php, i have used the following syntax in php but it dosent work :

$sql0 = "UPDATE tName SET colName=REPLACE(colName,'"','')";
if (mysqli_query($conn, $sql0)) {
$result0 = "Unwanted Character is removed ";
} else {
$result0 = "Error Filtering is Failed: " . $sql . "<br>" .       mysqli_error($conn);
}

any Idea??

hi Raptor , thanks for your comment, I use nortpad++ and it did not tell me any thing:( — Ebi Nadian
– Ebi Nadian, Commented Jan 28, 2016 at 10:12

Budianto IP · Accepted Answer · 2016-01-28 10:05:20Z

3

Try this one instead :

$sql0 = "UPDATE tName SET colName=REPLACE(colName,'\"','')";

notice there is a back slash :)

answered Jan 28, 2016 at 10:05

Budianto IP

1,3172 gold badges17 silver badges31 bronze badges

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

Comments

Franz Gleichmann · Accepted Answer · 2016-01-28 10:05:20Z

2

you have to escape double quotes inside double-quoted strings.

$sql0 = "UPDATE tName SET colName=REPLACE(colName,'\"','')";
if (mysqli_query($conn, $sql0)) {
  $result0 = "Unwanted Character is removed ";
} else {
  $result0 = "Error Filtering is Failed: " . $sql . "<br>" . mysqli_error($conn);
}

answered Jan 28, 2016 at 10:05

Franz Gleichmann

3,6104 gold badges25 silver badges30 bronze badges

2 Comments

Budianto IP Over a year ago

Looks like we answered at the same time :)

Franz Gleichmann Over a year ago

and by the second! what a coincidence. here, have a cookie gives cookie

devpro · Accepted Answer · 2016-01-28 10:07:07Z

1

You can use quotes in REPLACE function as:

$one = '"';
$sql0 = "UPDATE tName SET colName = REPLACE(colName,'$one','')";

If you echo $sql0 result is:

UPDATE tName SET colName = REPLACE(colName,'"','')

answered Jan 28, 2016 at 10:07

devpro

16.1k3 gold badges29 silver badges39 bronze badges

Collectives™ on Stack Overflow

Mysql Update and Replace Syntax in PHP

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related