3v4l.org

run code in 300+ PHP versions simultaneously

@ 2018-05-09T06:10:20Z

<?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';
        }

array_intersect_key: documentation ( source)
str_repeat: documentation ( source)
array_values: documentation ( source)
array_flip: documentation ( source)
implode: documentation ( source)
array_pop: documentation ( source)

preferences:dark modelive previewkey bindings

29.06 ms | 410 KiB | 5 Q