get_magic_quotes_gpc(3) [php man page]

GET_MAGIC_QUOTES_GPC(3) 						 1						   GET_MAGIC_QUOTES_GPC(3)

get_magic_quotes_gpc - Gets the current configuration setting of magic_quotes_gpc

SYNOPSIS

       bool get_magic_quotes_gpc (void	)

DESCRIPTION

	Returns the current configuration setting of magic_quotes_gpc

	Keep in mind that attempting to set  magic_quotes_gpc at runtime will not work.

	For more information about magic_quotes, see this security section.

RETURN VALUES

	Returns 0 if magic_quotes_gpc is off, 1 otherwise. Or always returns FALSE as of PHP 5.4.0.

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.4.0	|						    |
       |	|						    |
       |	|  Always  returns  FALSE  because the magic quotes |
       |	| feature was removed from PHP. 		    |
       |	|						    |
       +--------+---------------------------------------------------+
EXAMPLES

       Example #1

	      get_magic_quotes_gpc(3) example

	      <?php
	      // If magic quotes are enabled
	      echo $_POST['lastname'];		   // O'reilly
	      echo addslashes($_POST['lastname']); // O\'reilly

	      // Usage across all PHP versions
	      if (get_magic_quotes_gpc()) {
		  $lastname = stripslashes($_POST['lastname']);
	      }
	      else {
		  $lastname = $_POST['lastname'];
	      }

	      // If using MySQL
	      $lastname = mysql_real_escape_string($lastname);

	      echo $lastname; // O'reilly
	      $sql = "INSERT INTO lastnames (lastname) VALUES ('$lastname')";
	      ?>

NOTES

       Note

	       If the directive  magic_quotes_sybase is ON it will completely override	magic_quotes_gpc.  So  even  when  get_magic_quotes_gpc(3)
	      returns  TRUE  neither double quotes, backslashes or NUL's will be escaped. Only single quotes will be escaped. In this case they'll
	      look like: ''

SEE ALSO

       addslashes(3), stripslashes(3), get_magic_quotes_runtime(3), ini_get(3).

PHP Documentation Group 												   GET_MAGIC_QUOTES_GPC(3)

CUBRID_QUERY(3) 							 1							   CUBRID_QUERY(3)

cubrid_query - Send a CUBRID query

SYNOPSIS

       resource cubrid_query (string  $query, [resource  $conn_identifier])

DESCRIPTION

       cubrid_query(3)	sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated
       with the specified $conn_identifier.

PARAMETERS

	      o $query
		- An SQL query	Data inside the query should be properly escaped.

	      o $conn_identifier
		- The CUBRID connection. If the connection identifier is not  specified,  the  last  connection  opened  by  cubrid_connect(3)	is
		assumed.

RETURN VALUES

	For  SELECT,  SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, cubrid_query(3) returns a resource on success, or FALSE on
       error.

	For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, cubrid_query(3) returns TRUE on success or FALSE on error.

	The returned result resource should be passed to cubrid_fetch_array(3), and other functions for dealing with result tables, to access  the
       returned data.

	Use cubrid_num_rows(3) to find out how many rows were returned for a SELECT statement or cubrid_affected_rows(3) to find out how many rows
       were affected by a DELETE, INSERT, REPLACE, or UPDATE statement.

       cubrid_query(3) will also fail and return FALSE if the user does not have permission to access the table(s) referenced by the query.

EXAMPLES

       Example #1

	      Invalid Query

	       The following query is syntactically invalid, so cubrid_query(3) fails and returns FALSE.

	      <?php
	      $conn = cubrid_connect('localhost', 33000, 'demodb');

	      $result = cubrid_query('SELECT * WHERE 1=1');
	      if (!$result) {
		  die('Invalid query: ' . cubrid_error());
	      }

	      ?>

       Example #2

	      Valid Query

	       The following query is valid, so cubrid_query(3) returns a resource.

	      <?php
	      // This could be supplied by a user, for example
	      $firstname = 'fred';
	      $lastname  = 'fox';

	      $conn = cubrid_connect('localhost', 33000, 'demodb');

	      cubrid_execute($conn,"DROP TABLE if exists friends");
	      cubrid_execute($conn,"create table friends(firstname varchar,lastname varchar,address char(24),age int)");
	      cubrid_execute($conn,"insert into friends values('fred','fox','home-1','20')");
	      cubrid_execute($conn,"insert into friends values('blue','cat','home-2','21')");
	      // Formulate Query
	      // This is the best way to perform an SQL query
	      // For more examples, see cubrid_real_escape_string()
	      $query = sprintf("SELECT firstname, lastname, address, age FROM friends WHERE firstname='%s' AND lastname='%s'",
	      cubrid_real_escape_string($firstname),
	      cubrid_real_escape_string($lastname));

	      // Perform Query
	      $result = cubrid_query($query);

	      // Check result
	      // This shows the actual query sent to CUBRID, and the error. Useful for debugging.
	      if (!$result) {
		  $message  = 'Invalid query: ' . cubrid_error() . "
";
		  $message .= 'Whole query: ' . $query;
		  die($message);
	      }

	      // Use result
	      // Attempting to print $result won't allow access to information in the resource
	      // One of the cubrid result functions must be used
	      // See also cubrid_result(), cubrid_fetch_array(), cubrid_fetch_row(), etc.
	      while ($row = cubrid_fetch_assoc($result)) {
		  echo $row['firstname'];
		  echo $row['lastname'];
		  echo $row['address'];
		  echo $row['age'];
	      }

	      // Free the resources associated with the result set
	      // This is done automatically at the end of the script
	      cubrid_free_result($result);
	      ?>

SEE ALSO

       cubrid_connect(3), cubrid_error(3), cubrid_real_escape_string(3), cubrid_result(3), cubrid_fetch_assoc(3), cubrid_unbuffered_query(3).

PHP Documentation Group 													   CUBRID_QUERY(3)