Login   Register  
PHP Classes
elePHPant
Icontem

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

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 (12 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 2,600 All time: 1,358 This week: 1,584Down
Version License Categories  
mysqlcollection 1.0GNU General Public Lice...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
Age: 36
All time rank: 271 in Brazil Brazil
Week rank: 341 Down23 in Brazil Brazil Down

  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,600All time:1,358
 This week:0This week:1,584Down