Query: ingres_escape_string
OS: php
Section: 3
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
INGRES_ESCAPE_STRING(3) 1 INGRES_ESCAPE_STRING(3) ingres_escape_string - Escape special characters for use in a querySYNOPSISstring ingres_escape_string (resource $link, string $source_string)DESCRIPTIONingres_escape_string(3) is used to escape certain characters within a string before it is sent to the database server.PARAMETERSo $link - The connection link identifier o $source_string - The source string to be parsedRETURN VALUESReturns a string containing the escaped data.EXAMPLESExample #1 Escape special characters for use in a query <?php $link = ingres_connect($database, $user, $password); $last_name = "O'Connor"; $sql = sprintf("select * from user_profile where up_last = '%s'", ingres_escape_string( $link, $last_name)); $result = ingres_query($link, $sql); while ($user = ingres_fetch_object($result)) { echo $user->up_first . '<BR/>'; } ingres_commit($link); ingres_close($link); ?>SEE ALSOingres_query(3). PHP Documentation Group INGRES_ESCAPE_STRING(3)