mysql Class Reference
[MYSQL-Class]

List of all members.

Public Member Functions
	mysql ()
	Class Constructor.
	_mysql ()
	Class Destructor.
	sql_clear_table ($table)
	Clear a complete datatable.
	sql_close ()
	Close your database server connection.
	sql_connect ($server, $user, $pwd, $database="")
	Build up a connection to SQL server and database.
	sql_fetch_row ($data)
	Fetch data array of SQL database.
	sql_flush_errors ()
	Will flush the complete sql error buffer.
	sql_get_errorlist ()
	Returns an error list.
	sql_getlast_entry ($table, $col)
	Return the last entry in SQL database.
	sql_getlast_query ()
	Return last SQL query.
	sql_getnrof_lines ($table)
	Return number of lines in datatable.
	sql_open_database ($database)
	Open database.
	sql_query ($command)
	Sends a command to database.
	sql_trimcol ($table, $name)
	Trim selected Column in database.
	sql_add_errors ()
	Add last error to error list.
Public Attributes
	$sql_error_hdl = 0
	$sql_host
	$sql_handle = false
	$sql_lgn
	$sql_pwd
	$sql_query

---

Constructor & Destructor Documentation

function mysql::mysql (   )

Class Constructor.

---

Member Function Documentation

function mysql::_mysql (   )

Class Destructor.

function mysql::sql_add_errors (   )

Add last error to error list. Returns: State = true or false

funtion mysql::sql_clear_table (  $  table  )

Clear a complete datatable. Parameters: $table  = Name of datatable Returns: State = true or false

function mysql::sql_close (   )

Close your database server connection. Returns: State = true or false

function mysql::sql_connect (  $  server, $  user, $  pwd, $  database = "" )

Build up a connection to SQL server and database. Parameters: $server  = SQL server adress $user  = Database user $pwd  = Database password $database  = Database name. If database is not set, the function will only establish a server connection. Returns: State = true or false

function mysql::sql_fetch_row (  $  data  )

Fetch data array of SQL database. Parameters: $data  = Data to fetch Returns: $row = Row data array

function mysql::sql_flush_errors (   )

Will flush the complete sql error buffer. Returns: State = true or false

function mysql::sql_get_errorlist (   )

Returns an error list. Returns: Error list

function mysql::sql_getlast_entry (  $  table, $  col )

Return the last entry in SQL database. Note: YOU NEED FOR THIS FUNCTION THE "ID" column !!! Parameters: $table  = Name of database table $col  = Number of column Returns: $result = Last SQL entry

function mysql::sql_getlast_query (   )

Return last SQL query. Returns: $query = Last SQL query

function mysql::sql_getnrof_lines (  $  table  )

Return number of lines in datatable. Parameters: $table  = Name of database table Returns: State = Number of lines

function mysql::sql_open_database (  $  database  )

Open database. Parameters: $database  = Database name Returns: State = true or false

function mysql::sql_query (  $  command  )

Sends a command to database. Parameters: $command  = Database command Returns: State = true or false

function mysql::sql_trimcol (  $  table, $  name )

Trim selected Column in database. Parameters: $name  = Name of database column $table  = Name of database table Returns: State = true or false

---

Member Data Documentation

mysql::$sql_error_hdl = 0

Error message handler

mysql::$sql_handle = false

Handle to SQL database

mysql::$sql_host

SQL host

mysql::$sql_lgn

SQL login name

mysql::$sql_pwd

SQL password

mysql::$sql_query

Last SQL query

---

The documentation for this class was generated from the following file:

• mysql.php

---