douhui5529 2017-11-02 06:32 采纳率: 100%
浏览 35
已采纳

在php中查找意图连接函数

This is db.php file for connection of the MYSQL .I'm using 1.single instance of self shared among all instances 2.db connection config vars 3.This method must be static, and must return an instance of the object if the object.does not already exist. 4.The clone and wakeup methods prevents external instantiation of copies of the Singleton class,thus eliminating the possibility of duplicate objects.

<?php
    include('config.php');
    class db extends mysqli {


        // single instance of self shared among all instances
        private static $instance = null;


        // db connection config vars
        private $user = DBUSER;
        private $pass = DBPWD;
        private $dbName = DBNAME;
        private $dbHost = DBHOST;

        //This method must be static, and must return an instance of the object if the object
        //does not already exist.
        public static function getInstance() {
        if (!self::$instance instanceof self) {
                self::$instance = new self;
        }
            return self::$instance;
        }

        // The clone and wakeup methods prevents external instantiation of copies of the Singleton class,
        // thus eliminating the possibility of duplicate objects.
        public function __clone() {
       trigger_error('Clone is not allowed.', E_USER_ERROR);
        }
        public function __wakeup() {
        trigger_error('Deserializing is not allowed.', E_USER_ERROR);
        }

        private function __construct() {
        parent::__construct($this->dbHost, $this->user, $this->pass, $this->dbName);
        if (mysqli_connect_error()) {
            exit('Connect Error (' . mysqli_connect_errno() . ') '
                    . mysqli_connect_error());
        }
        parent::set_charset('utf-8');

       }
       public function dbquery($query)
        {
            if($this->query($query))
            {
                return true;
            }

        }
        public function get_result($query) 
        {
            $result = $this->query($query);
            if ($result->num_rows > 0){
                while ($row = $result->fetch_assoc()) 
                {
                    $rows[] = $row;     
                }
            return $rows;
            } else
            return null;


        }
    }


    ?>

This is inserting cording with Escape user inputs for security

<?php

    $Institute_Name = mysqli_real_escape_string($conn, $_REQUEST['Institute_Name']);
    $Institute_Address = mysqli_real_escape_string($conn, $_REQUEST['Institute_Address']);

?>

i need how can i call $conn from instance

$conn = getInstance();

I try this.This is not working i need it for inserting code

$query= "INSERT INTO `institute` ( Institute_Name, Institute_Address, ) VALUES ('$Institute_Name', '$Institute_Address')";
  • 写回答

1条回答 默认 最新

  • dou1908 2017-11-02 06:40
    关注

    you should use

    $conn = db::getInstance();

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥20 Python安装cvxpy库出问题
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题