PHP dbConnection::connectの例

コード例 #1

ファイル: class.sms.php プロジェクト: amirmasoud/sms

 function __construct()
 {
     global $prefix;
     $db_connection = new dbConnection();
     $this->link = $db_connection->connect();
     ini_set("soap.wsdl_cache_enabled", "0");
     self::$sms_client = new SoapClient('http://87.107.121.54/post/Send.asmx?wsdl', array('encoding' => 'UTF-8'));
     $this->parameters['username'] = "";
     $this->parameters['password'] = "";
     $this->parameters['from'] = "";
     return $this->link;
 }

コード例 #2

ファイル: class.DAL.php プロジェクト: enakee/mlm

 function __construct()
 {
     $db_Connection = new dbConnection();
     $this->link = $db_Connection->connect();
     return $this->link;
 }

コード例 #3

ファイル: users.php プロジェクト: neevan1e/Done

<?php

require "w2db.php";
require "w2lib.php";
$db = new dbConnection("mysql");
$db->connect("127.0.0.1", "root", "", "test", "3306");
switch ($_REQUEST['name'] . "::" . $_REQUEST['cmd']) {
    case 'users::get-records':
        $sql = "SELECT * FROM users\n\t\t\t\t WHERE ~search~ ORDER BY ~sort~";
        $res = $w2grid->getRecords($sql, null, $_REQUEST);
        $w2grid->outputJSON($res);
        break;
    case 'users::delete-records':
        $res = $w2grid->deleteRecords("users", "userid", $_REQUEST);
        $w2grid->outputJSON($res);
        break;
    case 'user_edit::get-record':
        $sql = "SELECT userid, fname, lname, email, login, password\n\t\t\t\tFROM users \n\t\t\t\tWHERE userid = " . $_REQUEST['recid'];
        $res = $w2grid->getRecord($sql);
        $w2grid->outputJSON($res);
        break;
    case 'user_edit::save-record':
        $res = $w2grid->saveRecord('users', 'userid', $_REQUEST);
        $w2grid->outputJSON($res);
        break;
    default:
        $res = array();
        $res['status'] = 'error';
        $res['message'] = 'Command "' . $_REQUEST['cmd'] . '" is not recognized.';
        $res['postData'] = $_REQUEST;
        $w2grid->outputJSON($res);

コード例 #4

ファイル: data.php プロジェクト: assoftware/w2ui

<?php

require "../server/php/w2db.php";
require "../server/php/w2lib.php";
$dbType = 'postgres';
$db = new dbConnection("postgres");
$db->connect("127.0.0.1", "postgres", "", "postgres", "5432");
// $fname = Array('Vitali', 'Katie', 'John', 'Peter', 'Sue', 'Olivia', 'Thomas', 'Sergei', 'Sue', 'Frank', 'Divia',
//     'Amy', 'Bill', 'Thomas', 'Emma', 'Gloria', 'Jack', 'April', 'Rose');
// $lname = Array('Peterson', 'Rene', 'Johnson', 'Petrov', 'Sannikov', 'Ivanov', 'Smirnov', 'Cuban', 'Twist', 'Sidorov', 'Vasiliev', 'Homchan', 'Stalone',
//     'Cruz', 'Mascovits', 'Welldo', 'Duck', 'Green', 'Silver', 'Behe', 'Gould');
// for ($i=1; $i<=0; $i++) {
//     $fname1 = $fname[rand(0, count($fname)-1)];
//     $lname1 = $lname[rand(0, count($lname)-1)];
//     $sql = "INSERT INTO people (fname, lname, email, manager)
//             VALUES('".$fname1."',
//                    '".$lname1."',
//                    '".strtolower(substr($fname1, 0, 1).$lname1)."@mail.com',
//                    '".$lname[rand(0, count($lname)-1)]."')";
//     $db->execute($sql);
//     if ($i % 100 == 0) { print("*"); ob_flush(); flush(); }
// }
switch ($_REQUEST['name'] . "::" . $_REQUEST['cmd']) {
    case 'grid::get-records':
        $sql = "SELECT * FROM (SELECT * FROM people ORDER BY OID LIMIT 224) as sub\n                WHERE ~search~ ORDER BY ~sort~";
        $res = $w2grid->getRecords($sql, null, $_REQUEST);
        $w2grid->outputJSON($res);
        break;
    default:
        $res = array();
        $res['status'] = 'error';