PHP sanitizeCreateCommandの例

コード例 #1

ファイル: showinfo.php プロジェクト: onyxnz/quartzpos

 function processRequest(&$db)
 {
     $extraMsg = '';
     $type = $_REQUEST["id"];
     $name = $_REQUEST["name"];
     $cmd = $db->getCreateCommand($type, $name);
     $cmd = sanitizeCreateCommand($type, $cmd);
     //$tm = $db->getQueryTime();
     $replace = array('TYPE' => $type, 'NAME' => $name, 'COMMAND' => $cmd);
     echo view('showinfo', $replace);
 }

コード例 #2

ファイル: showcreate.php プロジェクト: guohuadeng/stampApp

/**
 * This file is a part of MyWebSQL package
 *
 * @file:      modules/showcreate.php
 * @author     Samnan ur Rehman
 * @copyright  (c) 2008-2014 Samnan ur Rehman
 * @web        http://mywebsql.net
 * @license    http://mywebsql.net/license
 */
function processRequest(&$db)
{
    Session::del('select', 'result');
    Session::del('select', 'pkey');
    Session::del('select', 'ukey');
    Session::del('select', 'mkey');
    Session::del('select', 'unique_table');
    Session::set('select', 'result', array());
    $extraMsg = '';
    $type = $_REQUEST["id"];
    $name = $_REQUEST["name"];
    $cmd = $db->getCreateCommand($type, $name);
    $cmd = sanitizeCreateCommand($type, $cmd);
    $tm = $db->getQueryTime();
    $sql = $db->getLastQuery();
    $sql = preg_replace("/[\n\r]/", "<br/>", htmlspecialchars($sql));
    $replace = array('TYPE' => $type, 'NAME' => $name, 'COMMAND' => $cmd, 'TIME' => $tm, 'SQL' => $sql, 'MESSAGE' => $extraMsg);
    echo view('showcreate', $replace);
}