CODEWITHSUNDEEP
phpmysqlmysqli
Iron Brew
Iron Brew

Reputation: 21

I am trying to retrieve data from my database using PDO Fetch object

I am trying to retrieve data from my database using PDO Fetch object and it says

Fatal error: Uncaught Error: Call to undefined method mysqli_result::execute()

what I'm doing wrong This is what I have tried

<?php 
$servername = "localhost"; $username = "root"; $password = ""; $dbname = "messages_db";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
$getquery = $conn->query('select col_name from db where id = 2');
$getquery->execute();
$result = $getquery->fetch(PDO::FETCH_OBJ);
?>

<div><?= $result->col_name; ?></div>

Upvotes: 0

Views: 81

Answers (1)

Isaac
Isaac

Reputation: 804

Firstly, don't mix PDO and mysqli. Stick to one. Here's a PDO example. You first need to create a new PDO object. and connect to DB at the start

$servername = "localhost";
$dbusername = "root";
$dbpassword = "root";
$dbname = "dbname";

try{
$pdo = new PDO("mysql:host=$servername;dbname=$dbname",$dbusername, 
$dbpassword);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e)
{
print "Error! Unable to connect: " . $e->getMessage() . "<br/>";
die();
}

$rtrv = "select col_name from db where id = 2"
$stmt = $pdo->prepare($rtrv);
//Execute.
$stmt->execute();

//Fetch.
$user = $stmt->fetch(PDO::FETCH_ASSOC);

// Do whatever you want after this

Upvotes: 2

Related Questions