Method update_db_entry

models/db.php:529–555

* Update DB Entry * @param string table * @param string id * @param array fields * [ array('name' => $name, 'value' => $value) ] */

($table, $id, array $fields)

     * [ array('name' => $name, 'value' => $value) ]
     */
    public static function update_db_entry($table, $id, array $fields)
    {

        // Prepare the UPDATE SQL.
        $sql = 'UPDATE `'.$table.'` SET ';
        $field_count = count($fields);
        $params = array();
        $counter = 0;
        foreach($fields as $field){
            $counter++;
            $sql.= $field['name'].' = ?';
            if($counter !== $field_count)
                $sql.= ', ';
            $params[] = $field['value'];
        }

        // Finish up the SQL.
        $sql.= ' WHERE id = ?';
        $params[] = $id;

        // Query
        $result = self::query($sql, $params, true);
        
        // Complete Query
        return $result;
        
    }

    /**
     * Delete DB Entries