如何从数据库获取数据并在php页面上回显？

Question

How to get the date from database and echo on PHP page?

$query = $pdo->prepare('SELECT * FROM shop WHERE shopname=:shopname');
$query->bindParam(':shopname', $shopname, PDO::PARAM_STR);
$query->execute();

$result = $query->fetchAll(PDO::FETCH_ASSOC);
echo "$result['shopid']";

This gives me the following error:

Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)

Answer 1

remove the double quotes, change

echo "$result['shopid']";

with

echo $result['shopid'];