<?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
