PHP DBUtils::setActiveConnection Examples

Example #1

File: _dbedit.php Project: alex2stf/phpquick

<?php

require_once '../core/DBUtils.php';
DBUtils::setActiveConnection($_POST['connectionName']);
if (isset($_POST['update'])) {
    $r = '';
    for ($i = 0; $i < count($_POST['update']); $i++) {
        $value = $_POST['update'][$i];
        $r .= $value['key'] . '=' . DBUtils::getActiveConnection()->quote($value['value']);
        if ($i < count($_POST['update']) - 1) {
            $r .= ',';
        }
    }
}
if (isset($_POST['where'])) {
    $w = ' WHERE ';
    $buff = array();
    for ($i = 0; $i < count($_POST['where']); $i++) {
        $value = $_POST['where'][$i];
        $w .= $value['key'] . '=' . DBUtils::getActiveConnection()->quote($value['value']);
        if ($i < count($_POST['where']) - 1) {
            $w .= ' AND ';
        }
    }
}
if ($_POST['action'] === 'update') {
    $query = 'UPDATE ' . $_POST['tableName'] . ' SET ' . $r . $w;
} else {
    if ($_POST['action'] === 'delete') {
        $query = 'DELETE FROM ' . $_POST['tableName'] . $w;
    } else {

Example #2

File: DBUtils_config.php Project: alex2stf/phpquick

<?php

DBUtils::$connections[Connectors::$LOCALHOST] = new PDO("mysql:host=localhost;dbname=quizz", "root", "");
DBUtils::setActiveConnection(Connectors::$LOCALHOST);