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

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);