Welcome to PenUltima Online. Click to login or register.

File: sql.em

Description: Functions for interacting with a MySQL DBMS. You must have the MySQL headers and libraries installed. Only really tested with dynamically linking mysql libraries on Linux.
Last Modified: 08/31/2015

Modules:

mysql_affected_rows(result)
Parameters:
Name Type
result Result object
Explanation
Returns number of rows affected by last query.
Return values
Integer on success
mysql_close(connection)
Parameters:
Name Type
connection Connection object
Explanation
Closed the connection to DBMS.
Return values
1 on success
mysql_connect(host,username,password := "")
Parameters:
Name Type
host MySQL DBMS hostname, usually 'localhost'
username User Name for the connection
password Password for the connection
Explanation
Connects to DMBS.
Return values
Connection on success
mysql_fetch_row(result)
Parameters:
Name Type
result Result object
Explanation
Fetches next row from Result.
Return values
Array on success
mysql_field_name(result,column_index)
Parameters:
Name Type
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:
Name Type
result Result object
Explanation
Returns number of fields in result.
Return values
Integer on success
mysql_num_rows(result)
Parameters:
Name Type
result Result object
Explanation
Returns number of rows in result.
Return values
Integer on success
mysql_query(connection,query,parameters := "")
Parameters:
Name Type
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:
Name Type
connection Connection object
database database name
Explanation
Select a database to perform queries on.
Return values
1 on success