php数量变量,php – 使用一个带有可变数量输入变量的bind_param()

您可以使用

call_user_func_array函数使用可变数字或参数调用bind_param方法：

$paramNames = array('myvar1', 'myvar2', /* ... */);

$params = array();

foreach ($paramNames as $name) {

if (isset($_POST[$name]) && $_POST[$name] != '') {

$params[$name] = $_POST[$name];

}

}

if (count($params)) {

$query = 'UPDATE mytable SET ';

foreach ($params as $name => $val) {

$query .= $name.'=?,';

}

$query = substr($query, 0, -1);

$query .= 'WHERE id = ?';

$stmt = $mysqli->prepare($query);

$params = array_merge(array(str_repeat('s', count($params))), array_values($params));

call_user_func_array(array(&$stmt, 'bind_param'), $params);

}