db_escape.test.php at db_escape

<!-- GOD, I hope these come out better looking for downloads -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>

<BODY BGCOLOR="#FFFFFF">

<?php
include( "db_escape.class.php" );

$string_for_database = "
\"
'
And                          AND         &  
Or                           OR          |  
Accumulate                   ACCUM       ,  
Minus                        MINUS       -  
Near                         (none)      ;  
Stem                         (none)      $  
Soundex                      (none)      !  
Fuzzy                        (none)      ?  
Threshold                    (none)      >  
Weight                       (none)      *  
First/Next                   (none)      #  
Max                          (none)      :  
Wildcard (multiple)          (none)      %  
Wildcard (single)            (none)      _  
Grouping (parentheses)       (none)     ( )  
Grouping (brackets)          (none)     [ ]  
Escape (multiple characters) (none)     { }  
Escape (single character)    (none)     \\  
PL/SQL call EXECUTE          EXEC       @  
Stored Query Expression      SQE        (none)  
Synonym                      SYN        (none) 
Preferred                    PT         (none) 
Related                      RT         (none)  
Top                          TT         (none)  
Broader                      BT         (none)  
Narrower                     NT         (none)  
Broader Generic              BTG        (none)  
Narrower Generic             NTG        (none)  
Broader Partitive            BTP        (none)  
Narrower Partitive           NTP        (none)
'fred' is \"dead\"
";

$escaper = new db_escape;

echo( "<PRE><br>\n" . $string_for_database . "<br>\n<br>\n<br>\n</PRE>");
if ( !$escaper->Esc_DB_Str( $string_for_database, "ORACLE-MED" ) ){
  echo("BAD escaping!!");
} else {
  echo( "<PRE><br>\n" . $string_for_database . "<br>\n<br>\n</PRE><br>\n");
}

if ( !$escaper->Unesc_DB_Str( $string_for_database, "ORACLE-MED" ) ){
  echo("BAD escaping!!");
} else {
  echo( "<PRE><br>\n" . $string_for_database . "<br>\n<br>\n<br>\n</PRE>");
}

?>
</BODY>
</HTML>}