<?php
function updater_serv($connection,$email,$servicedta)//edit υπηρεσιών
{
$allowed = array_flip(['servicename','price','price_show','id']);
//
foreach ($servicedta as $update) {
$update = array_intersect_key($update, $allowed);
$id = array_pop($update);
$values = array_values($update);
$values[] = $id;
$set = [];
foreach ($update as $field => $value) {
$set[] = "`{$field}`=:{$value}";
}
$sql = 'UPDATE services_list SET ' . implode(', ', $set). ' WHERE serviceID='.$id;
if($stmt=$connection->prepare($sql)) {
$stmt->bind_param(str_repeat("s", count($set)+1), ...$values);
$stmt->execute();
}
}
return 'update';
}
- Output for 7.1.0 - 7.1.20, 7.2.0 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.26, 8.4.1 - 8.4.13
preferences:
125.51 ms | 407 KiB | 5 Q