for循环查询mysql,使用for循环构建数据库查询

I've made a function to query the database. This function takes an array, the id of the user I want to update

and a query operation.

if the query operation is UPDATE

if you look at the code below, would this be a good coding practice or is this bad code?

public function query($column, $search_value, $query_operation = "SELECT"){

if(strtoupper($query_operation == "UPDATE")){

$query = "UPDATE users SET ";

if(is_array($column)){

$counter = 1;

foreach($column as $key => $value){

if($counter < count($column)){

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

}else{

$query .= $key . ' = ? ';

}

$counter++;

}

$query .= "WHERE id =