Posted By

mattkenefick on 05/20/08

Tagged

mysql
file

Versions (?)

Last Edited at 05/20/08 01:24pm

Statistics

Viewed 671 times

Favorited by 0 user(s)

Related snippets

PHP Class: Expand MySQL File

/ Published in: PHP

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

Highlighted TextExpand

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

client: 
 file: 
 description:

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;
	}
}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.