Documentation › Modules › sql.em
File: sql.em
Functions for interacting with a MySQL DBMS. On Linux you must have the MySQL headers and libraries installed.
mysql_affected_rows( result )#
Parameters
| result | Result object |
Explanation
Returns number of rows affected by last query.
Return values
Integer on success
mysql_close( connection )#
Parameters
| connection | Connection object |
Explanation
Closed the connection to DBMS.
Return values
1 on success
mysql_connect(host,username,password := "", port := 0 )#
Parameters
| host | MySQL DBMS hostname, usually 'localhost' |
| username | User Name for the connection |
| password | Password for the connection |
| port | connection port, 0 for default port |
Explanation
Connects to DMBS.
Return values
Connection on success
mysql_escape_string(connection, str )#
Parameters
| connection | Connection object |
| str | String to escape |
Explanation
Returns escaped string on success
Return values
String on success, Error otherwise
mysql_fetch_row( result )#
Parameters
| result | Result object |
Explanation
Fetches next row from Result.
Return values
Array on success
mysql_field_name(result, column_index )#
Parameters
| result | Result object |
| column_index | index for the field in the result |
Explanation
Returns the given field's name in result.
Return values
String on success
mysql_num_fields( result )#
Parameters
| result | Result object |
Explanation
Returns number of fields in result.
Return values
Integer on success
mysql_num_rows( result )#
Parameters
| result | Result object |
Explanation
Returns number of rows in result.
Return values
Integer on success
mysql_query(connection,query, parameters := "" )#
Parameters
| connection | Connection object |
| query | the SQL query to perform |
| parameters | Array of parameters. |
Explanation
Performs a query. Every occurrence of ? in the query will be replaced
by corresponding parameter in the parameters array (if present). Parameters are
automatically escaped. All parameters are handled as string by now.
Example: mysql_query(conn, "SELECT a FROM t WHERE a = ? AND b = ?", array{1,"hel'lo")
executes "SELECT a FROM t WHERE a = '1' AND b = 'hel\'lo'"
Return values
Connection on success
mysql_select_db(connection, database )#
Parameters
| connection | Connection object |
| database | database name |
Explanation
Select a database to perform queries on.
Return values
1 on success