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_LIST_FIELDS(3)							 1						      MYSQL_LIST_FIELDS(3)

mysql_list_fields - List MySQL table fields

SYNOPSIS

       Warning

	      This  function  was deprecated in PHP 5.4.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:

		     oSQL Query:
		       SHOW COLUMNS FROM sometable

       resource mysql_list_fields (string  $database_name, string  $table_name, [resource  $link_identifier = NULL])

DESCRIPTION

	Retrieves information about the given table name.

	This  function	is  deprecated.  It  is  preferable  to use mysql_query(3) to issue an SQL SHOW COLUMNS FROM table [LIKE 'name'] statement
       instead.

	      o $database_name
		- The name of the database that's being queried.

	      o $table_name
		- The name of the table that's being queried.

	      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.

	A result pointer resource on success, or FALSE on failure.

	The returned result can be used with mysql_field_flags(3), mysql_field_len(3), mysql_field_name(3) and mysql_field_type(3).

       Example #1

	      Alternate to deprecated mysql_list_fields(3)

	      <?php
	      $result = mysql_query("SHOW COLUMNS FROM sometable");
	      if (!$result) {
		  echo 'Could not run query: ' . mysql_error();
		  exit;
	      }
	      if (mysql_num_rows($result) > 0) {
		  while ($row = mysql_fetch_assoc($result)) {
		      print_r($row);
		  }
	      }
	      ?>

	      The above example will output something similar to:

	      Array
	      (
		  [Field] => id
		  [Type] => int(7)
		  [Null] =>
		  [Key] => PRI
		  [Default] =>
		  [Extra] => auto_increment
	      )
	      Array
	      (
		  [Field] => email
		  [Type] => varchar(100)
		  [Null] =>
		  [Key] =>
		  [Default] =>
		  [Extra] =>
	      )

       Note

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

       mysql_field_flags(3), mysql_info(3).

PHP Documentation Group 												      MYSQL_LIST_FIELDS(3)