#!/usr/bin/php5
<?php
// MySQL-escape a stream or file to stdout
// $URL: https://opensvn.csie.org/TinyCollection/database/trunk/script/mysqlescape.php $
// $Author: DonQuichote $
// $Date: 2009-10-02 11:52:21 +0200 (Fri, 02 Oct 2009) $
// $Revision: 749 $

function EscapeString($strText, $blnHexValue=FALSE)
         {$strResult = '';
          for($intIndex=0; $intIndex<strlen($strText); $intIndex++):
              $strCharacter = substr($strText, $intIndex, 1);
              $intChrValue = ord($strCharacter);
              if((($intChrValue<ord(' ')) or ($intChrValue>ord('~'))) and (! in_array($intChrValue, array(10, 13)))):
                 $blnHexValue = TRUE;
                 $intIndex = strlen($strText);
              else:
                 switch($strCharacter):
                        case '\\': $strCharacter = '\\\\'; break;
                        case '\'': $strCharacter = '\'\''; break; // ANSI SQL syntax
                        case "\n": $strCharacter = '\\n'; break;
                        case "\r": $strCharacter = '\\r'; break;
                 endswitch;
                 $strResult .= $strCharacter;
              endif;
          endfor;
          if($blnHexValue):
             $strResult = '0x'; // One giant hex string
             for($intIndex=0; $intIndex<strlen($strText); $intIndex++):
                 $intChrValue = ord(substr($strText, $intIndex, 1));
                 $strHexValue = strtoupper(dechex($intChrValue));
                 if((strlen($strHexValue) % 2)==1):
                    $strHexValue = '0' . $strHexValue;
                 endif;
                 $strResult .= $strHexValue;
             endfor;
          else:
             $strResult = '\'' . $strResult . '\'';
          endif;
          return $strResult; }

$garrParameters = @getopt('f:hl:', array('file:','literal:')); // Long options are hardly supported by PHP.
$blnHexValue = FALSE;
if(array_key_exists('h', $garrParameters)):
   $blnHexValue = TRUE;
endif;
if(array_key_exists('f', $garrParameters)):
   $strInput = file_get_contents($garrParameters['f']);
elseif(array_key_exists('file', $garrParameters)):
   $strInput = file_get_contents($garrParameters['file']);
elseif(array_key_exists('l', $garrParameters)):
   $strInput = $garrParameters['l'];
elseif(array_key_exists('literal', $garrParameters)):
   $strInput = $garrParameters['literal'];
else:
   $strInput = file_get_contents('php://stdin');
endif;
echo EscapeString($strInput, $blnHexValue);
?>