Пример #1
7
 /**
  * Constructor.
  *
  * Connects to database with given connection string.
  *
  * @param string  $dsn        The connection string.
  * @param boolean $persistent Whether or not to establish a persistent connection.
  *
  * @throws SQLAnywhereException
  */
 public function __construct($dsn, $persistent = false)
 {
     $this->connection = $persistent ? @sasql_pconnect($dsn) : @sasql_connect($dsn);
     if (!is_resource($this->connection) || get_resource_type($this->connection) !== 'SQLAnywhere connection') {
         throw SQLAnywhereException::fromSQLAnywhereError();
     }
     // Disable PHP warnings on error.
     if (!sasql_set_option($this->connection, 'verbose_errors', false)) {
         throw SQLAnywhereException::fromSQLAnywhereError($this->connection);
     }
     // Enable auto committing by default.
     if (!sasql_set_option($this->connection, 'auto_commit', 'on')) {
         throw SQLAnywhereException::fromSQLAnywhereError($this->connection);
     }
     // Enable exact, non-approximated row count retrieval.
     if (!sasql_set_option($this->connection, 'row_counts', true)) {
         throw SQLAnywhereException::fromSQLAnywhereError($this->connection);
     }
 }
Пример #2
1
 public function __construct($calc_id, $score_id)
 {
     $this->calc_id = $calc_id;
     //подключения к базе
     $this->con = sasql_connect("UID=dba;PWD=gjknfdf_rhtlbns;SERVER=app_12;DBN=lease12;HOST=front");
     $this->con1 = sasql_connect("UID=dba;PWD=sql;SERVER=test_12;DBN=father;HOST=front_test");
     //        $this->con2 = sasql_connect( "UID=dba;PWD=gjknfdf_rhtlbns;SERVER=test_12;DBN=father;HOST=front_test" );
     //информацыя о машине
     $q = 'select * from calc_pars where calc_id = ' . $this->calc_id;
     $res = sasql_query($this->con, $q);
     $this->car = sasql_fetch_array($res);
     //        $this->printArr($this->car);
     //информацыя о заказчике
     $q1 = 'SELECT * FROM "DBA"."физ_лица_nst" LEFT  JOIN Applications on Applications.app_client_id="физ_лица_nst".ID
             LEFT JOIN app_calc on Applications.app_id=app_calc.app_id where app_calc.calc_id=' . $this->calc_id;
     $res = sasql_query($this->con, $q1);
     $this->users = sasql_fetch_array($res);
     //        $this->printArr($this->users);
     //id_scoring
     //        $q = 'select score_id.nextval';
     //        $res = sasql_query($this->con, $q );
     //        $res1 = sasql_fetch_array($res);
     //        $this->score_id = $res1['nextval'];
     if ($score_id == false) {
         $q = 'select score_id.nextval';
         $res = sasql_query($this->con, $q);
         $res1 = sasql_fetch_array($res);
         $this->score_id = $res1['nextval'];
     } else {
         $this->score_id = $score_id;
     }
     //        var_dump($this->score_id);
 }
 /**
  * Create connection fybase
  * @param string  $dns        String connection for sybase
  * @param boolean $persistent Define connection for persistent
  */
 function __construct($dns, $autocommit = true, $persistent = false)
 {
     $this->dns = $dns;
     $this->persistent = $persistent;
     $this->autocommit = $autocommit;
     if (!function_exists('sasql_connect')) {
         throw new Exception("SQL Anywhere model not install in this server!", 100);
     }
     // Verifica se a conexão é persistente
     if ($this->persistent) {
         $this->connection = sasql_pconnect($this->dns);
     } else {
         $this->connection = sasql_connect($this->dns);
     }
     if (!$this->connection) {
         throw new Exception("Connection Problem :: " . sasql_error(), 101);
     }
     // Define option auto_commit
     if ($this->connection) {
         sasql_set_option($this->connection, 'auto_commit', $this->autocommit ? 'on' : 0);
         $this->dbinfo = array($dns, $autocommit, $persistent);
     }
 }
Пример #4
0
 public function __construct($calc_id)
 {
     $this->calc_id = $calc_id;
     //подключения к базе
     $this->con = sasql_connect("UID=dba;PWD=gjknfdf_rhtlbns;SERVER=app_12;DBN=lease12;HOST=front");
     //информацыя о машине
     $q = 'select * from calc_pars where calc_id = ' . $this->calc_id;
     $res = sasql_query($this->con, $q);
     $this->car = sasql_fetch_array($res);
     //        $this->prn($this->car);
     $q = 'SELECT * FROM "DBA"."s_mark" where id = ' . $this->car['mark_id'];
     $res = sasql_query($this->con, $q);
     $this->mark = sasql_fetch_array($res);
     $this->model = $this->car['mark_id'];
     $q = 'select month_id, debt*-1 as debt from Graphics_Calc where calc_id = ' . $this->calc_id;
     //        $this->prn($q);
     $res = sasql_query($this->con, $q);
     //        $this->ulf_pay = sasql_fetch_array($res);
     while ($row = sasql_fetch_array($res)) {
         $this->ulf_pay[$row['month_id']] = $row['debt'];
     }
     //        $this->prn($this->ulf_pay);
 }
Пример #5
0
 /**
  * Non-persistent database connection
  *
  * @access	private called by the base class
  * @return	resource
  */
 function db_connect()
 {
     //		return @sasql_connect("Dbn=$this->database;UID=$this->username;PWD=$this->password;ServerName=$this->server_name");
     return @sasql_connect("UID=dba;PWD=gjknfdf_rhtlbns;SERVER=app_12;DBN=lease12;HOST=front");
 }
<?php

require_once "../config.php";
$res = sasql_connect($sasql_conn);
require "../../codebase/grid_connector.php";
require "../../codebase/db_sasql.php";
$grid = new GridConnector($res, "SaSQL");
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
$grid->render_table("Contacts", "ID", "Surname,GivenName,Title");
Пример #7
0
 /**
  * Non-persistent database connection
  *
  * @access	private called by the base class
  * @return	resource
  */
 function db_connect()
 {
     return @sasql_connect($this->_connect_string());
 }
Пример #8
-1
 public function __construct($calc_id)
 {
     $this->calc_id = $calc_id;
     //подключения к базе
     $this->con = sasql_connect("UID=dba;PWD=gjknfdf_rhtlbns;SERVER=app_12;DBN=lease12;HOST=front");
     $q1 = 'SELECT * FROM "DBA"."физ_лица_nst" LEFT  JOIN Applications on Applications.app_client_id="физ_лица_nst".ID
             LEFT JOIN app_calc on Applications.app_id=app_calc.app_id where app_calc.calc_id=' . $this->calc_id;
     $res = sasql_query($this->con, $q1);
     $this->users = sasql_fetch_array($res);
     $this->inn = $this->users['ИНН'];
     //        $this->inn = '2905602379';
     $this->lnameua = $this->users['Фамилия'];
     //        $this->lnameua = 'Нікітін';
     $this->fnameua = $this->users['Имя'];
     //        $this->fnameua = 'Андрій';
     $this->mnameua = $this->users['Отчество'];
     //        $this->mnameua = 'Іванович';
     $this->pser = $this->users['Паспорт_Серия'];
     //        $this->pser = 'КН';
     $this->pnom = $this->users['Паспорт_Номер'];
     //        $this->pnom = '925600';
     $this->bdate = $this->users['Дата_Рождения'];
     //        $this->bdate = '1969-06-17';
     //        $this->prn($this->users);
 }