Location: PHPKode > scripts > MySQL Database & Model Classes > mysql-database-model-classes/agency.php
<?php

require_once('../libraries/Model.php');

/**
 * Agency table model
 */
 
class Agency_Model extends Model {

	/**
	 * Import CSV file into database
	 *
	 * @param   array   Data from CSV file
	 */
	function import($data) {
	
		if (!is_array($data))
			return false;
		
		for ($i=0; $i<count($data); $i++) {
			for ($x=0; $x<count($data[$i]); $x++)
				$data[$i][$x] = trim($this->escape($data[$i][$x]));
			$new_data[] = '('.implode(',', $data[$i]).')';
		}
		
		$new_data = implode(',', $new_data);
		
		unset($this->fields[0]);
		$fields = implode(',', $this->fields);
		
		return $this->query("INSERT INTO agency ($fields) VALUES $new_data");
	
	}

}
Return current item: MySQL Database & Model Classes