File: README.md

Recommend this page to a friend!

README.md

File:	`README.md`
Role:	Auxiliary data
Content type:	`text/markdown`
Description:	Auxiliary data
Class:	DPManager Build SQL queries from parameter values
Author:	By Isaac Trenado Mx
Last change:	Added files via upload
Date:	8 years ago
Size:	`42,104 bytes`

Download

<pre style='color:#000000;background:#ffffff;'><?php /  * DropsizeMVCf - extension of the SlimFramework and others tools  *  * @author Isaac Trenado <isaac.trenado@codigolimpio.com>  * @copyright 2013 Isaac Trenado  * @link http://dropsize.codigolimpio.com  * @license http://dropsize.codigolimpio.com/license.txt  * @version 3.0.1  * @package DropsizeMVCf  *  * DropsizeMVCf - Web publishing software  * Copyright 2015 by the contributors  *  * This program is free software; you can redistribute it and/or modify  * it under the terms of the GNU General Public License as published by  * the Free Software Foundation; either version 2 of the License, or  * (at your option) any later version.  *  * This program is distributed in the hope that it will be useful,  * but WITHOUT ANY WARRANTY; without even the implied warranty of  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the  * GNU General Public License for more details.  *  * You should have received a copy of the GNU General Public License  * along with this program; if not, write to the Free Software  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA  *  * This program incorporates work covered by the following copyright and  * permission notices:  *  * DropsizeMVCf is (c) 2013, 2015  * Isaac Trenado - isaac.trenado@codigolimpio.com -  * http://www.codigolimpio.com  *  * Wherever third party code has been used, credit has been given in the code's comments.  *  * DropsizeMVCf is released under the GPL  *  */ /  * Ejemplo 1 Interactura con DPManager  *  * @package com.dropsizemvcf  * @author Isaac Trenado  * @since 1.0.0  */ include "./DPManager-Basic.php"; /  * Ejemplos  *  * buildDatosToUpdate Construye cadena CAMPO = '$valor', CAMPO = '$valor'  * buildSelectQuery Construye cadena SELECT CAMPO, CAMPO FROM  * TABLA WHERE CAMPO = '$cadena'  * GROUP BY CAMPO ORDER BY CAMPO  * buildDeleteQuery Construye cadena DELETE FROM TABLA WHERE CAMPO = '%cadena'  * 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  *  * // 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' )  *  */ $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&oacute;n de m&eacute;todo anonimo a cada uno " . "de los elementos del objeto o arreglo</h1>"; echo "<pre>"; print_r($result); echo "</pre>"; </pre>

About us

Advertise on this site

For more information send a message to info at phpclasses dot org.

File: README.md

Contents