error1001es
Новичок
PHP:
function updateColumns($table, $columns_and_values, $query, $params = null) //обновляет столбцы (любые таблицы)
{
$bindKeys = [];
foreach ($columns_and_values as $column => $value) {
$bindKeys[$column] = $column . ' = ?';
}
$stmt = $this->prepare('UPDATE ' . $table . ' SET ' . implode(',', $bindKeys) . ' WHERE ' . $query);
$i = 0;
foreach ($columns_and_values as $column => $value) {
$i++;
echo $i . '='.$value;
$stmt->bindParam($i, $value, is_int($value) ? PDO::PARAM_INT : PDO::PARAM_STR);
}
foreach ($params as $param) {
$i++;
echo $i . '='.$param;
$stmt->bindParam($i, $param, is_int($param) ? PDO::PARAM_INT : PDO::PARAM_STR);
}
$stmt->execute();
}
$conn->updateColumns('users', ['login'=>'user'], 'id = ?', [2]);