Difference between revisions of "RDO CONNECT()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
 
{{YLM to do}}
 
{{YLM to do}}
 
Numeric = rdo_connect(servertype as character, hostname as character, username as character, password as character, database as character)
 
Numeric = rdo_connect(servertype as character, hostname as character, username as character, password as character, database as character)
 +
 +
 +
Closes a connection
 +
rdo_close(connection as Numeric)
 +
mysql_close(connection as Numeric)
 +
 +
The mysql_select_db() function sets the active database
 +
Numeric = rdo_select_db(database as Character [, connection as Numeric] )
 +
Numeric = mysql_select_db(database as Character [, connection as Numeric] )
 +
 +
The mysql_list_dbs() function finds the available databases for a given connection.
 +
Object = rdo_list_dbs(connection as Numeric)
 +
Object = mysql_list_dbs(connection as Numeric)
 +
 +
This function returns the number of affected rows on success, or -1 if the last operation failed
 +
Numeric = rdo_affected_rows()
 +
Numeric = mysql_affected_rows()
 +
 +
Returns the error number of the last operation
 +
Numeric = rdo_errno()
 +
Numeric = mysql_errno()
 +
 +
Returns the error description of the last Recital operation
 +
Character = rdo_error()
 +
Character = mysql_error()
 +
 +
Returns a row from a recordset as an associative array
 +
Object = rdo_fetch_array(query as Character)
 +
Object = rdo_fetch_assoc(query as Character)
 +
Object = mysql_fetch_array(query as Character)
 +
Object = mysql_fetch_assoc(query as Character)
 +
 +
This function returns a ResultSet Object for SELECT queries
 +
Object = rdo_query(query as Character [, connection as Numeric] )
 +
Object = rdo_unbuffered_query(char query [, connection as Numeric] )
 +
Object = mysql_query(query as Character [, connection as Numeric] )
 +
Object = mysql_unbuffered_query(char query [, connection as Numeric] )
 +
TIP
 +
The mysql_query() function returns an associative array where each item in the array is an associative array containing the fields for each record returned from the query. Use the FOREACH statement to traverse this data.
 +
 +
e.g.
 +
 +
connection = mysql_connect("localhost", myusername, mpassword)
 +
mysql_select_db("mydatabase")
 +
resultset = mysql_query("select * from customers", connection)
 +
foreach resultset as r
 +
    echo r["fieldname"]
 +
endfor
 +
This function executes non-SELECT statements
 +
Numeric = rdo_exec(command as Character [, connection as Numeric] )
 +
Numeric = mysql_exec(command as Character [, connection as Numeric] )
 +
TIP
 +
You can use the mysql_exec() function to create tables and insert data.
 +
 +
e.g.
 +
 +
mysql_exec("create table mytable (name char(10))", connection)
 +
mysql_exec("insert into mytable values ('Hello world')")
 +
 +
However, Recital is a database centric scripting language so you can just place the sql commands directly in your program code.
 +
 +
// open a new mysql connection
 +
connection = mysql_connect("localhost", myusername, mypassword)
 +
 +
// The mysql connection is selected after the mysql_connect() function returns
 +
create table mytable (name char(10))
 +
insert into mytable values ('Hello world')
 +
 +
// close the connection
 +
mysql_close(connection)
 +
The following functions returns the next row from a recordset as an Object
 +
Object = rdo_fetch_object(resultset as Object)
 +
Object = rdo_fetch_row(resultset as Object)
 +
Object = mysql_fetch_object(resultset as Object)
 +
Object = mysql_fetch_row(resultset as Object)
 +
 +
The mysql_num_rows() function returns the number of rows in a recordset
 +
Numeric = rdo_num_rows(resultset as Object)
 +
Numeric = mysql_num_rows(resultset as Object)
 +
 +
Returns the number of fields in a recordset
 +
Numeric = rdo_num_fields(resultset as Object)
 +
Numeric = mysql_num_fields(resultset as Object)
 +
 +
The mysql_data_seek() function moves the internal row pointer
 +
Numeric = rdo_data_seek(Resultset as Object, Row as Numeric)
 +
Numeric = mysql_data_seek(Resultset as Object, Row as Numeric)
 +
 +
The mysql_field_seek() function jumps to a specified field in a recordset
 +
Numeric = rdo_field_seek(Resultset as Object, Column as Numeric)
 +
Numeric = mysql_field_seek(Resultset as Object, Column as Numeric)
 +
 +
The mysql_fetch_field() function returns an object containing information of a field from a recordset
 +
Object = rdo_fetch_field(Resultset as Object, Column as Numeric)
 +
Object = mysql_fetch_field(Resultset as Object, Column as Numeric)
 +
 +
The mysql_fetch_lengths() function returns the length of the contents of each field in a row
 +
Object = rdo_fetch_lengths(Resultset as Object)
 +
Object = mysql_fetch_lengths(Resultset as Object)
 +
 +
The mysql_field_table() function returns the name of the table where a specified field is located
 +
Character = rdo_field_table(Resultset as Object, int field_offset)
 +
Character = mysql_field_table(Resultset as Object, int field_offset)
 +
 +
The mysql_field_name() function returns the name of a field in a recordset
 +
Character = rdo_field_name(Resultset as Object, Column as Numeric)
 +
Character = mysql_field_name(Resultset as Object, Column as Numeric)
 +
 +
The mysql_field_type() function returns the type of a field in a recordset
 +
Character = rdo_field_type(Resultset as Object, Column as Numeric)
 +
Character = mysql_field_type(Resultset as Object, Column as Numeric)
 +
 +
The mysql_field_len() function returns the length of a field in a recordset
 +
Numeric = rdo_field_len(Resultset as Object, Column as Numeric)
 +
Numeric = mysql_field_len(Resultset as Object, Column as Numeric)
 +
 +
The mysql_field_flags() function returns the flags of a field in a recordset
 +
Character = rdo_field_flags(Resultset as Object, Column as Numeric)
 +
Character = mysql_field_flags(Resultset as Object, Column as Numeric)
 +
 +
The mysql_result() function returns the value of a field in a recordset
 +
Character = rdo_result(Resultset as Object, Row as Numeric, char field)
 +
Character = mysql_result(Resultset as Object, Row as Numeric, char field)
 +
 +
The mysql_free_result() function frees memory used by a result handle
 +
Numeric = rdo_free_result(Resultset as Object)
 +
Numeric = mysql_free_result(Resultset as Object)
 +
 +
The mysql_free_object() function frees memory used by an object
 +
Numeric = rdo_free_object(Resultset as Object)
 +
Numeric = mysql_free_object(Resultset as Object)
 +
 +
The mysql_real_escape_string() function escapes special characters in a string for use in an SQL statement
 +
Character = rdo_real_escape_string(string as character [, Connection as Numeric] )
 +
Character = mysql_real_escape_string(string as character [, Connection as Numeric] )
 +
 +
The mysql_info() function returns information about the last query
 +
Character = rdo_info( [Connection as Numeric ] )
 +
Character = mysql_info( [Connection as Numeric ] )
 +
 +
The mysql_ping() function pings a server connection or reconnects to it if there is no connection
 +
Numeric = rdo_ping( [Connection as Numeric] )
 +
Numeric = mysql_ping( [Connection as Numeric] )
 +
 +
The mysql_thread_id() function returns the current thread ID
 +
Numeric = rdo_thread_id()
 +
Numeric = mysql_thread_id()
 +
 +
The mysql_stat() function returns the current system status of Recital
 +
Numeric = rdo_stat( [Connection as Numeric] )
 +
Numeric = mysql_stat( [Connection as Numeric] )
 +
 +
The mysql_get_client_info() function gets information about Recital
 +
Character = rdo_get_client_info()
 +
Character = mysql_get_client_info()
 +
 +
The mysql_get_host_info() function gets information about Recital
 +
Character = rdo_get_host_info()
 +
Character = mysql_get_host_info()
 +
 +
==See Also==
 +
[[rdo_get_client_info()]], [[rdo_get_host_info()]], [[rdo_info()]], [[rdo_ping()]], [[rdo_stat()]], [[rdo_thread_id()]]

Revision as of 16:01, 18 March 2010

Template:YLM to do Numeric = rdo_connect(servertype as character, hostname as character, username as character, password as character, database as character)


Closes a connection rdo_close(connection as Numeric) mysql_close(connection as Numeric)

The mysql_select_db() function sets the active database Numeric = rdo_select_db(database as Character [, connection as Numeric] ) Numeric = mysql_select_db(database as Character [, connection as Numeric] )

The mysql_list_dbs() function finds the available databases for a given connection. Object = rdo_list_dbs(connection as Numeric) Object = mysql_list_dbs(connection as Numeric)

This function returns the number of affected rows on success, or -1 if the last operation failed Numeric = rdo_affected_rows() Numeric = mysql_affected_rows()

Returns the error number of the last operation Numeric = rdo_errno() Numeric = mysql_errno()

Returns the error description of the last Recital operation Character = rdo_error() Character = mysql_error()

Returns a row from a recordset as an associative array Object = rdo_fetch_array(query as Character) Object = rdo_fetch_assoc(query as Character) Object = mysql_fetch_array(query as Character) Object = mysql_fetch_assoc(query as Character)

This function returns a ResultSet Object for SELECT queries Object = rdo_query(query as Character [, connection as Numeric] ) Object = rdo_unbuffered_query(char query [, connection as Numeric] ) Object = mysql_query(query as Character [, connection as Numeric] ) Object = mysql_unbuffered_query(char query [, connection as Numeric] ) TIP The mysql_query() function returns an associative array where each item in the array is an associative array containing the fields for each record returned from the query. Use the FOREACH statement to traverse this data.

e.g.

connection = mysql_connect("localhost", myusername, mpassword) mysql_select_db("mydatabase") resultset = mysql_query("select * from customers", connection) foreach resultset as r

   echo r["fieldname"]

endfor This function executes non-SELECT statements Numeric = rdo_exec(command as Character [, connection as Numeric] ) Numeric = mysql_exec(command as Character [, connection as Numeric] ) TIP You can use the mysql_exec() function to create tables and insert data.

e.g.

mysql_exec("create table mytable (name char(10))", connection) mysql_exec("insert into mytable values ('Hello world')")

However, Recital is a database centric scripting language so you can just place the sql commands directly in your program code.

// open a new mysql connection connection = mysql_connect("localhost", myusername, mypassword)

// The mysql connection is selected after the mysql_connect() function returns create table mytable (name char(10)) insert into mytable values ('Hello world')

// close the connection mysql_close(connection) The following functions returns the next row from a recordset as an Object Object = rdo_fetch_object(resultset as Object) Object = rdo_fetch_row(resultset as Object) Object = mysql_fetch_object(resultset as Object) Object = mysql_fetch_row(resultset as Object)

The mysql_num_rows() function returns the number of rows in a recordset Numeric = rdo_num_rows(resultset as Object) Numeric = mysql_num_rows(resultset as Object)

Returns the number of fields in a recordset Numeric = rdo_num_fields(resultset as Object) Numeric = mysql_num_fields(resultset as Object)

The mysql_data_seek() function moves the internal row pointer Numeric = rdo_data_seek(Resultset as Object, Row as Numeric) Numeric = mysql_data_seek(Resultset as Object, Row as Numeric)

The mysql_field_seek() function jumps to a specified field in a recordset Numeric = rdo_field_seek(Resultset as Object, Column as Numeric) Numeric = mysql_field_seek(Resultset as Object, Column as Numeric)

The mysql_fetch_field() function returns an object containing information of a field from a recordset Object = rdo_fetch_field(Resultset as Object, Column as Numeric) Object = mysql_fetch_field(Resultset as Object, Column as Numeric)

The mysql_fetch_lengths() function returns the length of the contents of each field in a row Object = rdo_fetch_lengths(Resultset as Object) Object = mysql_fetch_lengths(Resultset as Object)

The mysql_field_table() function returns the name of the table where a specified field is located Character = rdo_field_table(Resultset as Object, int field_offset) Character = mysql_field_table(Resultset as Object, int field_offset)

The mysql_field_name() function returns the name of a field in a recordset Character = rdo_field_name(Resultset as Object, Column as Numeric) Character = mysql_field_name(Resultset as Object, Column as Numeric)

The mysql_field_type() function returns the type of a field in a recordset Character = rdo_field_type(Resultset as Object, Column as Numeric) Character = mysql_field_type(Resultset as Object, Column as Numeric)

The mysql_field_len() function returns the length of a field in a recordset Numeric = rdo_field_len(Resultset as Object, Column as Numeric) Numeric = mysql_field_len(Resultset as Object, Column as Numeric)

The mysql_field_flags() function returns the flags of a field in a recordset Character = rdo_field_flags(Resultset as Object, Column as Numeric) Character = mysql_field_flags(Resultset as Object, Column as Numeric)

The mysql_result() function returns the value of a field in a recordset Character = rdo_result(Resultset as Object, Row as Numeric, char field) Character = mysql_result(Resultset as Object, Row as Numeric, char field)

The mysql_free_result() function frees memory used by a result handle Numeric = rdo_free_result(Resultset as Object) Numeric = mysql_free_result(Resultset as Object)

The mysql_free_object() function frees memory used by an object Numeric = rdo_free_object(Resultset as Object) Numeric = mysql_free_object(Resultset as Object)

The mysql_real_escape_string() function escapes special characters in a string for use in an SQL statement Character = rdo_real_escape_string(string as character [, Connection as Numeric] ) Character = mysql_real_escape_string(string as character [, Connection as Numeric] )

The mysql_info() function returns information about the last query Character = rdo_info( [Connection as Numeric ] ) Character = mysql_info( [Connection as Numeric ] )

The mysql_ping() function pings a server connection or reconnects to it if there is no connection Numeric = rdo_ping( [Connection as Numeric] ) Numeric = mysql_ping( [Connection as Numeric] )

The mysql_thread_id() function returns the current thread ID Numeric = rdo_thread_id() Numeric = mysql_thread_id()

The mysql_stat() function returns the current system status of Recital Numeric = rdo_stat( [Connection as Numeric] ) Numeric = mysql_stat( [Connection as Numeric] )

The mysql_get_client_info() function gets information about Recital Character = rdo_get_client_info() Character = mysql_get_client_info()

The mysql_get_host_info() function gets information about Recital Character = rdo_get_host_info() Character = mysql_get_host_info()

See Also

rdo_get_client_info(), rdo_get_host_info(), rdo_info(), rdo_ping(), rdo_stat(), rdo_thread_id()