PHP Classes

MySQL DB Lib: Connect and run MySQL queries from parameter lists

Recommend this page to a friend!
  Info   View files View files (6)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 686 All time: 4,749 This week: 488Up
Version License PHP version Categories
mysql-lib 1.1GNU General Publi...5Databases


This package can connect and run MySQL queries from parameter lists.

There is an interface class that can connect to a MySQL database.

Another class can execute SQL SELECT, INSERT, UPDATE and DELETE queries using parameters that define values for table names, fields, field values, conditions, etc..

Picture of Qazi Umar Aadil Shah
Name: Qazi Umar Aadil Shah <contact>
Classes: 3 packages by
Country: India India
Age: 41
All time rank: 117463 in India India
Week rank: 233 Up16 in India India Up


Change the constant values in configuration file. Usegae: SELECT. $argSelectFlds = array('column1','column2'); $argOrderBy = ' order by column name'; $argSearchWhere = 'And where clause'; $varWhereClause = ' 1 '.$argSearchWhere; $argTables = tableName; $arrDataList = $objDBConnect->select($argTables, $argSelectFlds, $varWhereClause, $argOrderBy, $argLimit); UPDATE: $arrUpdate['column1'] = 'value1'; $arrUpdate['column2'] = 'value2'; $varWhere = ' AND column1= "----'; $affectedRows = $objDBConnect->update(Table Name, $arrUpdate, $varWhere); INSERT: $arrUpdate['column1'] = 'value1'; $arrUpdate['column2'] = 'value2'; $affectedRows = $objDBConnect->insert(Table Name, $arrUpdate); Get Num Rows return $objDBConnect->getNumRows(tableName, 'unique id of table', Condition);

  Files folder image Files  
File Role Description
Plain text file class_database_dbl.php Class Database Class
Plain text file class_db_connection Class class_db_connection
Plain text file DB_Interface Class DB Interface
Plain text file Conf.
Plain text file Example
Plain text file Readme Doc. Readme

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:4,749
This week:488Up