PHP PDO Fatal error: Call to a member function prepare()

Question

I am trying to display some information from database and I have the following two files. When I run the index.php , I get this error:Fatal error: Call to a member function prepare() on a non-object in C:\xampp\htdocs\pc\index.php on line 16

Could you please tell me how to solve this problem

index.php

include_once('database.php');

$db= new database();
$conn = $db->connect();
                         //Problem is in the folloing line
$query = $conn->prepare('SELECT * FROM admin WHERE admin_id = :id'); 
$query->execute(array('id' => 1));
?>
<table>
<tr>
<th>Name</th>
<th>Email</th>
</tr>

<?php
while( $rows = $query->fetch(PDO::FETCH_ASSOC)) {
    echo "<tr>";
    echo "<td>". $rows['admin_name'] ."</td>" ;
    echo "<td>". $rows['admin_email'] ."</td>" ;

    echo "</tr>";
}
?>

</table>

database.php

class Database{

private $host = 'localhost';
private $dbname = 'school';
private $username = 'root';
private $password ='';  

public $con = '';

function __construct(){

    $this->connect();   

}

function connect(){

    try{

        $this->con = new PDO("mysql:host=$this->host;dbname=$this->dbname",$this->username, $this->password);
        $this->con->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);


    }catch(PDOException $e){

        echo 'We\'re sorry but there was an error while trying to connect to the database';
        file_put_contents('connection.errors.txt', $e->getMessage().PHP_EOL,FILE_APPEND);

    }
}   
}

Cito · Accepted Answer · 2013-03-16 05:44:37Z

2

class Database{

private $host = 'localhost';
private $dbname = 'school';
private $username = 'root';
private $password ='';  

public $con = '';

function __construct(){

    $this->connect();   

}

function connect(){

    try{

        $this->con = new PDO("mysql:host=$this->host;dbname=$this->dbname",$this->username, $this->password);
        $this->con->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);


    }catch(PDOException $e){

        echo 'We\'re sorry but there was an error while trying to connect to the database';
        file_put_contents('connection.errors.txt', $e->getMessage().PHP_EOL,FILE_APPEND);

    }
    return $this->con; // This makes all the magic!!!
}   
}

answered Mar 16, 2013 at 5:44

Cito

1,7093 gold badges22 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

black_belt Over a year ago

Thanks a lot for your answer. It was indeed a magic :) If you don't mind .. could you please tell me how to stop loading the codes after $conn = $db->connect(); in index.php if there was a problem connecting the db? Thanks :)

Jon Over a year ago

@black_belt within the catch block you can die('failed'); or however you want to do that, otherwise, check $conn for is_a of PDO as if(!is_a($conn, 'PDO')) { /*kill here*/ } after $conn = $db->connect();

Collectives™ on Stack Overflow

PHP PDO Fatal error: Call to a member function prepare()

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related