How can I fetch data from database using this prepare statement

Viewed 95
//this is my connection function. It is connecting databse successfully when I check.
$conn = connection($config['servername'],$config['username'],$config['password']);

after this I Used following code to fetch data from Database

$id = 2;
if($conn) {

    try {

        $stmt = $conn->prepare('SELECT * FROM customer_tbl WHERE cus_id = :id');
        $stmt->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        $stmt->bindParam(':id', $id);

        $results = $stmt->execute();

    }catch (PDOException $e){

        echo 'Error: ' . $e->getMessage();
    }

}

this code showing following error message on the browser

Error: SQLSTATE[IM001]: Driver does not support this function: This driver doesn't support setting attributes

what's wrong with my code?. Why I could not fetch data's from database?

if I want to fetch this specified data from databese using prepare statement how to code?

1 Answers
Related