php - array_walk_recursive 和 mysqli::real_escape_string 出错

Question

我的 mysql 连接使用面向对象的风格，但是如果我这样写:

array_walk_recursive($_POST, array($mysqli, 'real_escape_string'));

我收到这个错误:

Warning: mysqli::real_escape_string() expects exactly 1 parameter, 2 given

事实是mysqli::escape_string接受只有1个参数:

string mysqli::escape_string ( string $escapestr )

---

我写:

$VAR = array();
$VAR = $_POST;

function escape_string($item, $key) {
    $arr[$key] = $mysqli->real_escape_string($item);
}

array_walk_recursive($VAR, 'escape_string');

我得到这个错误:

Fatal error: Call to a member function real_escape_string() on a non-object

Answer 1

你需要传递一个字符串作为第二个参数，而不是数组:

function escape_string($item, $key) {
    // Echo them out (using procedural mysqli)
    echo mysqli_real_escape_string($item);
    // or collect them in an array (using OOP mysqli)
    $arr[$key] = $mysqli->real_escape_string($item);
}

array_walk_recursive($_POST, 'escape_string');