* Select Query Query Example 2
* con agrupamiento
*
* // Output : SELECT sum(CAMPO) FROM NOMBRE_TABLA WHERE CAMPO = 'cadena' GROUP BY CAMPO
*
*/
$lstSelectQuery2 = DPManager::buildSelectQuery("sum(CAMPO)", "NOMBRE_TABLA", "CAMPO = 'cadena' ", "CAMPO");
echo "<h1>Build group Query From correct params</h1>";
echo $lstSelectQuery2;
/**
* Select Query Query Example 3
* con Ordenamiento
*
* Output : SELECT 'Valor 1' , 'Valor 2' , 'Valor 3' FROM NOMBRE_TABLA WHERE CAMPO = 'cadena' ORDER BY CAMPO DESC
*/
$lstSelectQuery3 = DPManager::buildSelectQuery(implode(",", $larFields), "NOMBRE_TABLA", "CAMPO = 'cadena' ", false, "CAMPO", "DESC");
echo "<h1>Build Simple Query From Order By Params</h1>";
echo $lstSelectQuery3;
/**
* DELETE Query Example 1
*
* Output : DELETE FROM NOMBRE_TABLA WHERE CAMPO = 'cadena'
*
*/
$lstDeleteQuery1 = DPManager::buildDeleteQuery("NOMBRE_TABLA", "CAMPO = 'cadena' ");
echo "<h1>Build Simple Delete Query From Params</h1>";
echo $lstDeleteQuery1;
/**
* INSERT Query Example 1
*
* Output : INSERT INTO NOMBRE_TABLA ( CAMPO1,CAMPO2,CAMPO3) VALUES ( 'Valor 1' , 'Valor 2' , 'Valor 3' )
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%'
*/
* * Result : * * ["1","Super","Chinazo","Poderoso"] * * NiceFormat : jsonlint.com * * [ * ["1", "Super", "Chinazo", "Poderoso"], * ["2", "Will", "Smith", "Ricardo"], * ["3", "Maicol", "Torres", "Fuertes"] * ] * */ $lstJSONArrayField = DPManager::buildSingleArrayFieldJsonTo($model); $lstSelectJSONArrayQuery = DPManager::buildSelectQuery($lstJSONArrayField, "tabla", "nombre = 'Super'"); $lstJSONArrayRow = DPManager::getField($con, $lstSelectJSONArrayQuery); echo "<h1>Return Simple JSON Array Record</h1>"; echo "<pre>"; echo "<h3>Query format JSON</h3>"; print_r($lstJSONArrayField); echo "<h3>Query complete JSON Query</h3>"; print_r($lstSelectJSONArrayQuery); echo "<h2>Result</h2>"; print_r($lstJSONArrayRow); echo "</pre>"; /* * * DPManager::setSessionGroupConcatMaxLen($con); * * Output :
