此脚本中的PDO出错| 页面变成空白

Question

I'm having a strange problem using PDO in this script. Probably the problem is very simple but i can't find it and it is making me crazy. The problem is when i launch the script the page turn blank.

<?php

    //PDO
if(isset($_POST['submit'])) {   
    // test row

    $password = $_POST['upassword'];
    $email = $_POST['email'];
    $_SESSION['email'] = $email;

    $servername = "localhost";
    $username = "root";
    $password = "passwordxyz";
    $dbname = "abcd";

    try {
        $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        $statement = $conn->prepare('SELECT `password` FROM `users` WHERE `email` = :email');  
        $statement->bindParam(':email', $email);  
        $statement->execute();  
        while($row = $statement->fetch() ){  
            echo 'ok';  
        }       
    }
} 


?>

Please help me to solve the problem. Thank you.

Answer 1

You have try clause but no catch which is what is generating the error.

<?php

//PDO
if(isset($_POST['submit'])) {   

$password = $_POST['upassword'];
$email = $_POST['email'];
$_SESSION['email'] = $email;
$servername = "localhost";
$username = "root";
$password = "passwordxyz";
$dbname = "abcd";

try{
      $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
      // set the PDO error mode to exception
      $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
      $statement = $conn->prepare('SELECT `password` FROM `users` WHERE `email` = :email');  
      $statement->bindParam(':email', $email);  
      $statement->execute();  
      while($row = $statement->fetch() ){  
          echo 'ok';  
      }
   }
catch(Exception $e){
        //change from general to specific exception and handle here
    }
}