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

  Author Author  
Picture of Ricardo Costa
Name: Ricardo Costa <e-mail contact>
Packages: 9 Browse all classes by Ricardo Costa Browse all classes by
Country: Brazil Brazil - PHP jobs in Brazil
Age: 35
All time rank: 261 in Brazil Brazil
Week rank: 783 Down59 in Brazil Brazil Down


  Detailed description   Download Download .zip .tar.gz  
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

  Classes of Ricardo Costa  >  MySQL Collection  >  Download Download .zip .tar.gz  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: MySQL Collection
Base name: mysqlcollection
Description: Full class to manage connection, data and log
Version: -
PHP version: -
License: GNU General Public License (GPL)
All time users: 2592 users
All time rank: 1334
Week users: 0 users
Week rank: 1765 Equal
 
  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes


  User ratings  
Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file class.mysql.phtml Class Full Collection of MySQL log, connection and recordset functions

Download Download all files: mysqlcollection.tar.gz mysqlcollection.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.