douchen9569 2016-12-29 19:40
浏览 37
已采纳

PHP认为我的非空DSN == null

I try to play with exceptions in PHP for my first time, but it does not go very well.

I have a variable named dsn, this contains the connection string of PDO / MySQL.

When I use var_dump on dsn it returns 'null', so i can assume that my dsn is empty.

But when I look in my code, the value of DSN is checked and when it equals to NULL it should throw an exception.

But, PHP does not throw an exception.

I already have checked for a typo, but dns does not exist in my code ;)

And due to this, I also can't connect to my database because I give PDO an empty DSN-string.

My code:

<?php
try {
    $host = 'localhost';
    $user   = 'root';
    $pass = '';
    $db = 'pridec';
    $charset = 'utf8';

    if ($host == NULL) {
        throw new Exception("Hostname is empty or is equal to null");
    }
    if ($user == NULL) {
        throw new Exception("Username is empty or is equal to null");
    }
    if ($db == NULL) {
        throw new Exception("Database is empty or is equal to null");
    }
    if ($charset == NULL) {
        throw new Exception("Charset is empty or is equal to null");
    }
    //Neither of these variables are working 
    //$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
    //$dsn = "mysql:dbname=$db;host=$host;charset=$charset";
    $dsn = "mysql:dbname=$db";
    $opt = [
        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::ATTR_EMULATE_PREPARES   => false,
    ];


    if ($dsn = NULL) {
        throw new Exception("DSN can *never* be empty or equal to null / zero");
    }

    try {
        $pdo = new PDO($dsn, $user, $pass, $opt);
    } catch (PDOException $pdoe) {
        echo "<pre>";
        var_dump($dsn);
        var_dump($pdoe);
        echo "</pre>";
        throw new Exception("Cannot connect to the database because: ".$pdoe->getMessage());
    }

    require "classes/account.class.php";
    $account = new account($pdo);
} catch (Exception $e) {
    echo "An error occured:<br>";
        echo $e->getMessage();
} finally {
    ini_set("session.hash_function","sha512");
    session_start();
}
?>

I hope you guys can find the error to help me.

  • 写回答

1条回答 默认 最新

  • doulue1949 2016-12-29 20:24
    关注
    if ($dsn = NULL) {
        throw new Exception("DSN can *never* be empty or equal to null / zero");
    }
    

    should be

    if ($dsn == NULL) {
        throw new Exception("DSN can *never* be empty or equal to null / zero");
    }
    

    what you have is "=" instead of "=="

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

报告相同问题?

悬赏问题

  • ¥50 高维数据处理方法求指导
  • ¥100 数字取证课程 关于FAT文件系统的操作
  • ¥15 如何使用js实现打印时每页设置统一的标题
  • ¥15 安装TIA PortalV15.1报错
  • ¥15 能把水桶搬到饮水机的机械设计
  • ¥15 Android Studio中如何把H5逻辑放在Assets 文件夹中以实现将h5代码打包为apk
  • ¥15 使用小程序wx.createWebAudioContext()开发节拍器
  • ¥15 关于#爬虫#的问题:请问HMDB代谢物爬虫的那个工具可以提供一下吗
  • ¥15 vue3+electron打包获取本地视频属性,文件夹里面有ffprobe.exe 文件还会报错这是什么原因呢?
  • ¥20 用51单片机控制急停。