Method add_db_rows

models/db.php:475–520

* Add DB Rows * @param string table * @param array data * [ array($field => $value, ...) ] */

(
        $table, array $data
    )

     * [ array($field => $value, ...) ]
     */
    public static function add_db_rows(
        $table, array $data
    ){
        
        // Let's first format the field names. Note:
        // these field names should be represented in the
        // first set of rows as they are in the last.
        $field_names = implode(', ',array_keys($data[0]));  
        
        // Now we format the unprepared values.
        $values = '';
        $value_count = 0;
        foreach ($data as $datum){
            $value_count++;    
            $values.= '('.str_repeat('?, ', count(
                $datum
            ));
            $values = substr($values, 0, -2);
            $values.= ')';
            if($value_count !== count($data))
                $values.= ', ';
        }
        
        // All the values need to go into their own params.
        $value_count = 0;
        $params = array();
        foreach ($data as $datum){
            foreach($datum as $value){
                if(is_array($value)){
                    $value = serialize($value);
                }                
                array_push($params, $value);
            }
        }
        
        // Time to prepare the SQL!
        $sql = 'INSERT INTO `'.$table.'` ('.$field_names
            .') VALUES '.$values.';';

        // Let's execute the query
        $result = self::query($sql, $params, true);
        
        // And complete the query.
        return $result;

    }

    /**
     * Update DB Entry