(PHP 4 >= 4.0.6, PHP 5, PHP 7)
fbsql_query — Send a FrontBase query
$query
[, resource $link_identifier
[, int $batch_size
]] ) : resource
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.
queryThe SQL query to be executed.
Note:
The query string shall always end with a semicolon.
link_identifier锟斤拷 fbsql_connect() 锟斤拷 fbsql_pconnect() 锟斤拷锟截碉拷 FrontBase 锟斤拷锟接憋拷识锟斤拷.
锟斤拷锟窖★拷锟轿粗革拷锟斤拷锟斤拷锟斤拷锟斤拷岢拷圆锟斤拷锟揭伙拷锟斤拷锟� FrontBase 锟斤拷锟斤拷锟斤拷锟侥匡拷锟斤拷锟斤拷锟接ｏ拷锟斤拷锟斤拷没锟斤拷锟揭碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟接ｏ拷锟结尝锟斤拷通锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 fbsql_connect() 锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷
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:
Example #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:
Example #2 fbsql_query() example
<?php
$result = fbsql_query ("SELECT my_col FROM my_tbl;")
or die ("Invalid query");
?>