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 This week: 1All time: 4,746 This week: 560Up
Version License PHP version Categories
mysql-lib 1.1GNU General Publi...5Databases
Description 

Author

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: 411 Up26 in India India Up

Details

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 configure.inc Conf. configure.inc
Plain text file connectdb.inc Example connectdb.inc
Plain text file Readme Doc. Readme

 Version Control Unique User Downloads Download Rankings  
 0%
Total:686
This week:1
All time:4,746
This week:560Up