Return to Snippet

Revision: 6422
at May 20, 2008 13:24 by mattkenefick


Initial Code
<?php
/**************************************
 seesaw associates | http://seesaw.net

 client: 
 file: 
 description: 

 Copyright (C) 2008 Matt Kenefick(.com)
**************************************/
	
ini_set("memory_limit","100M");

class expandSQL{
	
	var $db;
	
	function expandSQL($db){
		$this->db = $db;
	}
	
	function expand($file){
		$sql = $this->readFile($file);
		foreach($sql as $query)
			$db->query($query);
			
		return true;
	}
	
	function readFile($filename){
		$fileExt = $this->getext($filename);
		
		if(file_exists($filename)){
			$nLines = '';
			
			switch( strtolower($fileExt) ){
				case 'gz':
					$lines = gzfile($filename);
				break;
				case 'sql':
					$lines = readfile($filename);
				break;
			 }
			 
			 foreach($lines as $line) {
				if(substr($line,1,1)!='-' && substr($line,1,1)!='')
					$nLines .= $line;
			}
			
			return split(';',$nLines);
		 }
	}

	function getext($filename){	
		$ext = split('\.',$filename);
		$ext = $ext[count($ext)-1];
		return $ext;
	}
}

?>

Initial URL

                                

Initial Description
Expands a MySQL / Gzipped file and executes it's queries.

Initial Title
PHP Class: Expand MySQL File

Initial Tags
mysql, file

Initial Language
PHP