PHP Classes
Icontem

Class: MySQL Collection


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ricardo Costa  >  MySQL Collection  >  Download  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: MySQL Collection Support forum
Base name: mysqlcollection
Description: Full class to manage connection, data and log
Related top rated classes: ,
Version: -
Required PHP version: -
License: GNU General Public License (GPL)
All time users: 2404 users
All time rank: 1036
Week users: 2 users
Week rank: 2595
 
  Author   Group folder image Groups   Detailed description  
  Rate classes User ratings   Applications   Files Files  

Author

Picture of Ricardo Costa
Name: Ricardo Costa <e-mail contact>
Published packages: 9 Browse this author's classes Browse this author's classes
Country: Brazil Brazil - PHP jobs in Brazil
Home page: http://www.icorp.com.br/
Age: 31
All time rank: 21
Week rank: 69

Groups

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

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

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

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.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products