Advertisement
Calgon

Userfile to Query (PHP class)

Feb 21st, 2011
761
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.06 KB | None | 0 0
  1. <?php
  2. // Written by Calg00ne.
  3.  
  4. class parser {
  5.     function process($szFile, $szTable) {
  6.         $hFile = fopen($szFile, 'r');
  7.         $szContents = fread($hFile,  filesize($szFile));
  8.         $iLineCount = substr_count($szContents, "\r\n");
  9.         $aLines = explode("\r\n", $szContents);
  10.         $szQueryFields = "";
  11.         $szQueryValues = "";
  12.  
  13.         for($i = 0; $i <= $iLineCount; $i++) {
  14.             if(strpos($aLines[$i], "=") != false) {
  15.                 for($x = 0; $x <= strpos($aLines[$i], "="); $x++) $szQueryFields .= $aLines[$i][$x];
  16.                 for($y = strpos($aLines[$i], "="); $y <= strlen($aLines[$i]); $y++) $szQueryValues .= $aLines[$i][$y];
  17.             }
  18.         }
  19.        
  20.         $szQueryFields = str_replace("=", ", ", $szQueryFields);
  21.         $szQueryValues = str_replace("=", "', '", $szQueryValues);
  22.        
  23.         $szQueryFields[strlen($szQueryFields)-2] = "";
  24.         $szQueryFields[strlen($szQueryFields)-1] = "";
  25.        
  26.         $szQueryValues[3] = "";
  27.         $szQueryValues[1] = "";
  28.         $szQueryValues[2] = "";
  29.        
  30.         fclose($hFile);
  31.        
  32.         return "INSERT INTO " . $szTable . " (" . $szQueryFields . ") VALUES(" . $szQueryValues . "');";
  33.     }
  34. }
  35. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement