How to correctly escape array in php?

Question

I want to escape an array in php

I try to escape with addslashes function but it doesn't work

 while($row = $res->fetch_assoc()) 
    {
        $row['name']=addslashes($row['agente']); //escape ?
        $rows[] = $row;
    }

I want to escape the name of a person call 'Antonio cinà' but it doesn't work The problem is 'à'

"Escaping" is output dependant. Be less tight-lipped about what you want to accomplish, where the data originates, etc. For JSON-encoding, the charset is of significance. — mario, Jun 21 '19 at 16:07
PD of [UTF-8 all the way through](//stackoverflow.com/q/279170) — mario, Jun 21 '19 at 16:10

Vidal · Answer 1 · 2019-06-21T17:05:15.563

0

Use htmlentities() php function to escape special characters.

while($row = $res->fetch_assoc()) {
        $row['name']= htmlentities($row['agente']); //escape ?

    }

edited Jun 21 '19 at 17:05

answered Jun 21 '19 at 16:01

Vidal

1

If you're outputting to HTML, sure. – miken32 Jun 21 '19 at 16:04
I try but htmlentities clean the variable – hamid Jun 21 '19 at 16:05
I want to escape string and then convert to json all array – hamid Jun 21 '19 at 16:05

score 0 · Answer 2 · answered Jun 21 '19 at 17:00

You also use htmlspecialchars() instead of htmlentities() to escape the array string.

while($row = $res->fetch_assoc()) {
    $row['name']= htmlspecialchars($row['agente']); //escape ?
    $rows[] = $row;
}

2 Answers2