Book/fbsql-Phpdoc专题

FrontBase

简介
安装／配置
预定义常量
FrontBase 函数
- fbsql_affected_rows — Get number of affected rows in previous FrontBase operation
- fbsql_autocommit — Enable or disable autocommit
- fbsql_blob_size — Get the size of a BLOB
- fbsql_change_user — Change logged in user of the active connection
- fbsql_clob_size — Get the size of a CLOB
- fbsql_close — Close FrontBase connection
- fbsql_commit — Commits a transaction to the database
- fbsql_connect — Open a connection to a FrontBase Server
- fbsql_create_blob — Create a BLOB
- fbsql_create_clob — Create a CLOB
- fbsql_create_db — Create a FrontBase database
- fbsql_data_seek — Move internal result pointer
- fbsql_database_password — Sets or retrieves the password for a FrontBase database
- fbsql_database — Get or set the database name used with a connection
- fbsql_db_query — Send a FrontBase query
- fbsql_db_status — Get the status for a given database
- fbsql_drop_db — Drop (delete) a FrontBase database
- fbsql_errno — Returns the error number from previous operation
- fbsql_error — Returns the error message from previous operation
- fbsql_fetch_array — Fetch a result row as an associative array, a numeric array, or both
- fbsql_fetch_assoc — Fetch a result row as an associative array
- fbsql_fetch_field — Get column information from a result and return as an object
- fbsql_fetch_lengths — Get the length of each output in a result
- fbsql_fetch_object — Fetch a result row as an object
- fbsql_fetch_row — Get a result row as an enumerated array
- fbsql_field_flags — Get the flags associated with the specified field in a result
- fbsql_field_len — Returns the length of the specified field
- fbsql_field_name — Get the name of the specified field in a result
- fbsql_field_seek — Set result pointer to a specified field offset
- fbsql_field_table — Get name of the table the specified field is in
- fbsql_field_type — Get the type of the specified field in a result
- fbsql_free_result — Free result memory
- fbsql_get_autostart_info — 说明
- fbsql_hostname — Get or set the host name used with a connection
- fbsql_insert_id — Get the id generated from the previous INSERT operation
- fbsql_list_dbs — List databases available on a FrontBase server
- fbsql_list_fields — List FrontBase result fields
- fbsql_list_tables — List tables in a FrontBase database
- fbsql_next_result — Move the internal result pointer to the next result
- fbsql_num_fields — Get number of fields in result
- fbsql_num_rows — Get number of rows in result
- fbsql_password — Get or set the user password used with a connection
- fbsql_pconnect — Open a persistent connection to a FrontBase Server
- fbsql_query — Send a FrontBase query
- fbsql_read_blob — Read a BLOB from the database
- fbsql_read_clob — Read a CLOB from the database
- fbsql_result — Get result data
- fbsql_rollback — Rollback a transaction to the database
- fbsql_rows_fetched — Get the number of rows affected by the last statement
- fbsql_select_db — Select a FrontBase database
- fbsql_set_characterset — Change input/output character set
- fbsql_set_lob_mode — Set the LOB retrieve mode for a FrontBase result set
- fbsql_set_password — Change the password for a given user
- fbsql_set_transaction — Set the transaction locking and isolation
- fbsql_start_db — Start a database on local or remote server
- fbsql_stop_db — Stop a database on local or remote server
- fbsql_table_name — Get table name of field
- fbsql_tablename — 别名 fbsql_table_name
- fbsql_username — Get or set the username for the connection
- fbsql_warnings — Enable or disable FrontBase warnings

These functions allow you to access FrontBase database servers. More information about FrontBase can be found at » http://www.frontbase.com/.

Documentation for FrontBase can be found at » http://www.frontbase.com/cgi-bin/WebObjects/FBWebSite.woa.

Note:

此扩展已被移至 » PECL 资源库且不再与 PHP 捆绑。5.3.0.

安装／配置

需求

You must install the FrontBase database server or at least the fbsql client libraries to use this functions. You can get FrontBase from » http://www.frontbase.com/.

安装

此扩展已被移至 » PECL 资源库且不再与 PHP 捆绑。5.3.0

安装此 PECL 扩展相关的信息可在手册中标题为 PECL 扩展的安装章节中找到。更多信息如新的发行版本、下载、源文件、维护人员信息及变更日志等，都在此处：.

In order to have these functions available, you must compile PHP with fbsql support by using the --with-fbsql[=DIR] option. If you use this option without specifying the path to fbsql, PHP will search for the fbsql client libraries in the default installation location for the platform. Users who installed FrontBase in a non standard directory should always specify the path to fbsql: --with-fbsql=/path/to/fbsql. This will force PHP to use the client libraries installed by FrontBase, avoiding any conflicts.

运行时配置

这些函数的行为受 php.ini 中的设置影响。

名字	默认	可修改范围	更新日志
fbsql.allow_persistent	"1"	PHP_INI_SYSTEM
fbsql.generate_warnings	"0"	PHP_INI_SYSTEM
fbsql.autocommit	"1"	PHP_INI_SYSTEM
fbsql.max_persistent	"-1"	PHP_INI_SYSTEM
fbsql.max_links	"128"	PHP_INI_SYSTEM
fbsql.max_connections	"128"	PHP_INI_SYSTEM
fbsql.max_results	"128"	PHP_INI_SYSTEM
fbsql.batchSize	"1000"	PHP_INI_SYSTEM	Removed in PHP 5.1.0.
fbsql.default_host	NULL	PHP_INI_SYSTEM
fbsql.default_user	"_SYSTEM"	PHP_INI_SYSTEM
fbsql.default_password	""	PHP_INI_SYSTEM
fbsql.default_database	""	PHP_INI_SYSTEM
fbsql.default_database_password	""	PHP_INI_SYSTEM

有关 PHP_INI_* 样式的更多详情与定义，见配置可被设定范围。

资源类型

此扩展没有定义资源类型。

预定义常量

下列常量由此扩展定义，且仅在此扩展编译入 PHP 或在运行时动态载入时可用。

FBSQL_ASSOC (int)

FBSQL_NUM (int)

FBSQL_BOTH (int)

FBSQL_LOCK_DEFERRED (int)

FBSQL_LOCK_OPTIMISTIC (int)

FBSQL_LOCK_PESSIMISTIC (int)

FBSQL_ISO_READ_UNCOMMITTED (int)

FBSQL_ISO_READ_COMMITTED (int)

FBSQL_ISO_REPEATABLE_READ (int)

FBSQL_ISO_SERIALIZABLE (int)

FBSQL_ISO_VERSIONED (int)

FBSQL_UNKNOWN (int)

FBSQL_STOPPED (int)

FBSQL_STARTING (int)

FBSQL_RUNNING (int)

FBSQL_STOPPING (int)

FBSQL_NOEXEC (int)

FBSQL_LOB_DIRECT (int)

FBSQL_LOB_HANDLE (int)

fbsql_affected_rows

Get number of affected rows in previous FrontBase operation

说明

int fbsql_affected_rows ([ resource $link_identifier ] )

fbsql_affected_rows returns the number of rows affected by the last INSERT, UPDATE or DELETE query associated with link_identifier.

Note:

If you are using transactions, you need to call fbsql_affected_rows after your INSERT, UPDATE, or DELETE query, not after the commit.

If the last query was a DELETE query with no WHERE clause, all of the records will have been deleted from the table but this function will return zero.

Note:

When using UPDATE, FrontBase will not update columns where the new value is the same as the old value. This creates the possibility that fbsql_affected_rows may not actually equal the number of rows matched, only the number of rows that were literally affected by the query.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

如可选并未指定，函数会尝试查找一个到 FrontBase 服务器的开放链接，且如没有找到这样的链接，会尝试通过不带参数调用 fbsql_connect 来创建一个。

返回值

If the last query failed, this function will return -1.

参见

fbsql_num_rows

fbsql_autocommit

Enable or disable autocommit

说明

bool fbsql_autocommit ( resource $link_identifier [, bool $OnOff ] )

Returns the current autocommit status.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

OnOff
If this optional parameter is given the auto commit status will be changed.

With OnOff set to true each statement will be committed automatically, if no errors was found.

With OnOff set to false the user must commit or rollback the transaction using either fbsql_commit or fbsql_rollback.

返回值

Returns the current autocommit status, as a boolean.

参见

fbsql_commit
fbsql_rollback

fbsql_blob_size

Get the size of a BLOB

说明

int fbsql_blob_size ( string $blob_handle [, resource $link_identifier ] )

Returns the size of the given BLOB.

参数

blob_handle
A BLOB handle, returned by fbsql_create_blob.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns the BLOB size as an integer, or false on error.

参见

fbsql_clob_size

fbsql_change_user

Change logged in user of the active connection

说明

bool fbsql_change_user ( string $user , string $password [, string $database [, resource $link_identifier ]] )

fbsql_change_user changes the logged in user of the specified connection. If the new user and password authorization fails, the current connected user stays active.

参数

user
The new user name.

password
The new user password.

database
If specified, this will be the default or current database after the user has been changed.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

成功时返回 true，或者在失败时返回 false。

fbsql_clob_size

Get the size of a CLOB

说明

int fbsql_clob_size ( string $clob_handle [, resource $link_identifier ] )

Returns the size of the given CLOB.

参数

clob_handle
A CLOB handle, returned by fbsql_create_clob.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns the CLOB size as an integer, or false on error.

参见

fbsql_blob_size

fbsql_close

Close FrontBase connection

说明

bool fbsql_close ([ resource $link_identifier ] )

Closes the connection to the FrontBase server that's associated with the specified link identifier.

Using fbsql_close isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

成功时返回 true，或者在失败时返回 false。

范例

示例 #1 fbsql_close example

<?php
$link = fbsql_connect("localhost", "_SYSTEM", "secret")
    or die("Could not connect");
echo "Connected successfully";
fbsql_close($link);
?>

参见

fbsql_connect
fbsql_pconnect

fbsql_commit

Commits a transaction to the database

说明

bool fbsql_commit ([ resource $link_identifier ] )

Ends the current transaction by writing all inserts, updates and deletes to the disk and unlocking all row and table locks held by the transaction. This command is only needed if autocommit is set to false.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

成功时返回 true，或者在失败时返回 false。

参见

fbsql_autocommit
fbsql_rollback

fbsql_connect

Open a connection to a FrontBase Server

说明

resource fbsql_connect ([ string $hostname = ini_get("fbsql.default_host") [, string $username = ini_get("fbsql.default_user") [, string $password = ini_get("fbsql.default_password") ]]] )

fbsql_connect establishes a connection to a FrontBase server.

If a second call is made to fbsql_connect with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned.

The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling fbsql_close.

参数

hostname
The server host name.

username
The user name for the connection.

password
The password for the connection.

返回值

Returns a positive FrontBase link identifier on success, or false on errors.

范例

示例 #1 fbsql_connect example

<?php

$link = fbsql_connect("localhost", "_SYSTEM", "secret")
    or die("Could not connect");
echo "Connected successfully";
fbsql_close($link);

?>

参见

fbsql_pconnect
fbsql_close

fbsql_create_blob

Create a BLOB

说明

string fbsql_create_blob ( string $blob_data [, resource $link_identifier ] )

Creates a BLOB from the given data.

参数

blob_data
The BLOB data.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns a resource handle to the newly created BLOB, which can be used with insert and update commands to store the BLOB in the database.

范例

示例 #1 fbsql_create_blob example

<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
    or die("Could not connect");
$filename = "blobfile.bin";
$fp = fopen($filename, "rb");
$blobdata = fread($fp, filesize($filename));
fclose($fp);

$blobHandle = fbsql_create_blob($blobdata, $link);

$sql = "INSERT INTO BLOB_TABLE (BLOB_COLUMN) VALUES ($blobHandle);";
$rs = fbsql_query($sql, $link);
?>

参见

fbsql_create_clob
fbsql_read_blob
fbsql_read_clob
fbsql_set_lob_mode

fbsql_create_clob

Create a CLOB

说明

string fbsql_create_clob ( string $clob_data [, resource $link_identifier ] )

Creates a CLOB from the given data.

参数

clob_data
The CLOB data.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns a resource handle to the newly created CLOB, which can be used with insert and update commands to store the CLOB in the database.

范例

示例 #1 fbsql_create_clob example

<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
    or die("Could not connect");
$filename = "clob_file.txt";
$fp = fopen($filename, "rb");
$clobdata = fread($fp, filesize($filename));
fclose($fp);

$clobHandle = fbsql_create_clob($clobdata, $link);

$sql = "INSERT INTO CLOB_TABLE (CLOB_COLUMN) VALUES ($clobHandle);";
$rs = fbsql_query($sql, $link);
?>

参见

fbsql_create_blob
fbsql_read_blob
fbsql_read_clob
fbsql_set_lob_mode

fbsql_create_db

Create a FrontBase database

说明

bool fbsql_create_db ( string $database_name [, resource $link_identifier [, string $database_options ]] )

Attempts to create a new database on the specified server.

参数

database_name
The database name, as a string.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

database_options

返回值

成功时返回 true，或者在失败时返回 false。

范例

示例 #1 fbsql_create_db example

<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
    or die("Could not connect");
if (fbsql_create_db("my_db")) {
    echo "Database created successfully\n";
} else {
    printf("Error creating database: %s\n", fbsql_error());
}
?>

参见

fbsql_drop_db

fbsql_data_seek

Move internal result pointer

说明

bool fbsql_data_seek ( resource $result , int $row_number )

Moves the internal row pointer of the FrontBase result associated with the specified result identifier to point to the specified row number.

The next call to fbsql_fetch_row would return that row.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

row_number
The row number. Starts at 0.

返回值

成功时返回 true，或者在失败时返回 false。

范例

示例 #1 fbsql_data_seek example

<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
    or die("Could not connect");

fbsql_select_db("samp_db")
    or die("Could not select database");

$query = "SELECT last_name, first_name FROM friends;";
$result = fbsql_query($query)
    or die("Query failed");

// fetch rows in reverse order

for ($i = fbsql_num_rows($result) - 1; $i >=0; $i--) {
    if (!fbsql_data_seek($result, $i)) {
        printf("Cannot seek to row %d\n", $i);
        continue;
    }

    if (!($row = fbsql_fetch_object($result)))
        continue;

    echo $row->last_name . $row->first_name . "<br />\n";
}

fbsql_free_result($result);
?>

fbsql_database_password

Sets or retrieves the password for a FrontBase database

说明

string fbsql_database_password ( resource $link_identifier [, string $database_password ] )

Sets and retrieves the database password used by the connection. If a database is protected by a database password, the user must call this function before calling fbsql_select_db.

If no link is open, the function will try to establish a link as if fbsql_connect was called, and use it.

This function does not change the database password in the database nor can it be used to retrieve the database password for a database.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

database_password
The database password, as a string. If given, the function sets the database password for the specified link identifier.

返回值

Returns the database password associated with the link identifier.

范例

示例 #1 fbsql_create_clob example

<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
    or die("Could not connect");
fbsql_database_password($link, "secret db password");
fbsql_select_db($database, $link);
?>

参见

fbsql_connect
fbsql_pconnect
fbsql_select_db

fbsql_database

Get or set the database name used with a connection

说明

string fbsql_database ( resource $link_identifier [, string $database ] )

Get or set the database name used with the connection.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

database
The database name. If given, the default database of the connexion will be changed to database.

返回值

Returns the name of the database used with this connection.

fbsql_db_query

Send a FrontBase query

说明

resource fbsql_db_query ( string $database , string $query [, resource $link_identifier ] )

Selects a database and executes a query on it.

参数

database
The database to be selected.

query
The SQL query to be executed.

Note:

The query string shall always end with a semicolon.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns a positive FrontBase result identifier to the query result, or false on error.

参见

fbsql_query
fbsql_connect

fbsql_db_status

Get the status for a given database

说明

int fbsql_db_status ( string $database_name [, resource $link_identifier ] )

Gets the current status of the specified database.

参数

database_name
The database name.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns an integer value with the current status. This can be one of the following constants:

false - The exec handler for the host was invalid. This error will occur when the link_identifier connects directly to a database by using a port number. FBExec can be available on the server but no connection has been made for it.
FBSQL_UNKNOWN - The Status is unknown.
FBSQL_STOPPED - The database is not running. Use fbsql_start_db to start the database.
FBSQL_STARTING - The database is starting.
FBSQL_RUNNING - The database is running and can be used to perform SQL operations.
FBSQL_STOPPING - The database is stopping.
FBSQL_NOEXEC - FBExec is not running on the server and it is not possible to get the status of the database.

参见

fbsql_start_db
fbsql_stop_db

fbsql_drop_db

Drop (delete) a FrontBase database

说明

bool fbsql_drop_db ( string $database_name [, resource $link_identifier ] )

fbsql_drop_db attempts to drop (remove) an entire database from the server associated with the specified link identifier.

参数

database_name
The database name, as a string.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

成功时返回 true，或者在失败时返回 false。

参见

fbsql_create_db

fbsql_errno

Returns the error number from previous operation

说明

int fbsql_errno ([ resource $link_identifier ] )

Returns the numerical value of the error message from previous FrontBase operation.

Errors coming back from the fbsql database backend don't issue warnings. Instead, use fbsql_errno to retrieve the error code. Note that this function only returns the error code from the most recently executed fbsql function (not including fbsql_error and fbsql_errno), so if you want to use it, make sure you check the value before calling another fbsql function.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns the error number from the last fbsql function, or 0 (zero) if no error occurred.

范例

示例 #1 fbsql_errno Example

<?php
fbsql_connect("marliesle");
echo fbsql_errno() . ": " . fbsql_error() . "<br />";
fbsql_select_db("nonexistentdb");
echo fbsql_errno() . ": " . fbsql_error() . "<br />";
$conn = fbsql_query("SELECT * FROM nonexistenttable;");
echo fbsql_errno() . ": " . fbsql_error() . "<br />";
?>

参见

fbsql_error
fbsql_warnings

fbsql_error

Returns the error message from previous operation

说明

string fbsql_error ([ resource $link_identifier ] )

Returns the error message from previous FrontBase operation.

Errors coming back from the fbsql database backend don't issue warnings. Instead, use fbsql_error to retrieve the error text. Note that this function only returns the error code from the most recently executed fbsql function (not including fbsql_error and fbsql_errno), so if you want to use it, make sure you check the value before calling another fbsql function.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns the error text from the last fbsql function, or '' (the empty string) if no error occurred.

范例

示例 #1 fbsql_error Example

<?php
fbsql_connect("marliesle");
echo fbsql_errno() . ": " . fbsql_error() . "<br />";
fbsql_select_db("nonexistentdb");
echo fbsql_errno() . ": " . fbsql_error() . "<br />";
$conn = fbsql_query("SELECT * FROM nonexistenttable;");
echo fbsql_errno() . ": " . fbsql_error() . "<br />";
?>

参见

fbsql_errno
fbsql_warnings

fbsql_fetch_array

Fetch a result row as an associative array, a numeric array, or both

说明

array fbsql_fetch_array ( resource $result [, int $result_type ] )

fbsql_fetch_array is a combination of fbsql_fetch_row and fbsql_fetch_assoc.

An important thing to note is that using fbsql_fetch_array is NOT significantly slower than using fbsql_fetch_row, while it provides a significant added value.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

result_type
A constant and can take the following values: FBSQL_ASSOC, FBSQL_NUM, or FBSQL_BOTH.

When using FBSQL_BOTH, in addition to storing the data in the numeric indices of the result array, it also stores the data in associative indices, using the field names as keys.

返回值

Returns an array that corresponds to the fetched row, or false if there are no more rows.

If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the same name, you must the numeric index of the column or make an alias for the column.

select t1.f1 as foo t2.f1 as bar from t1, t2

范例

示例 #1 fbsql_fetch_array example

<?php
fbsql_connect($host, $user, $password);
$result = fbsql_db_query("database", "select user_id, fullname from table");
while ($row = fbsql_fetch_array($result)) {
    echo "user_id: " . $row["user_id"] . "<br />\n";
    echo "user_id: " . $row[0] . "<br />\n";
    echo "fullname: " . $row["fullname"] . "<br />\n";
    echo "fullname: " . $row[1] . "<br />\n";
}
fbsql_free_result($result);
?>

参见

fbsql_fetch_row
fbsql_fetch_assoc
fbsql_fetch_object

fbsql_fetch_assoc

Fetch a result row as an associative array

说明

array fbsql_fetch_assoc ( resource $result )

Calling fbsql_fetch_assoc is equivalent to calling fbsql_fetch_array with FBSQL_ASSOC as second parameter. It only returns an associative array.

This is the way fbsql_fetch_array originally worked. If you need the numeric indices as well as the associative, use fbsql_fetch_array.

An important thing to note is that using fbsql_fetch_assoc is NOT significantly slower than using fbsql_fetch_row, while it provides a significant added value.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

返回值

Returns an associative array that corresponds to the fetched row, or false if there are no more rows.

If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the same name, you must use fbsql_fetch_array and have it return the numeric indices as well.

范例

示例 #1 fbsql_fetch_assoc example

<?php
fbsql_connect($host, $user, $password);
$result = fbsql_db_query("database", "select * from table");
while ($row = fbsql_fetch_assoc($result)) {
    echo $row["user_id"];
    echo $row["fullname"];
}
fbsql_free_result($result);
?>

参见

fbsql_fetch_row
fbsql_fetch_array
fbsql_fetch_object

fbsql_fetch_field

Get column information from a result and return as an object

说明

object fbsql_fetch_field ( resource $result [, int $field_offset ] )

Used in order to obtain information about fields in a certain query result.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

field_offset
The numerical offset of the field. The field index starts at 0. If not specified, the next field that wasn't yet retrieved by fbsql_fetch_field is retrieved.

返回值

Returns an object containing field information, or false on errors.

The properties of the object are:

name - column name
table - name of the table the column belongs to
max_length - maximum length of the column
not_null - 1 if the column cannot be null
type - the type of the column

范例

示例 #1 fbsql_fetch_field example

<?php
fbsql_connect($host, $user, $password)
    or die("Could not connect");
$result = fbsql_db_query("database", "select * from table")
    or die("Query failed");
# get column metadata
$i = 0;
while ($i < fbsql_num_fields($result)) {
    echo "Information for column $i:<br />\n";
    $meta = fbsql_fetch_field($result);
    if (!$meta) {
        echo "No information available<br />\n";
    }
    echo "<pre>
max_length:   $meta->max_length
name:         $meta->name
not_null:     $meta->not_null
table:        $meta->table
type:         $meta->type
</pre>";
    $i++;
}
fbsql_free_result($result);
?>

参见

fbsql_field_seek

fbsql_fetch_lengths

Get the length of each output in a result

说明

array fbsql_fetch_lengths ( resource $result )

Stores the lengths of each result column in the last row returned by fbsql_fetch_row, fbsql_fetch_array and fbsql_fetch_object in an array.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

返回值

Returns an array, starting at offset 0, that corresponds to the lengths of each field in the last row fetched by fbsql_fetch_row, or false on error.

参见

fbsql_fetch_row

fbsql_fetch_object

Fetch a result row as an object

说明

object fbsql_fetch_object ( resource $result )

fbsql_fetch_object is similar to fbsql_fetch_array, with one difference - an object is returned, instead of an array. Indirectly, that means that you can only access the data by the field names, and not by their offsets (numbers are illegal property names).

Speed-wise, the function is identical to fbsql_fetch_array, and almost as quick as fbsql_fetch_row (the difference is insignificant).

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

返回值

Returns an object with properties that correspond to the fetched row, or false if there are no more rows.

范例

示例 #1 fbsql_fetch_object example

<?php
fbsql_connect($host, $user, $password);
$result = fbsql_db_query("database", "select * from table");
while ($row = fbsql_fetch_object($result)) {
    echo $row->user_id;
    echo $row->fullname;
}
fbsql_free_result($result);
?>

参见

fbsql_fetch_array
fbsql_fetch_row
fbsql_fetch_assoc

fbsql_fetch_row

Get a result row as an enumerated array

说明

array fbsql_fetch_row ( resource $result )

fbsql_fetch_row fetches one row of data from the result associated with the specified result identifier.

Subsequent call to fbsql_fetch_row would return the next row in the result set, or false if there are no more rows.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

返回值

Returns an array that corresponds to the fetched row where each result column is stored in an offset, starting at offset 0, or false if there are no more rows.

参见

fbsql_fetch_array
fbsql_fetch_assoc
fbsql_fetch_object
fbsql_data_seek
fbsql_fetch_lengths
fbsql_result

fbsql_field_flags

Get the flags associated with the specified field in a result

说明

string fbsql_field_flags ( resource $result [, int $field_offset ] )

Gets the flags associated with the specified field in a result.

参数

result
A result pointer returned by fbsql_list_fields.

field_offset
The numerical offset of the field. The field index starts at 0.

返回值

Returns the field flags of the specified field as a single word per flag separated by a single space, so that you can split the returned value using explode.

fbsql_field_len

Returns the length of the specified field

说明

int fbsql_field_len ( resource $result [, int $field_offset ] )

Returns the length of the specified field.

参数

result
A result pointer returned by fbsql_list_fields.

field_offset
The numerical offset of the field. The field index starts at 0.

返回值

Returns the length of the specified field.

fbsql_field_name

Get the name of the specified field in a result

说明

string fbsql_field_name ( resource $result [, int $field_index ] )

Returns the name of the specified field index.

参数

result
A result pointer returned by fbsql_list_fields.

field_index
The numerical offset of the field. The field index starts at 0.

返回值

Returns the name as a string, or false if the field doesn't exist.

范例

示例 #1 fbsql_field_name example

<?php
// The users table consists of three fields:
//   user_id
//   username
//   password.

$res = fbsql_db_query("users", "select * from users", $link);

echo fbsql_field_name($res, 0) . "\n";
echo fbsql_field_name($res, 2);
?>

以上例程会输出：

user_id
password

参见

fbsql_field_type

fbsql_field_seek

Set result pointer to a specified field offset

说明

bool fbsql_field_seek ( resource $result [, int $field_offset ] )

Seeks to the specified field offset. If the next call to fbsql_fetch_field doesn't include a field offset, the field offset specified in fbsql_field_seek will be returned.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

field_offset
The numerical offset of the field. The field index starts at 0.

返回值

成功时返回 true，或者在失败时返回 false。

参见

fbsql_fetch_field

fbsql_field_table

Get name of the table the specified field is in

说明

string fbsql_field_table ( resource $result [, int $field_offset ] )

Returns the name of the table that the specified field is in.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

field_offset
The numerical offset of the field. The field index starts at 0.

返回值

Returns the name of the table, as a string.

fbsql_field_type

Get the type of the specified field in a result

说明

string fbsql_field_type ( resource $result [, int $field_offset ] )

fbsql_field_type is similar to the fbsql_field_name function, but the field type is returned instead.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

field_offset
The numerical offset of the field. The field index starts at 0.

返回值

Returns the field type, as a string.

This can be one of int, real, string, blob, and others as detailed in the » FrontBase documentation.

范例

示例 #1 fbsql_field_type example

<?php

fbsql_connect("localhost", "_SYSTEM", "");
fbsql_select_db("wisconsin");
$result = fbsql_query("SELECT * FROM onek;");
$fields = fbsql_num_fields($result);
$rows   = fbsql_num_rows($result);
$i = 0;
$table = fbsql_field_table($result, $i);
echo "Your '" . $table . "' table has " . $fields . " fields and " . $rows . " records <br />";
echo "The table has the following fields <br />";
while ($i < $fields) {
    $type  = fbsql_field_type($result, $i);
    $name  = fbsql_field_name($result, $i);
    $len   = fbsql_field_len($result, $i);
    $flags = fbsql_field_flags($result, $i);
    echo $type . " " . $name . " " . $len . " " . $flags . "<br />";
    $i++;
}
fbsql_close();

?>

参见

fbsql_field_name

fbsql_free_result

Free result memory

说明

bool fbsql_free_result ( resource $result )

Frees all memory associated with the given result identifier.

fbsql_free_result only needs to be called if you are concerned about how much memory is being used for queries that return large result sets. All associated result memory is automatically freed at the end of the script's execution.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

返回值

成功时返回 true，或者在失败时返回 false。

fbsql_get_autostart_info

说明

array fbsql_get_autostart_info ([ resource $link_identifier ] )

Warning

本函数还未编写文档，仅有参数列表。

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

fbsql_hostname

Get or set the host name used with a connection

说明

string fbsql_hostname ( resource $link_identifier [, string $host_name ] )

Gets or sets the host name used with a connection.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

host_name
If provided, this will be the new connection host name.

返回值

Returns the current host name used for the connection.

参见

fbsql_username
fbsql_password

fbsql_insert_id

Get the id generated from the previous INSERT operation

说明

int fbsql_insert_id ([ resource $link_identifier ] )

Gets the id generated from the previous INSERT operation which created a DEFAULT UNIQUE value.

Note:

The value of the FrontBase SQL function fbsql_insert_id always contains the most recently generated DEFAULT UNIQUE value, and is not reset between queries.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns the ID generated from the previous INSERT query, or 0 if the previous query does not generate an DEFAULT UNIQUE value.

If you need to save the value for later, be sure to call this function immediately after the query that generates the value.

参见

fbsql_affected_rows

fbsql_list_dbs

List databases available on a FrontBase server

说明

resource fbsql_list_dbs ([ resource $link_identifier ] )

Return a result pointer containing the databases available from the current fbsql daemon. Use the fbsql_tablename to traverse this result pointer.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns a result pointer or false on error.

范例

示例 #1 fbsql_list_dbs example

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

while ($row = fbsql_fetch_object($db_list)) {
    echo $row->Database . "\n";
}
?>

以上例程的输出类似于：

database1
database2
database3
...

Note:

The above code would just as easily work with fbsql_fetch_row or other similar functions.

参见

fbsql_list_fields
fbsql_list_tables

fbsql_list_fields

List FrontBase result fields

说明

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

Retrieves information about the given table.

参数

database_name
The database name.

table_name
The table name.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

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

错误／异常

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.

范例

示例 #1 fbsql_list_fields 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) . "\n";;
}
?>

以上例程的输出类似于：

field1
field2
field3
...

参见

fbsql_field_len
fbsql_field_name
fbsql_field_type
fbsql_field_flags

fbsql_list_tables

List tables in a FrontBase database

说明

resource fbsql_list_tables ( string $database [, resource $link_identifier ] )

Returns a result pointer describing the database.

参数

database
The database name.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns a result pointer which can be used with the fbsql_tablename function to read the actual table names, or false on error.

参见

fbsql_list_fields
fbsql_list_dbs

fbsql_next_result

Move the internal result pointer to the next result

说明

bool fbsql_next_result ( resource $result )

When sending more than one SQL statement to the server or executing a stored procedure with multiple results will cause the server to return multiple result sets. This function will test for additional results available form the server. If an additional result set exists it will free the existing result set and prepare to fetch the words from the new result set.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

返回值

Returns true if an additional result set was available or false otherwise.

范例

示例 #1 fbsql_next_result example

<?php
$link = fbsql_connect("localhost", "_SYSTEM", "secret");
fbsql_select_db("MyDB", $link);
$SQL = "Select * from table1; select * from table2;";
$rs = fbsql_query($SQL, $link);
do {
    while ($row = fbsql_fetch_row($rs)) {
    }
} while (fbsql_next_result($rs));
fbsql_free_result($rs);
fbsql_close($link);
?>

fbsql_num_fields

Get number of fields in result

说明

int fbsql_num_fields ( resource $result )

Returns the number of fields in the given result set.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

返回值

Returns the number of fields, as an integer.

参见

fbsql_db_query
fbsql_query
fbsql_fetch_field
fbsql_num_rows

fbsql_num_rows

Get number of rows in result

说明

int fbsql_num_rows ( resource $result )

Gets the number of rows in the given result set.

This function is only valid for SELECT statements. To retrieve the number of rows returned from a INSERT, UPDATE or DELETE query, use fbsql_affected_rows.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

返回值

Returns the number of rows returned by the last SELECT statement.

范例

示例 #1 fbsql_num_rows example

<?php

$link = fbsql_connect("localhost", "username", "password");
fbsql_select_db("database", $link);

$result = fbsql_query("SELECT * FROM table1;", $link);
$num_rows = fbsql_num_rows($result);

echo "$num_rows Rows\n";

?>

参见

fbsql_affected_rows
fbsql_connect
fbsql_select_db
fbsql_query

fbsql_password

Get or set the user password used with a connection

说明

string fbsql_password ( resource $link_identifier [, string $password ] )

Get or set the user password used with a connection.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

password
If provided, this will be the new connection password.

返回值

Returns the current password used for the connection.

参见

fbsql_username
fbsql_hostname

fbsql_pconnect

Open a persistent connection to a FrontBase Server

说明

resource fbsql_pconnect ([ string $hostname = ini_get("fbsql.default_host") [, string $username = ini_get("fbsql.default_user") [, string $password = ini_get("fbsql.default_password") ]]] )

Establishes a persistent connection to a FrontBase server.

To set the server port number, use fbsql_select_db.

fbsql_pconnect acts very much like fbsql_connect with two major differences:

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.

Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use.

This type of links is therefore called 'persistent'.

参数

hostname
The server host name.

username
The user name for the connection.

password
The password for the connection.

返回值

Returns a positive FrontBase persistent link identifier on success, or false on error.

参见

fbsql_connect

fbsql_query

Send a FrontBase query

说明

resource fbsql_query ( string $query [, resource $link_identifier [, int $batch_size ]] )

Sends a query to the currently active database on the server.

If the query succeeds, you can call fbsql_num_rows to find out how many rows were returned for a SELECT statement or fbsql_affected_rows to find out how many rows were affected by a DELETE, INSERT, REPLACE, or UPDATE statement.

参数

query
The SQL query to be executed.

Note:

The query string shall always end with a semicolon.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

batch_size

返回值

fbsql_query returns true (non-zero) or false to indicate whether or not the query succeeded. A return value of true means that the query was legal and could be executed by the server. It does not indicate anything about the number of rows affected or returned. It is perfectly possible for a query to succeed but affect no rows or return no rows.

For SELECT statements, fbsql_query returns a new result identifier that you can pass to fbsql_result.

fbsql_query will also fail and return false if you don't have permission to access the table(s) referenced by the query.

范例

The following query is syntactically invalid, so fbsql_query fails and returns false:

示例 #1 fbsql_query example

<?php
$result = fbsql_query("SELECT * WHERE 1=1")
    or die ("Invalid query");
?>

The following query is semantically invalid if my_col is not a column in the table my_tbl, so fbsql_query fails and returns false:

示例 #2 fbsql_query example

<?php
$result = fbsql_query ("SELECT my_col FROM my_tbl;")
    or die ("Invalid query");
?>

参见

fbsql_affected_rows
fbsql_db_query
fbsql_free_result
fbsql_result
fbsql_select_db
fbsql_connect

fbsql_read_blob

Read a BLOB from the database

说明

string fbsql_read_blob ( string $blob_handle [, resource $link_identifier ] )

Reads BLOB data from the database.

If a select statement contains BLOB and/or CLOB columns FrontBase will return the data directly when data is fetched. This default behavior can be changed with fbsql_set_lob_mode so the fetch functions will return handles to BLOB and CLOB data. If a handle is fetched a user must call fbsql_read_blob to get the actual BLOB data from the database.

参数

blob_handle
A BLOB handle, returned by fbsql_create_blob.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns a string containing the specified BLOB data.

范例

示例 #1 fbsql_read_blob example

<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
    or die("Could not connect");
$sql = "SELECT BLOB_COLUMN FROM BLOB_TABLE;";
$rs = fbsql_query($sql, $link);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain the blob data for the first row
fbsql_free_result($rs);

$rs = fbsql_query($sql, $link);
fbsql_set_lob_mode($rs, FBSQL_LOB_HANDLE);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain a handle to the BLOB data in the first row
$blob_data = fbsql_read_blob($row_data[0]);
fbsql_free_result($rs);

?>

参见

fbsql_create_blob
fbsql_read_clob
fbsql_set_lob_mode

fbsql_read_clob

Read a CLOB from the database

说明

string fbsql_read_clob ( string $clob_handle [, resource $link_identifier ] )

Reads CLOB data from the database.

If a select statement contains BLOB and/or CLOB columns FrontBase will return the data directly when data is fetched. This default behavior can be changed with fbsql_set_lob_mode so the fetch functions will return handles to BLOB and CLOB data. If a handle is fetched a user must call fbsql_read_clob to get the actual CLOB data from the database.

参数

clob_handle
A CLOB handle, returned by fbsql_create_clob.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

Returns a string containing the specified CLOB data.

范例

示例 #1 fbsql_read_clob example

<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
    or die("Could not connect");
$sql = "SELECT CLOB_COLUMN FROM CLOB_TABLE;";
$rs = fbsql_query($sql, $link);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain the clob data for the first row
fbsql_free_result($rs);

$rs = fbsql_query($sql, $link);
fbsql_set_lob_mode($rs, FBSQL_LOB_HANDLE);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain a handle to the CLOB data in the first row
$clob_data = fbsql_read_clob($row_data[0]);
fbsql_free_result($rs);

?>

参见

fbsql_create_clob
fbsql_read_blob
fbsql_set_lob_mode

fbsql_result

Get result data

说明

mixed fbsql_result ( resource $result [, int $row [, mixed $field ]] )

Returns the contents of one cell from a FrontBase result set.

When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As these functions return the contents of multiple cells in one function call, they're MUCH quicker than fbsql_result.

Calls to fbsql_result should not be mixed with calls to other functions that deal with the result set.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

row

field
Can be the field's offset, or the field's name, or the field's table dot field's name (tablename.fieldname).

If the column name has been aliased ('select foo as bar from...'), use the alias instead of the column name.

Note:

Specifying a numeric offset for the field argument is much quicker than specifying a fieldname or tablename.fieldname argument.

返回值

参见

Recommended high-performance alternatives:

fbsql_fetch_row
fbsql_fetch_array
fbsql_fetch_assoc
fbsql_fetch_object

fbsql_rollback

Rollback a transaction to the database

说明

bool fbsql_rollback ([ resource $link_identifier ] )

Ends the current transaction by rolling back all statements issued since last commit.

This command is only needed if autocommit is set to false.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

成功时返回 true，或者在失败时返回 false。

参见

fbsql_autocommit
fbsql_commit

fbsql_rows_fetched

Get the number of rows affected by the last statement

说明

int fbsql_rows_fetched ( resource $result )

Gets the number of rows affected by the last statement.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

返回值

Returns the number of rows, as an integer.

fbsql_select_db

Select a FrontBase database

说明

bool fbsql_select_db ([ string $database_name [, resource $link_identifier ]] )

Sets the current active database on the given link identifier.

The client contacts FBExec to obtain the port number to use for the connection to the database. If the database name is a number the system will use that as a port number and it will not ask FBExec for the port number. The FrontBase server can be stared as FRontBase -FBExec=No -port=\<port number> \<database name>.

Every subsequent call to fbsql_query will be made on the active database.

参数

database_name
The name of the database to be selected.

If the database is protected with a database password, the you must call fbsql_database_password before selecting the database.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

成功时返回 true，或者在失败时返回 false。

参见

fbsql_connect
fbsql_pconnect
fbsql_database_password
fbsql_query

fbsql_set_characterset

Change input/output character set

说明

void fbsql_set_characterset ( resource $link_identifier , int $characterset [, int $in_out_both ] )

Warning

本函数还未编写文档，仅有参数列表。

返回值

没有返回值。

fbsql_set_lob_mode

Set the LOB retrieve mode for a FrontBase result set

说明

bool fbsql_set_lob_mode ( resource $result , int $lob_mode )

Sets the mode for retrieving LOB data from the database.

When BLOB and CLOB data is retrieved in FrontBase it can be retrieved direct or indirect. Direct retrieved LOB data will always be fetched no matter the setting of the lob mode. If the LOB data is less than 512 bytes it will always be retrieved directly.

参数

result
由 fbsql_query 或 fbsql_db_query 返回的结果标识符。

lob_mode
Can be one of:

FBSQL_LOB_DIRECT - LOB data is retrieved directly. When data is fetched from the database with fbsql_fetch_row, and other fetch functions, all CLOB and BLOB columns will be returned as ordinary columns. This is the default value on a new FrontBase result.
FBSQL_LOB_HANDLE - LOB data is retrieved as handles to the data. When data is fetched from the database with fbsql_fetch_row, and other fetch functions, LOB data will be returned as a handle to the data if the data is stored indirect or the data if it is stored direct. If a handle is returned it will be a 27 byte string formatted as @'000000000000000000000000'.

返回值

成功时返回 true，或者在失败时返回 false。

参见

fbsql_create_blob
fbsql_create_clob
fbsql_read_blob
fbsql_read_clob

fbsql_set_password

Change the password for a given user

说明

bool fbsql_set_password ( resource $link_identifier , string $user , string $password , string $old_password )

Changes the password for the given user.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

user
The user name.

password
The new password to be set.

old_password
The old password to be replaced.

返回值

成功时返回 true，或者在失败时返回 false。

fbsql_set_transaction

Set the transaction locking and isolation

说明

void fbsql_set_transaction ( resource $link_identifier , int $locking , int $isolation )

Sets the transaction locking and isolation.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

locking
The type of locking to be set. It can be one of the following constants: FBSQL_LOCK_DEFERRED, FBSQL_LOCK_OPTIMISTIC, or FBSQL_LOCK_PESSIMISTIC.

isolation
The type of isolation to be set. It can be one of the following constants: FBSQL_ISO_READ_UNCOMMITTED, FBSQL_ISO_READ_COMMITTED, FBSQL_ISO_REPEATABLE_READ, FBSQL_ISO_SERIALIZABLE, or FBSQL_ISO_VERSIONED.

返回值

没有返回值。

fbsql_start_db

Start a database on local or remote server

说明

bool fbsql_start_db ( string $database_name [, resource $link_identifier [, string $database_options ]] )

Start a database on local or remote server.

参数

database_name
The database name.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

database_options

返回值

成功时返回 true，或者在失败时返回 false。

参见

fbsql_db_status
fbsql_stop_db

fbsql_stop_db

Stop a database on local or remote server

说明

bool fbsql_stop_db ( string $database_name [, resource $link_identifier ] )

Stops a database on local or remote server.

参数

database_name
The database name.

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

返回值

成功时返回 true，或者在失败时返回 false。

参见

fbsql_db_status
fbsql_start_db

fbsql_table_name

Get table name of field

说明

string fbsql_table_name ( resource $result , int $index )

fbsql_table_name gets the name of the current table in the given result set.

The fbsql_num_rows function may be used to determine the number of tables in the result pointer.

参数

result
A result pointer returned by fbsql_list_tables.

index
Integer index for the current table.

返回值

Returns the name of the table, as a string.

范例

示例 #1 fbsql_table_name example

<?php
fbsql_connect("localhost", "_SYSTEM", "");
$result = fbsql_list_tables("wisconsin");
$i = 0;
while ($i < fbsql_num_rows($result)) {
    $tb_names[$i] = fbsql_table_name($result, $i);
    echo $tb_names[$i] . "<br />";
    $i++;
}
?>

fbsql_tablename

别名 fbsql_table_name

说明

此函数是该函数的别名： fbsql_table_name.

fbsql_username

Get or set the username for the connection

说明

string fbsql_username ( resource $link_identifier [, string $username ] )

Get or set the username used for the connection.

参数

link_identifier
由 fbsql_connect 或 fbsql_pconnect 返回的 FrontBase 链接标识符.

username
If provided, this is the new username to set.

返回值

Returns the current username used with the connection, as a string.

参见

fbsql_password
fbsql_hostname

fbsql_warnings

Enable or disable FrontBase warnings

说明

bool fbsql_warnings ([ bool $OnOff ] )

Enables or disables FrontBase warnings.

参数

OnOff
Whether to enable warnings or no.

返回值

Returns true if warnings is turned on, false otherwise.

参见

fbsql_errno
fbsql_error

fbsql_affected_rows — Get number of affected rows in previous FrontBase operation
fbsql_autocommit — Enable or disable autocommit
fbsql_blob_size — Get the size of a BLOB
fbsql_change_user — Change logged in user of the active connection
fbsql_clob_size — Get the size of a CLOB
fbsql_close — Close FrontBase connection
fbsql_commit — Commits a transaction to the database
fbsql_connect — Open a connection to a FrontBase Server
fbsql_create_blob — Create a BLOB
fbsql_create_clob — Create a CLOB
fbsql_create_db — Create a FrontBase database
fbsql_data_seek — Move internal result pointer
fbsql_database_password — Sets or retrieves the password for a FrontBase database
fbsql_database — Get or set the database name used with a connection
fbsql_db_query — Send a FrontBase query
fbsql_db_status — Get the status for a given database
fbsql_drop_db — Drop (delete) a FrontBase database
fbsql_errno — Returns the error number from previous operation
fbsql_error — Returns the error message from previous operation
fbsql_fetch_array — Fetch a result row as an associative array, a numeric array, or both
fbsql_fetch_assoc — Fetch a result row as an associative array
fbsql_fetch_field — Get column information from a result and return as an object
fbsql_fetch_lengths — Get the length of each output in a result
fbsql_fetch_object — Fetch a result row as an object
fbsql_fetch_row — Get a result row as an enumerated array
fbsql_field_flags — Get the flags associated with the specified field in a result
fbsql_field_len — Returns the length of the specified field
fbsql_field_name — Get the name of the specified field in a result
fbsql_field_seek — Set result pointer to a specified field offset
fbsql_field_table — Get name of the table the specified field is in
fbsql_field_type — Get the type of the specified field in a result
fbsql_free_result — Free result memory
fbsql_get_autostart_info — 说明
fbsql_hostname — Get or set the host name used with a connection
fbsql_insert_id — Get the id generated from the previous INSERT operation
fbsql_list_dbs — List databases available on a FrontBase server
fbsql_list_fields — List FrontBase result fields
fbsql_list_tables — List tables in a FrontBase database
fbsql_next_result — Move the internal result pointer to the next result
fbsql_num_fields — Get number of fields in result
fbsql_num_rows — Get number of rows in result
fbsql_password — Get or set the user password used with a connection
fbsql_pconnect — Open a persistent connection to a FrontBase Server
fbsql_query — Send a FrontBase query
fbsql_read_blob — Read a BLOB from the database
fbsql_read_clob — Read a CLOB from the database
fbsql_result — Get result data
fbsql_rollback — Rollback a transaction to the database
fbsql_rows_fetched — Get the number of rows affected by the last statement
fbsql_select_db — Select a FrontBase database
fbsql_set_characterset — Change input/output character set
fbsql_set_lob_mode — Set the LOB retrieve mode for a FrontBase result set
fbsql_set_password — Change the password for a given user
fbsql_set_transaction — Set the transaction locking and isolation
fbsql_start_db — Start a database on local or remote server
fbsql_stop_db — Stop a database on local or remote server
fbsql_table_name — Get table name of field
fbsql_tablename — 别名 fbsql_table_name
fbsql_username — Get or set the username for the connection
fbsql_warnings — Enable or disable FrontBase warnings