mysqli_set_charset(3) [php man page]

MYSQLI_SET_CHARSET(3)							 1						     MYSQLI_SET_CHARSET(3)

mysqli::set_charset - Sets the default client character set

       Object oriented style

SYNOPSIS

       bool mysqli::set_charset (string  $charset)

DESCRIPTION

       Procedural style
       bool mysqli_set_charset (mysqli	$link, string  $charset)

	Sets the default character set to be used when sending data from and to the database server.

PARAMETERS

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

	      o $charset
		- The charset to be set as default.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

NOTES

       Note

	       To  use	this function on a Windows platform you need MySQL client library version 4.1.11 or above (for MySQL 5.0 you need 5.0.6 or
	      above).

       Note

	       This is the preferred way to change the charset. Using mysqli_query(3) to set it (such as SET NAMES utf8) is not  recommended.  See
	      the MySQL character set concepts section for more information.

EXAMPLES

       Example #1

	      mysqli::set_charset example

	      Object oriented style

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

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

	      /* change character set to utf8 */
	      if (!$mysqli->set_charset("utf8")) {
		  printf("Error loading character set utf8: %s
", $mysqli->error);
	      } else {
		  printf("Current character set: %s
", $mysqli->character_set_name());
	      }

	      $mysqli->close();
	      ?>

	      Procedural style

	      <?php
	      $link = mysqli_connect('localhost', 'my_user', 'my_password', 'test');

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

	      /* change character set to utf8 */
	      if (!mysqli_set_charset($link, "utf8")) {
		  printf("Error loading character set utf8: %s
", mysqli_error($link));
	      } else {
		  printf("Current character set: %s
", mysqli_character_set_name($link));
	      }

	      mysqli_close($link);
	      ?>

	      The above examples will output:

	      Current character set: utf8

SEE ALSO

       mysqli_character_set_name(3), mysqli_real_escape_string(3), List of character sets that MySQL supports.

PHP Documentation Group 												     MYSQLI_SET_CHARSET(3)

Check Out this Related Man Page

MYSQLI_ERROR_LIST(3)							 1						      MYSQLI_ERROR_LIST(3)

mysqli::$error_list - Returns a list of errors from the last command executed

       Object oriented style

SYNOPSIS

       array$mysqli->error_list ()

DESCRIPTION

       Procedural style
       array mysqli_error_list (mysqli	$link)

	Returns a array of errors for the most recent MySQLi function call that can succeed or fail.

PARAMETERS

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

RETURN VALUES

	A list of errors, each as an associative array containing the errno, error, and sqlstate.

EXAMPLES

       Example #1

	      $mysqli->error_list example

	      Object oriented style

	      <?php
	      $mysqli = new mysqli("localhost", "nobody", "");

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

	      if (!$mysqli->query("SET a=1")) {
		  print_r($mysqli->error_list);
	      }

	      /* close connection */
	      $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();
	      }

	      if (!mysqli_query($link, "SET a=1")) {
		  print_r(mysqli_error_list($link));
	      }

	      /* close connection */
	      mysqli_close($link);
	      ?>

	      The above examples will output:

	      Array
	      (
		  [0] => Array
		      (
			  [errno] => 1193
			  [sqlstate] => HY000
			  [error] => Unknown system variable 'a'
		      )

	      )

SEE ALSO

       mysqli_connect_errno(3), mysqli_connect_error(3), mysqli_error(3), mysqli_sqlstate(3).

PHP Documentation Group 												      MYSQLI_ERROR_LIST(3)

Linux and UNIX Man Pages

mysqli_set_charset(3) [php man page]

Check Out this Related Man Page