Writing /home/tachyon/public_html/scripts/data/cache/2/2599a3c09b91ae452e76e89db69c65b5.i failed
Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.
Writing /home/tachyon/public_html/scripts/data/cache/2/2599a3c09b91ae452e76e89db69c65b5.i failed
Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.
Writing /home/tachyon/public_html/scripts/data/cache/2/2599a3c09b91ae452e76e89db69c65b5.xhtml failed

vsns_mysql

Versions: VSNS 4

Description

Database handler for VSNS Lemon. With the exception of the installation, this class handles all database interaction.

In order to be accessible to the other classes, this class should be instantiated as vsns::$db.

Properties

  • private $username
  • private $password
  • private $host
  • public $db
  • public $dbh
  • public $last_error
  • public $last_error_no
  • public $last_id
  • public $last_result
  • public $last_query
  • public $num_rows
  • public $num_queries
  • public $queries
  • public $rows_affected
  • public $status

Methods

  • __construct - Connects to the database
  • __destruct - Closes database connection
  • count - Returns count of rows matching a query
  • delete - Deletes all rows matching the condition
  • error - Throws an error (private)
  • fetch - SELECTs data based on conditions
  • join - Complex SELECT of multiple tables
  • insert - INSERTs data into table
  • query - Complex database queries
  • update - UPDATEs data in tables

See also

 
vsns_lemon/mysql.txt · Last modified: 2008/06/09 16:39 (external edit)
 
Recent changes RSS feed Creative Commons License Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki