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