Overview  Package  Tree cmsdAm 0.8

cmsdAm

Class cmsdam_mysqldbms

cmsdAm.cmsdam_mysqldbms

class cmsdam_mysqldbms

Mysql support in cmsdAm is integrated in the users and group classes, templates, ecc, so you don't need to call these methods from your sections.

This is for developers only.

Class instance: $cms->mysqldbms

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>

Field Summary
public var$logs

You should not use this variable from your section.

public var$debug

You should not use this variable from your section.

public var$conf

You should not use this variable from your section.

public var$link

You should not use this variable from your section.

public var$db

You should not use this variable from your section.

public var$result

You should not use this variable from your section.

public var$stack

You should not use this variable from your section.

public var$DB_servername

You should not use this variable from your section.

public var$DB_name

You should not use this variable from your section.

public var$DB_username

You should not use this variable from your section.

public var$DB_tbl_prefix

You should not use this variable from your section.

public var$DB_password

You should not use this variable from your section.

public int$db_connected

Contains the connection state of the Mysql DB.

Method Summary
private boolDB_connect

You should not use this method from your sections.

private boolDB_close

You should not use this method from your sections.

private boolstack_pop

You should not use this method from your sections.

private boolstack_push

You should not use this method from your sections.

private booldberror

You should not use this method from your sections.

private booldbconnect

You should not use this method from your sections.

private booldbselect

You should not use this method from your sections.

private booldbquery

You should not use this method from your sections.

private intdbnum_rows

You should not use this method from your sections.

private arraydbfetch_array

You should not use this method from your sections.

private arraydbfetch_row

You should not use this method from your sections.

private booldbclose

You should not use this method from your sections.

Field Detail

logs

public var $logs

You should not use this variable from your section.

Logs class instance.


debug

public var $debug

You should not use this variable from your section.

Debug class instance.


conf

public var $conf

You should not use this variable from your section.

Configuration class instance.


link

public var $link

You should not use this variable from your section.

Mysql link identifier pointer


db

public var $db

You should not use this variable from your section.

Mysql db identifier pointer


result

public var $result

You should not use this variable from your section.

Mysql resultset identifier pointer


stack

public var $stack

You should not use this variable from your section.

Internal stack for nesting queries. You can access to this variable from stack_pop() and stack_push() methods.


DB_servername

public var $DB_servername

You should not use this variable from your section.

DB server name string


DB_name

public var $DB_name

You should not use this variable from your section.

DB name string


DB_username

public var $DB_username

You should not use this variable from your section.

DB user name string


DB_tbl_prefix

public var $DB_tbl_prefix

You should not use this variable from your section.

DB table prefix string


DB_password

public var $DB_password = ""

You should not use this variable from your section.

DB password string


db_connected

public int $db_connected

Contains the connection state of the Mysql DB.

0 = DB not connected
1 = DB connected

Method Detail

DB_connect()

private bool DB_connect()

You should not use this method from your sections.

This method connects to the DBMS and select the DB.

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
False on errors, True on success

DB_close()

private bool DB_close()

You should not use this method from your sections.

This method close the DBMS connection.

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
Always returns True

stack_pop()

private bool stack_pop()

You should not use this method from your sections.

If you want to nest queries you must pop the content from the result stack! The right way is: do the query, cycle on the result set, push the resultset, do another query, pop the resultset and go on.

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
True on success, False if the stack is empty

stack_push()

private bool stack_push()

You should not use this method from your sections.

If you want to nest queries you must push the content from the result stack! The right way is: do the query, cycle on the result set, push the resultset, do another query, pop the resultset and go on.

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
Always returns True

dberror()

private bool dberror(str error,
                     str query = "")

You should not use this method from your sections.

Debug and log mysql errors

Parameters:
error - The error you want to debug, log
query - The query you want to debug, log
Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
Always returns False

dbconnect()

private bool dbconnect()

You should not use this method from your sections.

Makes the connection to the DB with mysql_connect.

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
False on errors, True on success

dbselect()

private bool dbselect()

You should not use this method from your sections.

Makes the DB selection with mysql_select_db.

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
False on errors, True on success

dbquery()

private bool dbquery(var $query)

You should not use this method from your sections.

Makes the DB query with mysql_query.

Parameters:
$query
Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
False on errors, True on success

dbnum_rows()

private int dbnum_rows()

You should not use this method from your sections.

Returns the number of rows in resultset with dbnum_rows.

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
number of rows in resultset

dbfetch_array()

private array dbfetch_array()

You should not use this method from your sections.

Returns the array of rows in resultset with @mysql_fetch_array.

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
array of rows in resultset

dbfetch_row()

private array dbfetch_row()

You should not use this method from your sections.

Returns the last requested row array in resultset with @mysql_fetch_row.

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
last requested row in resultset

dbclose()

private bool dbclose()

You should not use this method from your sections.

Close the DB link with mysql_close.

Author:
dAm2K (Dino Ciuffetti) <dam2k@users.sourceforge.net>
Returns:
Always returns True

Overview  Package  Tree cmsdAm 0.8