<?php include "./DPManager-Basic.php"; $cliente = array(); // Arreglo asociativo $cliente['id_cliente'] = 1; $cliente['nombre'] = "'Héctor'"; $cliente['paterno'] = "'Hérnandez'"; $cliente['materno'] = "'Rivera'"; // UPDATE tabla SET [campo = '1'[, campo2 = '2']] $lstGetSetToUpdate = DPManager::buildDatosToUpdate($cliente); echo "<hr />"; echo $lstGetSetToUpdate; 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%' ");
* buildInsertQuery Construye cadena INSERT INTO TABLA (CAMPO, CAMPO) VALUES ('$cadena', '$cadena'); * buildUpdateQuery Construye cadena UPDATE TABLA SET CAMPO = '%s', CAMPO = '%s' * WHERE CAMPO = '%s' * */ /** * Build Datos to update Query * * // Output : CAMPO1 = 'Valor 1' ,CAMPO2 = 'Valor 2' ,CAMPO3 = 'Valor 3' * */ $larFields = array(); $larFields['CAMPO1'] = " 'Valor 1' "; $larFields['CAMPO2'] = " 'Valor 2' "; $larFields['CAMPO3'] = " 'Valor 3' "; $lstUpdateQuery = DPManager::buildDatosToUpdate($larFields); echo "<h1>Build Update Set Query</h1>"; echo $lstUpdateQuery; /** * Select Query Query Example 1 * inicializando todos los parametros * * // Output : SELECT 'Valor 1' , 'Valor 2' , 'Valor 3' FROM NOMBRE_TABLA WHERE CAMPO = 'cadena' LIMIT 0, 10 * */ $lstSelectQuery = DPManager::buildSelectQuery(implode(",", $larFields), "NOMBRE_TABLA", "CAMPO = 'cadena' ", false, false, false, "LIMIT 0, 10"); echo "<h1>Build Simple Select from correct params</h1>"; echo $lstSelectQuery; /** * Select Query Query Example 2 * con agrupamiento