Home > PHP > Function > FrontBase > fbsql_query()

fbsql_query()

fbsql_query - Send a FrontBase query

Syntax

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

Arguments

  • query - The SQL query to be executed. Note: The query string shall always end with a semicolon.
  • link_identifier - A FrontBase link identifier returned by fbsql_connect() or fbsql_pconnect(). 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() was called with no arguments.
  • batch_size

Description

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

Version

PHP 4.0.6, 5

Return value

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.