Example #1
0
 public function update()
 {
     $properties = get_object_vars($this);
     $columns = array_keys($properties);
     $places = [];
     $data = [];
     foreach ($columns as $property) {
         $places[] = '`' . $property . '` = :' . $property;
         $data[':' . $property] = $this->{$property};
     }
     $data[':id'] = Application::getCurrentByKey('pageid');
     $sql = 'UPDATE `' . static::getTable() . '` SET ' . implode(', ', $places) . ' WHERE `id` = :id';
     $db = new Db();
     $db->dbExecute($sql, $data);
 }