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.

Last modified: 03/10/2024

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