dsklzerpx64815631 2017-03-27 10:11 采纳率: 100%
浏览 37

等待PDO连接 - medoo php

When I change the IP of my MySQL connection and run this:

$this->pdo = new PDO($dsn, $this->username, $this->password, $this->option);

The try and catch does not work. Its does not catch that error, PDOException or general exception.

The problem is that I did not get any error or a response from PDO. It is pending for a long time.

How can I get the response immediately if there are no connections?

Full code:

        case 'mysql':

                if ($this->socket) {
                    $dsn = $type . ':unix_socket=' . $this->socket . ';dbname=' . $this->database_name;

                } else {
                    $dsn = $type . ':host=' . $this->server . ($is_port ? ';port=' . $port : '') . ';dbname=' . $this->database_name;

                }
                $commands[] = 'SET SQL_MODE=ANSI_QUOTES';


        if (in_array($type, explode(' ', 'mariadb mysql pgsql sybase mssql')) && $this->charset) {
            $commands[] = "SET NAMES '" . $this->charset . "'";
        }

 //**here is the problem  //
     $this->pdo = new PDO($dsn, $this->username, $this->password, $this->option);


        foreach ($commands as $value) {
            $this->pdo->exec($value);
        }
    }   catch (PDOException $e) {

            echo "Connection to database lost";

            }
            catch (Exception $e) {
               echo "Connection to database lost";
               return;

           }




even if I try from php manual 


$dsn = 'mysql:host=127.0.0.2;port=3306;dbname=dbname';
$username = 'user';
$password = 'pass';
$options = array(
    PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
);

$dbh = new PDO($dsn, $username, $password, $options);
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 R语言Rstudio突然无法启动
    • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
    • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
    • ¥15 用windows做服务的同志有吗
    • ¥60 求一个简单的网页(标签-安全|关键词-上传)
    • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值