fbsql_list_fields(3) [php man page]

FBSQL_LIST_FIELDS(3)							 1						      FBSQL_LIST_FIELDS(3)

fbsql_list_fields - List FrontBase result fields

SYNOPSIS

       resource fbsql_list_fields (string  $database_name, string  $table_name, [resource  $link_identifier])

DESCRIPTION

	Retrieves information about the given table.

PARAMETERS

	      o $database_name
		- The database name.

	      o $table_name
		- The table name.

	      o $
		link_identifier  -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
		function will try to find an open link to the FrontBase server and if no such link is found it	will  try  to  create  one  as	if
		fbsql_connect(3) was called with no arguments.

RETURN VALUES

	Returns a result pointer which can be used with the fbsql_field_xxx functions, or FALSE on error.

ERRORS
/EXCEPTIONS
	A  string  describing  the  error will be placed in $phperrmsg, and unless the function was called as @fbsql() then this error string will
       also be printed out.

EXAMPLES

       Example #1

	      fbsql_list_fields(3) example

	      <?php
	      $link = fbsql_connect('localhost', 'myname', 'secret');

	      $fields = fbsql_list_fields("database1", "table1", $link);
	      $columns = fbsql_num_fields($fields);

	      for ($i = 0; $i < $columns; $i++) {
		  echo fbsql_field_name($fields, $i) . "
";;
	      }
	      ?>

	      The above example will output something similar to:

	      field1
	      field2
	      field3

SEE ALSO

       fbsql_field_len(3), fbsql_field_name(3), fbsql_field_type(3), fbsql_field_flags(3).

PHP Documentation Group 												      FBSQL_LIST_FIELDS(3)

MYSQL_DROP_DB(3)							 1							  MYSQL_DROP_DB(3)

mysql_drop_db - Drop (delete) 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:

		     oExecute a
		       DROP DATABASE query

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

DESCRIPTION

       mysql_drop_db(3)  attempts to drop (remove) an entire database from the server associated with the specified link identifier. This function
       is deprecated, it is preferable to use mysql_query(3) to issue an sql DROP DATABASE statement instead.

	      o $database_name
		- The name of the database that will be deleted.

	      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_drop_db(3) alternative example

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

	      $sql = 'DROP DATABASE my_db';
	      if (mysql_query($sql, $link)) {
		  echo "Database my_db was successfully dropped
";
	      } else {
		  echo 'Error dropping database: ' . mysql_error() . "
";
	      }
	      ?>

       Warning

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

       Note

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

       mysql_query(3).

PHP Documentation Group 													  MYSQL_DROP_DB(3)