echo "<hr />"; // UPDATE tabla SET campo = '1', campo2 = '2', campo3 = '4' // WHERE campo1 = 'x' $lstUpdateQuery = DPManager::buildUpdateQuery("tabla", $lstGetSetToUpdate, "id_cliente = 3"); echo "<hr />"; echo $lstUpdateQuery; echo "<hr />"; $lstInsertQuery = DPManager::buildInsertQuery($cliente, "tabla"); echo "<hr />"; echo $lstInsertQuery; echo "<hr />"; // select * from tabla order by nombre desc $lstSelectQuery = DPManager::buildSelectQuery("nombre, paterno" . ", concat_ws(',', nombre, paterno) as completo", "tabla", false, false, "nombre", "asc"); echo "<hr />"; echo $lstSelectQuery; echo "<hr />"; // select * from tabla order by nombre desc $lstSelectGroupQuery = DPManager::buildSelectQuery("count(*)", "tabla", " nombre like '%i%' "); echo "<hr />"; echo $lstSelectGroupQuery; echo "<hr />"; // DELETE FROM tabla WHERE id_cliente = 4 $lstDeleteQuery = DPManager::buildDeleteQuery("tabla", " id_cliente = 10"); echo "<hr />"; echo $lstDeleteQuery; echo "<hr />"; /* * OutPut * * id_cliente = 1,nombre = 'H?ctor',paterno = 'H?rnandez',materno = 'Rivera'UPDATE tabla SET id_cliente = 1,nombre = 'H?ctor',paterno = 'H?rnandez',materno = 'Rivera' WHERE id_cliente = 3INSERT INTO tabla ( id_cliente,nombre,paterno,materno) VALUES (1,'H?ctor','H?rnandez','Rivera')SELECT nombre, paterno, concat_ws(',', nombre, paterno) as completo FROM tabla ORDER BY nombre ascSELECT count(*) FROM tabla WHERE nombre like '%i%' */
* */ $lstInsertQuery1 = DPManager::buildInsertQuery($larFields, "NOMBRE_TABLA"); echo "<h1>Build Simple Insert Data From Params array type and table name</h1>"; echo $lstInsertQuery1; /** * UPDATE Query Example 1 * Para este ejemplo, necesitamos construir el SET con DPManager::buildDatosToUpdate($larFields); * * Output : UPDATE NOMBRE_TABLA SET CAMPO1 = 'Valor 1' ,CAMPO2 = 'Valor 2' ,CAMPO3 = 'Valor 3' WHERE CAMPO = 'valor' * */ $lstUpdateQuery1 = DPManager::buildUpdateQuery("NOMBRE_TABLA", $lstUpdateQuery, "CAMPO = 'valor' "); echo "<h1>Build Simple Update From Params array type, table name and condition to affect rows</h1>"; echo $lstUpdateQuery1; /** * Poder iterar resultados de base de datos, Object u Array aplicando un metodo * de regreso * @param array */ $array = array(array(1, 2), array(3, 4)); $result = DPManager::iteraRecord($array, function () { $row = func_get_args(); $uno = $row[0] . "UNO"; $dos = $row[1] . "DOS"; return array($uno, $dos); }); echo "<h1>Aplicación de método anonimo a cada uno " . "de los elementos del objeto o arreglo</h1>"; echo "<pre>"; print_r($result); echo "</pre>";
public static function delete($lobCon, $query) { if ($lobCon->Execute($query) === false) { return 0; } else { self::$affectedRows = $lobCon->Affected_Rows(); return self::$affectedRows; } }
print_r($lstSelectJSONArrayQuery); echo "<h2>Result</h2>"; print_r($lstJSONArrayRow); echo "</pre>"; /* * * DPManager::setSessionGroupConcatMaxLen($con); * * Output : * * ADORecordSet_empty Object * ( * [dataProvider] => empty * [databaseType] => * [EOF] => 1 * [_numOfRows] => 0 * [fields] => * [connection] => * ) * * Result : * * SET SESSION group_concat_max_len = 4294967295 * * */ $lobResult = DPManager::setSessionGroupConcatMaxLen($con); echo "<h1>Increase the limit from GroupConcat Max Length</h1>"; echo "<pre>"; echo "<h3>Query to increase the limit from function Group_concat()</h3>"; print_r($lobResult);