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%' */
/** * 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' ) * */ $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); *