mysql_info(3) [php man page]

MYSQL_INFO(3)								 1							     MYSQL_INFO(3)

mysql_info - Get information about the most recent query

SYNOPSIS

       Warning

	      This  extension  is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
	      be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

		     omysqli_info(3)

       string mysql_info ([resource  $link_identifier = NULL])

DESCRIPTION

	Returns detailed information about the last query.

	      o $
		link_identifier -The MySQL connection. If the link identifier is not specified,  the  last  link  opened  by  mysql_connect(3)	is
		assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
		is found or established, an E_WARNING level error is generated.

	Returns information about the statement on success, or FALSE on failure. See the example below for which statements  provide  information,
       and what the returned value may look like. Statements that are not listed will return FALSE.

       Example #1

	      Relevant MySQL Statements

	       Statements that return string values. The numbers are only for illustrating purpose; their values will correspond to the query.

	      INSERT INTO ... SELECT ...
	      String format: Records: 23 Duplicates: 0 Warnings: 0
	      INSERT INTO ... VALUES (...),(...),(...)...
	      String format: Records: 37 Duplicates: 0 Warnings: 0
	      LOAD DATA INFILE ...
	      String format: Records: 42 Deleted: 0 Skipped: 0 Warnings: 0
	      ALTER TABLE
	      String format: Records: 60 Duplicates: 0 Warnings: 0
	      UPDATE
	      String format: Rows matched: 65 Changed: 65 Warnings: 0

       Note

	      mysql_info(3)  returns  a  non-  FALSE  value  for the INSERT ... VALUES statement only if multiple value lists are specified in the
	      statement.

       mysql_affected_rows(3), mysql_insert_id(3), mysql_stat(3).

PHP Documentation Group 													     MYSQL_INFO(3)

MYSQL_CREATE_DB(3)							 1							MYSQL_CREATE_DB(3)

mysql_create_db - Create a MySQL database

SYNOPSIS

       Warning

	      This  function  was deprecated in PHP 4.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
	      sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide  and  related  FAQ  for  more
	      information. Alternatives to this function include:

		     omysqli_query(3)

		     o PDO::query

       bool mysql_create_db (string  $database_name, [resource	$link_identifier = NULL])

DESCRIPTION

       mysql_create_db(3) attempts to create a new database on the server associated with the specified link identifier.

	      o $database_name
		- The name of the database being created.

	      o $
		link_identifier  -The  MySQL  connection.  If  the  link  identifier is not specified, the last link opened by mysql_connect(3) is
		assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
		is found or established, an E_WARNING level error is generated.

	Returns TRUE on success or FALSE on failure.

       Example #1

	      mysql_create_db(3) alternative example

	       The  function  mysql_create_db(3)  is  deprecated. It is preferable to use mysql_query(3) to issue an sql CREATE DATABASE statement
	      instead.

	      <?php
	      $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }

	      $sql = 'CREATE DATABASE my_db';
	      if (mysql_query($sql, $link)) {
		  echo "Database my_db created successfully
";
	      } else {
		  echo 'Error creating database: ' . mysql_error() . "
";
	      }
	      ?>

	      The above example will output something similar to:

	      Database my_db created successfully

       Note

	       For backward compatibility, the following deprecated alias may be used: mysql_createdb(3)

       Note

	       This function will not be available if the MySQL extension was built against a MySQL 4.x client library.

       mysql_query(3), mysql_select_db(3).

PHP Documentation Group 													MYSQL_CREATE_DB(3)