Method add_db_entry

models/db.php:430–467

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

($table, array $fields)

     * [ array('name' => $name, 'value' => $value) ]
     */
    public static function add_db_entry($table, array $fields)
    {
        
        // We're going to use the field count a few times,
        // so let's create the variable first.
        $field_count = count($fields);

        // Let's reformat fields into something easier for
        // MySQL to deal with.
        $field_names = ''; 
        $field_values = array();
        if(!empty($fields)){
            $counter = 0; 
            foreach($fields as $field){
                $counter++;
                $field_names.= '`'.$field['name'].'`';
                if($counter !== $field_count)
                    $field_names.= ', ';
                array_push($field_values, $field['value']);
            }
        }

        // Prepare the SQL.
        $sql = 'INSERT INTO `'.$table.'` ('.$field_names.') ';
        $sql.= 'VALUES ('.str_repeat('?, ', $field_count).')';
        $sql = str_replace(', )', ')', $sql);
        
        // Query
        $result = self::query($sql, $field_values, false);

        // Fallback
        if(!$result)
            throw new Exception('Cannot add DB entry');
        
        // Complete Query
        return $result;
        
    }

    /**
     * Add DB Rows