PHP Classes
elePHPant
Icontem

MySQL Collection: Full class to manage connection, data and log

Recommend this page to a friend!
  Info   View files View files (1)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2002-10-22 (14 years ago) RSS 2.0 feedNot enough user ratingsTotal: 2,623 All time: 1,410 This week: 1,045Up
Version License Categories
mysqlcollection 1.0GNU General Publi...Databases
Description Author

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

Picture of Ricardo Costa
Name: Ricardo Costa <contact>
Classes: 9 packages by
Country: Brazil Brazil

  Files folder image Files  
File Role Description
Plain text file class.mysql.phtml Class Full Collection of MySQL log, connection and recordset functions

 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,623
This week:0
All time:1,410
This week:1,045Up