
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