Level 16
Place the setFetchMode above your query (select * from data).
You need to do the configuration before executing the query.
Jul 12, 2020
4
Level 2
Fatal error: Uncaught Error: Call to a member function setFetchMode() on bool
Data is not fetching from db and shows error which is "Fatal error: Uncaught Error: Call to a member function setFetchMode() on bool in ...\practice.php:9 Stack trace: #0 {main} thrown in ...\practice.php on line 9"
code:
<?php
try{
$conn = new PDO("mysql: host = localhost; dbname = php_crud", 'root', '');
$pdo = $conn->query("SELECT * FROM data");
$pdo->setFetchMode(PDO:: FETCH_ASSOC);
while($row = $pdo->fetch()) {
echo $row['email'] . "<br>";
}
}
catch(PDOException $e) {
echo "Error: " . $e->getMessage();
}
?>
Level 2
Notice: Undefined variable: pdo in ...\practice.php on line 7
Fatal error: Uncaught Error: Call to a member function setFetchMode() on null in
code:
try{
$conn = new PDO("mysql: host = localhost; dbname = php_crud", 'root', '');
$pdo->setFetchMode(PDO:: FETCH_ASSOC);
$pdo = $conn->query("SELECT * FROM data");
while($row = $pdo->fetch()) {
echo $row['email'] . "<br>";
}
}
Level 16
Yeah okay my bad, your variables names are confusing.
Are you sure your connection string is correct? query returns false probably.
Level 2
yes
and in question all code has posted
Please or to participate in this conversation.