PHP database::connect方法代码示例

 public function __construct()
 {
     parent::__construct();
     parent::connect();
     // debug
     //parent::dump();
 }

 public function __construct()
 {
     //connect to the database if not connected
     if (!$this->db) {
         require_once "resources/classes/database.php";
         $database = new database();
         $database->connect();
         $this->db = $database->db;
     }
     //add multi-lingual support
     $language = new text();
     $text = $language->get();
     //get the ringback types
     $sql = "select * from v_vars ";
     $sql .= "where var_cat = 'Defaults' ";
     $sql .= "and var_name LIKE '%-ring' ";
     $sql .= "order by var_name asc ";
     $prep_statement = $this->db->prepare(check_sql($sql));
     $prep_statement->execute();
     $ringbacks = $prep_statement->fetchAll(PDO::FETCH_NAMED);
     unset($prep_statement, $sql);
     foreach ($ringbacks as $ringback) {
         $ringback = $ringback['var_name'];
         $label = $text['label-' . $ringback];
         if ($label == "") {
             $label = $ringback;
         }
         $ringback_list[$ringback] = $label;
     }
     $this->ringbacks = $ringback_list;
     unset($ringback_list);
     //get the default_ringback label
     /*
     $sql = "select * from v_vars where var_name = 'ringback' ";
     $prep_statement = $this->db->prepare(check_sql($sql));
     $prep_statement->execute();
     $result = $prep_statement->fetch();
     unset ($prep_statement, $sql);
     $default_ringback = (string) $result['var_value'];
     $default_ringback = preg_replace('/\A\$\${/',"",$default_ringback);
     $default_ringback = preg_replace('/}\z/',"",$default_ringback);
     #$label = $text['label-'.$default_ringback];
     #if($label == "") {
     	$label = $default_ringback;
     #}
     $this->default_ringback_label = $label;
     unset($results, $default_ringback, $label);
     */
     //get music on hold	and recordings
     if (is_dir($_SERVER["PROJECT_ROOT"] . '/app/music_on_hold')) {
         require_once "app/music_on_hold/resources/classes/switch_music_on_hold.php";
         $music = new switch_music_on_hold();
         $this->music_list = $music->get();
     }
     if (is_dir($_SERVER["PROJECT_ROOT"] . '/app/recordings')) {
         require_once "app/recordings/resources/classes/switch_recordings.php";
         $recordings = new switch_recordings();
         $this->recordings_list = $recordings->list_recordings();
     }
 }

 public function __construct()
 {
     //connect to the database if not connected
     if (!$this->db) {
         require_once "resources/classes/database.php";
         $database = new database();
         $database->connect();
         $this->db = $database->db;
     }
     //set the application specific uuid
     $this->app_uuid = 'b523c2d2-64cd-46f1-9520-ca4b4098e044';
     //set the domain_uuid if not provided
     if (strlen($this->domain_uuid) == 0) {
         $this->domain_uuid = $_SESSION['domain_uuid'];
     }
     //get the voicemail_id
     if (!isset($this->voicemail_id)) {
         $sql = "select voicemail_id from v_voicemails ";
         $sql .= "where domain_uuid = '" . $this->domain_uuid . "' ";
         $sql .= "and voicemail_uuid = '" . $this->voicemail_uuid . "' ";
         $prep_statement = $this->db->prepare(check_sql($sql));
         $prep_statement->execute();
         $result = $prep_statement->fetchAll(PDO::FETCH_NAMED);
         if (is_array($result)) {
             foreach ($result as &$row) {
                 $this->voicemail_id = $row["voicemail_id"];
             }
         }
         unset($prep_statement);
     }
 }

 public function login()
 {
     $database = new database();
     if ($database->get_type() == 'mysql') {
         $db_arr = $database->connect();
         if ($db_arr[0] == 1) {
             return array(1, $db_arr[1]);
         }
         $this->db = $db_arr[1];
         // continue implementing login check
         $this->username = $this->db->escape_string(stripslashes($this->username));
         $this->password = $this->db->escape_string(stripslashes($this->password));
         $getuserquery = "SELECT * FROM user WHERE user_name='" . $this->username . "' AND user_password='" . $this->password . "'";
         $getuserresult = $this->db->query($getuserquery);
         $getuserresult_count = $getuserresult->num_rows;
         if ($getuserresult_count == 0) {
             $this->authstatus = false;
             return array(2, 'Username and password incorrect.');
         } elseif ($getuserresult_count == 1) {
             $this->authstatus = true;
             return array(0, $this->authstatus);
         } else {
             return array(2, 'MySQL returning weird things.');
         }
     } elseif ($database->get_type() == 'sqlite') {
         $db_arr = $database->connect_sqlite();
         $this->db = $db_arr;
         // do things that have yet to be decided
     }
 }

function upload($file_name, $file_type, $file_path, $file_title)
{
    if (!empty($_FILES["fileUpload"]) && !empty($_POST["imgTitle"])) {
        $file_type = $_FILES['fileUpload']['type'];
        $file_title = $_POST["imgTitle"];
        if ($file_type == "image/gif") {
            $file_path = $_FILES['fileUpload']['tmp_name'];
            $file_name = $_FILES['fileUpload']['name'];
            $new_path = "upload/img/" . $file_name;
            $file_error = $_FILES["fileUpload"]["error"];
            if ($file_error == 0 && move_uploaded_file($file_path, $new_path)) {
                $sql = "INSERT INTO gif.images (`title_img`, `name_img`, `id_user`) VALUES ('{$file_title}','{$file_name}', '0');";
                $upload = new database();
                $upload->connect();
                $query = $upload->query($sql);
                if (!empty($query)) {
                    $success = "Upload file và ghi dư liệu thành công.";
                    return $success;
                } else {
                    $success = "Upload file thành công.";
                    return $success;
                }
            }
            return $file_error;
        } else {
            $error = "File không đúng định dạng GIF";
            return $error;
        }
    }
}

 function __construct()
 {
     include_once 'class.database.php';
     $conn = new database();
     $this->link = $conn->connect();
     return $this->link;
 }

function adlib($id, $type)
{
    // create adlib xml basic structure
    $XML = new simpleXmlElement("<?xml version='1.0' encoding='utf-8'?><adlibXML xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:noNamespaceSchemaLocation='http://www.adlibsoft.com/adlibXML.xsd' />");
    echoall("Start Adlib XML export");
    echoall("Connect database");
    $daba = new database();
    $daba->connect("localhost", "iggmp", "1s87J37r0");
    if ($daba->select("thesaurus")) {
        echoall("Database connected");
    } else {
        die("***ERROR - Database connection failed");
    }
    $termType = thesaurus::get_name($id);
    echoall("Starte bei <b>'" . thesaurus::get_name($id) . "'</b>");
    //------------------------------------------------------------------------------
    // create recordList
    xml_insert($XML, new simpleXmlElement("<recordList />"));
    // insert records in recordList
    $subXml = _subtree($id, $termType);
    if ($subXml) {
        xml_insert($XML->recordList, $subXml);
    }
    echoall("XML export completed<hr>");
    echoall($XML);
    return $XML->asXML();
}

function connect_2_db($cfg)
{
    if (!defined('NO_DSN')) {
        define('NO_DSN', FALSE);
    }
    if (strlen(trim($cfg['db_name'])) == 0) {
        echo '<span class="notok">Failed!</span><p />Database Name is empty';
        $db = null;
    } else {
        $db = new database($cfg['db_type']);
        @($conn_result = $db->connect(NO_DSN, $cfg['db_server'], $cfg['db_admin_name'], $cfg['db_admin_pass'], $cfg['db_name']));
        if ($conn_result['status'] == 0) {
            echo '<span class="notok">Failed!</span><p />Please check the database login details and try again.';
            echo '<br>Database Error Message: ' . $db->error_msg() . "<br>";
            $db = null;
        } else {
            if (!isset($cfg['db_type']) || strtolower($cfg['db_type']) == 'mysql') {
                // 20071103 - BUGID 771 eagleas
                $db->exec_query("SET CHARACTER SET utf8;");
                $db->exec_query("SET collation_connection = 'utf8_general_ci';");
            }
            echo "<span class='ok'>OK!</span><p />";
        }
    }
    return $db;
}

 public function get_db()
 {
     $database = new database();
     $dbtype = $database->get_type();
     if ($dbtype == 'mysql') {
         $db_arr = $database->connect();
         if ($db_arr[0] == 1) {
             return array(1, $db_arr[1]);
         }
         $this->db = $db_arr[1];
         $get_query = "SELECT * FROM user WHERE user_name='" . $this->username . "'";
         $get_result = $this->db->query($get_query);
         $get_result_arr = $get_result->fetch_assoc();
         $get_result_count = $get_result->num_rows;
         if ($get_result_count != 1) {
             return array(2, 'Name not found');
         }
     } elseif ($dbtype == 'sqlite') {
         $db_arr = $database->connect_sqlite();
         $this->db = $db_arr;
         // to be implemented
     }
     $this->id = $get_result_arr['user_id'];
     $this->username = $get_result_arr['user_name'];
     $this->email = $get_result_arr['user_email'];
     $this->groupname = $this->group_id_to_name($get_result_arr['user_group']);
     $this->firstname = $get_result_arr['first_name'];
     $this->middlename = $get_result_arr['middle_name'];
     $this->lastname = $get_result_arr['last_name'];
 }

 function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
 {
     if (PHP_VERSION < 6) {
         $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
     }
     //$theValue = function_exists("mysqli_real_escape_string") ? mysqli_real_escape_string($conexion , $theValue) : mysqli_escape_string( $conexion , $theValue);
     if (function_exist) {
         $obj = new database();
         $link = $obj->connect();
         $theValue = mysqli_real_escape_string($link, $theValue);
     }
     switch ($theType) {
         case "text":
             $theValue = $theValue != "" ? "'" . $theValue . "'" : "NULL";
             break;
         case "long":
         case "int":
             $theValue = $theValue != "" ? intval($theValue) : "NULL";
             break;
         case "double":
             $theValue = $theValue != "" ? doubleval($theValue) : "NULL";
             break;
         case "date":
             $theValue = $theValue != "" ? "'" . $theValue . "'" : "NULL";
             break;
         case "defined":
             $theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
             break;
     }
     return $theValue;
 }

 public function database_connect()
 {
     $database = new database();
     $db_arr = $database->connect();
     if ($db_arr[0] == 1) {
         return array(1, $db_arr[1]);
     }
     $this->db = $db_arr[1];
 }

 public function __construct()
 {
     if (!$this->db) {
         require_once "resources/classes/database.php";
         $database = new database();
         $database->connect();
         $this->db = $database->db;
     }
     $this->domain_uuid = $_SESSION['domain_uuid'];
 }

 /**
  * Called when the object is created
  */
 public function __construct()
 {
     //connect to the database if not connected
     if (!$this->db) {
         require_once "resources/classes/database.php";
         $database = new database();
         $database->connect();
         $this->db = $database->db;
     }
 }

 public function __construct()
 {
     //connect to the database if not connected
     if (!$this->db) {
         require_once "resources/classes/database.php";
         $database = new database();
         $database->connect();
         $this->db = $database->db;
     }
     //set the default value
     $this->dialplan_global = false;
 }

function validateConnexion($user, $pass)
{
    $result = false;
    $db = new database();
    if ($db->connect()) {
        echo 'db connected <br>';
        if ($db->validateUser($user, $pass)) {
            $result = true;
        }
    }
    $db->disconnect();
    return $result;
}