The SQL API
SPIP’s SQL abstraction functions constitute an API which contains the following functions:
Name | Description |
---|---|
Common elements | System parameters and options
|
sql_allfetsel | Returns an array with all of the results from a selection
|
sql_alltable | Returns an array of the existing SQL tables
|
sql_alter | Modifies the structure of an SQL table
|
sql_count | Counts the number of rows in a selection resource
|
sql_countsel | Counts the number of results
|
sql_create | Creates a table according to the schema provided
|
sql_create_base | Creates a database
|
sql_create_view | Creates a view
|
sql_date_proche | Returns a date comparison expression based on a date calculation
|
sql_delete | Deletes database records
|
sql_drop_table | Deletes a table!
|
sql_drop_view | Deletes a view
|
sql_errno | Returns the number code for the last SQL error
|
sql_error | Returns the last SQL error
|
sql_explain | Explains how the SQL server will process a request
|
sql_fetch | Returns a row from a selection resource
|
sql_fetch_all | Returns a table with all the results from a query
|
sql_fetsel | Selects and returns the first row of results
|
sql_free | Releases a resource
|
sql_getfetsel | Retrieves the single column requested from the first row in the selection
|
sql_get_charset | Requests if a particular character encoding is available on the server
|
sql_get_select | Returns the selection query
|
sql_hex | Returns a numeric value for a hexadecimal character string
|
sql_in | Constructs a condition using the IN operator
|
sql_insert | Inserts content into the database
|
sql_insertq | Inserts content into a database (automatically filtered)
|
sql_insertq_multi | Used to insert several database rows in a single operation
|
sql_in_select | Returns an sql_in condition from the results of an sql_select
|
sql_listdbs | Lists the databases available for a given connection
|
sql_multi | Extracts multilingual content
|
sql_optimize | Optimises a given table
|
sql_query | Executes a specific query
|
sql_quote | Filters (or escapes) an SQL parameter
|
sql_repair | Repairs a damaged table
|
sql_replace | Inserts or modifies a record
|
sql_replace_multi | Inserts or replaces several records
|
sql_seek | Positions a selection resource at the designated row number
|
sql_select | Selects content
|
sql_selectdb | Selects the requested database
|
sql_serveur | The API’s principal transparent function
|
sql_set_charset | Requests the use of the specified character encoding
|
sql_showbase | Returns a resource of the list of database tables
|
sql_showtable | Returns a description of the table
|
sql_update | Updates a database record
|
sql_updateq | Updates database content (and filters the data against SQL injection attacks)
|
sql_version | Returns the version number of the database manager
|
Updated : 17/05/10
Translations : English, français