Update JSON column

[nelson906]

Hi
I had to work with a JSON column, so I modified your update just to work with JSON_REPLACE.
I am using locally not to touch Database.php
This is the function

// update JSON column
function updateJSON($table, $column, $data, $where)
{
//collect the values from data and where
$values = [];

   //setup fields
    $fieldDetails = null;
    foreach ($data as $key => $value) {
        $fieldDetails .= " $key, ?,";
        $values[] = $value;
    }
    $fieldDetails = rtrim($fieldDetails, ',');

    //setup where
    $whereDetails = null;
    $i = 0;
    foreach ($where as $key => $value) {
        $whereDetails .= $i == 0 ? "$key = ?" : " AND $key = ?";
        $values[] = $value;
        $i++;
    }

    $stmt = $this->run("UPDATE $table SET $column = JSON_REPLACE($column, $fieldDetails)  WHERE $whereDetails", $values);

    return $stmt->rowCount();
}

The only differences: the need of a column in the arguments and the comma instead of = in the fileDetails

[nelson906]

I forgot the data format
$data = [
'$.employer.firstName' => 'Joe',
'$.employer.lastnName' => 'Smith',
'$.employer.email' => 'someone@domain.com'
];
$where = ['id' => 2];
$db->update('users', $column, $data, $where);