Login   Register  
PHP Classes
elePHPant
Icontem

Class: MySQL Collection

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ricardo Costa  >  MySQL Collection  >  Download .tar.gz .zip  >  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
Related classes: , , , , , , ,
Version: -
PHP version: -
License: GNU General Public License (GPL)
All time users: 2509 users
All time rank: 1254
Week users: 2 users
Week rank: 1701
Picture of Ricardo Costa
Author: Ricardo Costa <e-mail contact>
Packages: 9 Browse this author's classes Browse this author's classes
Country: Brazil Brazil - PHP jobs in Brazil
Age: 33
All time rank: 241 in Brazil Brazil
Week rank: 212 Down15 in Brazil Brazil Down


  Detailed description  
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

 

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

  Rate classes User ratings   Applications   Files Files  

  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.