sky(6) [debian man page]

SKY(6)								   Games Manual 							    SKY(6)

NAME

       sky - science fiction adventure game

DESCRIPTION

       A  science-fiction  thriller  set in a bleak post-apocalyptic vision of the future, Beneath a Steel Sky revolves around "Union City", where
       selfishness, rivalry, and corruption by its citizens seems to be all too common, those who can afford it live underground,  away  from  the
       pollution and social problems which are plaguing the city.

       You  take  on  the  role  of Robert Foster, an outcast of sorts from the city since a boy who was raised in a remote environment outside of
       Union City simply termed "the gap".  Robert's mother took him away from Union City as a child on their way to "Hobart" but  the	helicopter
       crashed on its way, unfortunately Robert's mother dies, but he survives and is left to be raised by a local tribe from the gap.

       Years  later, Union City security drops by and abducts Robert, killing his tribe in the process; upon reaching the city the helicopter tak-
       ing him there crashes with him escaping, high upon a tower block in the middle of the city he sets out to  discover  the  truth	about  his
       past, and to seek vengeance for the killing of his tribe.

OPTIONS

       --help Display help for the command

       --version
	      Display version and author information

HISTORY

       Jul 10 2004: First version of this manual page.

AUTHOR

       This manual page was written by Tore Anderson <tore@debian.org> for the Debian GNU system (but may be used by others).

Tore Anderson							   Jul 10, 2004 							    SKY(6)

MYSQLI_REAL_ESCAPE_STRING(3)						 1					      MYSQLI_REAL_ESCAPE_STRING(3)

mysqli::real_escape_string  -  Escapes	special characters in a string for use in an SQL statement, taking into account the current charset of the
connection

       Object oriented style

SYNOPSIS

       string mysqli::escape_string (string  $escapestr)

DESCRIPTION

       string mysqli::real_escape_string (string  $escapestr)

       Procedural style
       string mysqli_real_escape_string (mysqli  $link, string	$escapestr)

	This function is used to create a legal SQL string that you can use in an SQL statement. The given string is encoded  to  an  escaped  SQL
       string, taking into account the current character set of the connection.

       Caution

	      Security: the default character set

	       The  character  set  must  be  set  either  at  the  server  level, or with the API function mysqli_set_charset(3) for it to affect
	      mysqli_real_escape_string(3). See the concepts section on character sets for more information.

PARAMETERS

	      o $
		link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)

	      o $escapestr
		- The string to be escaped.  Characters encoded are NUL (ASCII 0), 
, 
, , ', ", and Control-Z.

RETURN VALUES

	Returns an escaped string.

EXAMPLES

       Example #1

	      mysqli::real_escape_string example

	      Object oriented style

	      <?php
	      $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

	      /* check connection */
	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      $mysqli->query("CREATE TEMPORARY TABLE myCity LIKE City");

	      $city = "'s Hertogenbosch";

	      /* this query will fail, cause we didn't escape $city */
	      if (!$mysqli->query("INSERT into myCity (Name) VALUES ('$city')")) {
		  printf("Error: %s
", $mysqli->sqlstate);
	      }

	      $city = $mysqli->real_escape_string($city);

	      /* this query with escaped $city will work */
	      if ($mysqli->query("INSERT into myCity (Name) VALUES ('$city')")) {
		  printf("%d Row inserted.
", $mysqli->affected_rows);
	      }

	      $mysqli->close();
	      ?>

	      Procedural style

	      <?php
	      $link = mysqli_connect("localhost", "my_user", "my_password", "world");

	      /* check connection */
	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      mysqli_query($link, "CREATE TEMPORARY TABLE myCity LIKE City");

	      $city = "'s Hertogenbosch";

	      /* this query will fail, cause we didn't escape $city */
	      if (!mysqli_query($link, "INSERT into myCity (Name) VALUES ('$city')")) {
		  printf("Error: %s
", mysqli_sqlstate($link));
	      }

	      $city = mysqli_real_escape_string($link, $city);

	      /* this query with escaped $city will work */
	      if (mysqli_query($link, "INSERT into myCity (Name) VALUES ('$city')")) {
		  printf("%d Row inserted.
", mysqli_affected_rows($link));
	      }

	      mysqli_close($link);
	      ?>

	      The above examples will output:

	      Error: 42000
	      1 Row inserted.

NOTES

       Note

	       For those accustomed to using mysql_real_escape_string(3), note that the arguments of mysqli_real_escape_string(3) differ from what
	      mysql_real_escape_string(3)  expects.  The  $link  identifier  comes first in mysqli_real_escape_string(3), whereas the string to be
	      escaped comes first in mysql_real_escape_string(3).

SEE ALSO

       mysqli_set_charset(3), mysqli_character_set_name(3).

PHP Documentation Group 											      MYSQLI_REAL_ESCAPE_STRING(3)