PHP TMCms\DB SQL::getInstance Exemples

Exemple #1

Fichier : Boot.php Projet : neTpyceB/TMCms-core

/**
 * @param string $q
 * @param bool $protect
 * @return array
 */
function q_pairs($q, $protect = true)
{
    return SQL::getInstance()->q_pairs($q, $protect);
}

Exemple #2

Fichier : TableStructure.php Projet : neTpyceB/TMCms-core

 public function resetAutoIncrement()
 {
     if (!$this->table_name) {
         dump('Table name is not set');
     }
     SQL::getInstance()->sql_query('ALTER TABLE `' . $this->table_name . '` AUTO_INCREMENT = 1');
     return $this;
 }

Exemple #3

Fichier : send_js_error.php Projet : neTpyceB/TMCms-core

<?php

use TMCms\DB\SQL;
use TMCms\Log\Errors;
if (!defined('INC')) {
    define('INC', true);
}
if (!defined('MODE')) {
    define('MODE', 'site');
}
if (stripos(USER_AGENT, 'bot') !== false) {
    return;
}
$msg = isset($_GET['msg']) ? $_GET['msg'] : '';
$stack = isset($_GET['stack']) ? $_GET['stack'] : '';
$url = isset($_GET['url']) ? $_GET['url'] : '';
$line = isset($_GET['line']) ? $_GET['line'] : '';
Errors::notify_devs(CFG_DOMAIN . ' JavaScript error', 'Message: ' . $msg . "\nClicks Stack: " . $stack . "\nURL: " . $url . "\nLine: " . $line);
// Write log if DB available
if (!SQL::getInstance()->getConnectionHandler()) {
    return;
}
q('INSERT INTO `cms_error_log` (
    `ts`, `ip_long`, `agent`,
    `type`, `msg`, `file`,
    `line`, `vars`
) VALUES (
    "' . NOW . '", "' . ip2long(IP) . '", "' . USER_AGENT . '",
    "JS", "' . sql_prepare($msg) . '", "' . sql_prepare($url) . '",
    "' . sql_prepare($line) . '", "' . sql_prepare($stack) . '"
)');