Login   Register  
PHP Classes
elePHPant
Icontem

MySQL Collection

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  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: 34
All time rank: 251 in Brazil Brazil
Week rank: 321 Down22 in Brazil Brazil Down


  Detailed description   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 .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: 2566 users
All time rank: 1303
Week users: 1 user
Week rank: 2173 Down
 
  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 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.