PHP Class: Expand MySQL File


/ Published in: PHP
Save to your folder(s)

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


Copy this code and paste it in your HTML
  1. <?php
  2. /**************************************
  3.  seesaw associates | http://seesaw.net
  4.  
  5.  client:
  6.  file:
  7.  description:
  8.  
  9.  Copyright (C) 2008 Matt Kenefick(.com)
  10. **************************************/
  11.  
  12. ini_set("memory_limit","100M");
  13.  
  14. class expandSQL{
  15.  
  16. var $db;
  17.  
  18. function expandSQL($db){
  19. $this->db = $db;
  20. }
  21.  
  22. function expand($file){
  23. $sql = $this->readFile($file);
  24. foreach($sql as $query)
  25. $db->query($query);
  26.  
  27. return true;
  28. }
  29.  
  30. function readFile($filename){
  31. $fileExt = $this->getext($filename);
  32.  
  33. if(file_exists($filename)){
  34. $nLines = '';
  35.  
  36. switch( strtolower($fileExt) ){
  37. case 'gz':
  38. $lines = gzfile($filename);
  39. break;
  40. case 'sql':
  41. $lines = readfile($filename);
  42. break;
  43. }
  44.  
  45. foreach($lines as $line) {
  46. if(substr($line,1,1)!='-' && substr($line,1,1)!='')
  47. $nLines .= $line;
  48. }
  49.  
  50. return split(';',$nLines);
  51. }
  52. }
  53.  
  54. function getext($filename){
  55. $ext = split('\.',$filename);
  56. $ext = $ext[count($ext)-1];
  57. return $ext;
  58. }
  59. }
  60.  
  61. ?>

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.