PHP Classes

File: phpdoc/files/index.php.txt

Recommend this page to a friend!
  Classes of Victor Henrique Pereira   DB Manager Logger   phpdoc/files/index.php.txt   Download  
File: phpdoc/files/index.php.txt
Role: Documentation
Content type: text/plain
Description: Documentation
Class: DB Manager Logger
Execute and log MySQL queries using PDO
Author: By
Last change:
Date: 9 years ago
Size: 3,149 bytes
 

Contents

Class file image Download
<?php /** * This class uses the PDO library to access and perform queries in a MySQL server * It's safe, fast and all changes are logged into a file for future audit. * * 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., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. */ /** * Set the default locale */ setlocale(LC_ALL, "pt_BR", "pt_BR.iso-8859-1", "pt_BR.utf-8", "portuguese"); /** * Set the default timezone */ date_default_timezone_set('America/Sao_Paulo'); /** * The host of the mysql server */ define('DB_HOST', 'localhost'); /** * The port of the mysql server */ define('DB_PORT', 3306); /** * The user of the mysql server */ define('DB_USER', 'root'); /** * The password of the mysql server */ define('DB_PASS', 'admin'); /** * The database to connect */ define('DB_NAME', 'extalia'); /** * The database encoding (used to insert and update statements) */ define('DB_ENCODING', 'utf8'); require_once(__DIR__ . '/vendor/autoload.php'); $pdo = DBManagerLogger::getInstance(); ################### INSERT STATEMENT ################### $paramIns = array( 'login' => 'adm2', 'password' => '0DPiKuNIrrVmD8IUCuw1hQxNqZc=', 'access_level' => 100, 'vip_level' => 4, 'email' => 'root@vmendonca.com.br' ); $insert = $pdo->createInsert('accounts', $paramIns); $resultInsert = $pdo->query($insert); ################### UPDATE STATEMENT ################### $paramUpd = array( 'access_level' => -400, 'vip_level' => 5, ); $paramCond = array( 'login' => array(DBManagerLogger::COL_EQUAL => array('adm2' => 'and')), 'email' => array(DBManagerLogger::COL_EQUAL => array('root@vmendonca.com.br' => null)) ); $update = $pdo->createUpdate('accounts', $paramUpd, $paramCond); $resultUpdate = $pdo->query($update); ################### DELETE STATEMENT ################### $paramDel = array('login' => array(DBManagerLogger::COL_EQUAL => array('adm2' => null))); $delete = $pdo->createDelete('accounts', $paramDel); $resultDelete = $pdo->query($delete); ################### SELECT STATEMENT ################### $paramSelect = array('login', 'email', 'access_level', 'vip_level'); $paramWhere = array( 'login' => array(DBManagerLogger::COL_LIKE => array('adm' => 'and')), 'email' => array(DBManagerLogger::COL_LIKE => array('mend' => null)) ); $paramOrder = array( 'fields' => array('access_level', 'vip_level'), 'order' => 'ASC' ); $select = $pdo->createSelect('accounts', $paramSelect, $paramWhere, $paramOrder); $resultSelect = $pdo->select($select); unset($pdo);