MySQL Collection 1.0

MySQL Collection provides you a set of functions to use with your MySQL database.

Functions of Log:
- log() // Create a log file
- addLog() // Append one line in the log file
- show() // Show de log content in HTML format

Properties of Connection:
- application // Name of application
- host // IP or Name of MySQL Server
- login // Login MySql
- senha // Password MySQL
- db // Database
- admMail // E-mail of Admin
- log // Instance o log object
- conID // ID of MySQL Connection

Functions of Connection:
- connection() // Inicialize
- connect() // Conect with MySQL Server return de conID
- close() // Close Connection

Function of RecordSet:
- checkSql() // Protect sql from DROP, CREATE and other
- select() // Select Query
- setRow() // Fetch array
- getLastID() // Return the last inserted ID
- getFieldName() // Return a name o field
- fieldsCount () // Number of Fields
- recordCount() // Number of records
- exec() // Execute a Inser, Update, Delete and others SQL
- erase() // Delete one record by ID
- erases() // Delete various records by Array (Such as checkbox)
- comboBox()
- comboBoxBin()
- insert() // Generate a Insert SQL sentence with POST data
- update() // Generate a Update SQL sentence with POST data
- getForm() // Get POST data

License type: GPL - GNU Public License
Date added: 8 years, 9 months 27 days ago | Last updated: 8 years, 9 months 27 days ago

More popular Database Tool

This is actually one of the most advanced image hosting script. The imagetize key features: SEO, Ads Ready, Admin

Listing Files

mysql-collection
  • class.mysql.phtml
  • 17.2 KB
  • 10/02/2005 21:25:44
Hot Scripts
Sponsors