PHP system_db_layer Examples

Example #1

File: system_db_layer.class.test.php Project: notUserDeveloper/fl-ru-damp

 function testSettings()
 {
     try {
         $e = system_db_layer::getInstance()->select("SELECT * FROM users LIMIT 1;")->fetchAll();
     } catch (Exception $v) {
     }
     $this->assertTrue(sizeof($e) == 1, "Select from users error");
     $e = false;
     try {
         $e = system_db_layer::getInstance()->select("SELECT * FROM users LIMIT 1;")->fetchRow();
     } catch (Exception $v) {
     }
     $this->assertTrue(sizeof($e) > 1, "Select Row from users error");
     $e = false;
     try {
         $e = system_db_layer::getInstance()->select("SELECT * FROM users LIMIT 1;")->fetchOne();
     } catch (Exception $v) {
     }
     $this->assertTrue(sizeof($e) == 1, "Select One Cell from users error");
     $e = false;
     try {
         $e = system_db_layer::getInstance()->select("SELECT * FROM users WHERE uid > ? LIMIT 1;", 10000)->fetchRow();
     } catch (Exception $v) {
     }
     $this->assertTrue(sizeof($e) > 1, "Select Row with placeholder from users error");
     $this->assertTrue(false, "Ошибка функции биллинга");
     $this->assertTrue(false, "Нет класса");
     $this->assertTrue(false, "Не правильно возвращен результат пользователя");
 }

Example #2

File: system_db_layer.class.test.php Project: Nikitian/fl-ru-damp

 function testSettings()
 {
     try {
         $e = system_db_layer::getInstance()->select("SELECT * FROM users LIMIT 1;")->fetchAll();
     } catch (Exception $v) {
     }
     $this->assertTrue(sizeof($e) == 1, "Select from users error");
     $e = false;
     try {
         $e = system_db_layer::getInstance()->select("SELECT * FROM users LIMIT 1;")->fetchRow();
     } catch (Exception $v) {
     }
     $this->assertTrue(sizeof($e) > 1, "Select Row from users error");
     $e = false;
     try {
         $e = system_db_layer::getInstance()->select("SELECT * FROM users LIMIT 1;")->fetchOne();
     } catch (Exception $v) {
     }
     $this->assertTrue(sizeof($e) == 1, "Select One Cell from users error");
     $e = false;
     try {
         $e = system_db_layer::getInstance()->select("SELECT * FROM users WHERE uid > ? LIMIT 1;", 10000)->fetchRow();
     } catch (Exception $v) {
     }
     $this->assertTrue(sizeof($e) > 1, "Select Row with placeholder from users error");
     $this->assertTrue(false, "Ошибка функции биллинга");
     $this->assertTrue(false, "Нет класса");
     $this->assertTrue(false, "Не правильно возвращен результат пользователя");
 }

Example #3

File: init.php Project: kapai69/fl-ru-damp

foreach ($_REQUEST as $k => $v) {
    $front_req[$k] = $v;
}
require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/stdf.php';
require_once 'const.php';
include_once getcwd() . '/engine/system/front.class.php';
include_once 'function.php';
session_start();
get_uid();
define('DIR_SEP', DIRECTORY_SEPARATOR);
define('ROOT_DIR', getcwd() . DIR_SEP);
spl_autoload_register(array('front', 'load_class'));
define('URI', $_SERVER['REQUEST_URI']);
include_once ROOT_DIR . 'engine/structure.php';
system_db_layer::setConnection(DBConnect());
front::os('db', system_db_layer::getInstance());
front::os('tpl', new system_tpl_layer());
front::og('tpl')->set('host', $host);
front::og('tpl')->set('IS_LOCAL', IS_LOCAL);
front::$_req = $front_req;
front::setMap($map);
if (!defined('NO_URL_MAPPING')) {
    front::exec_uri($_GET['pg']);
    /*
        $req_uri = array_shift(explode("?" ,$_SERVER['REQUEST_URI']));
        if(file_exists(getcwd() . $req_uri)) {
            if(is_file(getcwd() . $req_uri)) {
                include(getcwd() . $req_uri); 
            } elseif(is_dir(getcwd() . $req_uri) ) {
                chdir(getcwd() . $req_uri);  
                include(getcwd() . DIR_SEP . 'index.php'); 

Example #4

File: system_db_layer.class.php Project: kapai69/fl-ru-damp

 /**
  * Установка переменной подключения. Возвращает указатель на соединение c БД.
  *
  * @param resource $conn Указатель на соединение с БД
  *
  * @return Указатель на соединение с БД
  */
 public static function setConnection($conn)
 {
     self::$instanse = new self();
     self::$instanse->connection = $conn;
     return self::$instanse;
 }

Example #5

File: system_db_layer.class.php Project: Nikitian/fl-ru-damp

 /**
  * Установка переменной подключения. Возвращает указатель на соединение c БД
  *
  * @param resource $conn Указатель на соединение с БД
  * @return Указатель на соединение с БД
  */
 static function setConnection($conn)
 {
     self::$instanse = new system_db_layer();
     self::$instanse->connection = $conn;
     return self::$instanse;
 }

Example #6

File: init.php Project: Nikitian/fl-ru-damp

foreach ($_REQUEST as $k => $v) {
    $front_req[$k] = $v;
}
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/stdf.php";
require_once "const.php";
include_once getcwd() . '/engine/system/front.class.php';
include_once 'function.php';
session_start();
get_uid();
define("DIR_SEP", DIRECTORY_SEPARATOR);
define("ROOT_DIR", getcwd() . DIR_SEP);
spl_autoload_register(array('front', 'load_class'));
define("URI", $_SERVER['REQUEST_URI']);
include_once ROOT_DIR . "engine/structure.php";
system_db_layer::setConnection(DBConnect());
front::os("db", system_db_layer::getInstance());
front::os("tpl", new system_tpl_layer());
front::og("tpl")->set("host", $host);
front::og("tpl")->set("IS_LOCAL", IS_LOCAL);
front::$_req = $front_req;
front::setMap($map);
if (!defined("NO_URL_MAPPING")) {
    front::exec_uri($_GET['pg']);
    /*
        $req_uri = array_shift(explode("?" ,$_SERVER['REQUEST_URI']));
        if(file_exists(getcwd() . $req_uri)) {
            if(is_file(getcwd() . $req_uri)) {
                include(getcwd() . $req_uri); 
            } elseif(is_dir(getcwd() . $req_uri) ) {
                chdir(getcwd() . $req_uri);  
                include(getcwd() . DIR_SEP . 'index.php');