How to get data from database and echo on php page?

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)

score 4 · Answer 1 · answered Oct 21 '13 at 08:29

4

echo "$result['shopid']";

This line is incorrect

echo $result["shopid"];
// OR
echo "{$result['shopid']}";

answered Oct 21 '13 at 08:29

Jonathon

15,873
11
73
92

score 1 · Answer 2 · answered Oct 21 '13 at 08:28

1

remove the double quotes, change

echo "$result['shopid']";

with

echo $result['shopid'];

answered Oct 21 '13 at 08:28

user2092317

3,226
5
24
35

2

Or if you really want double quotes: `echo "{$result['shopid']}";` – baldrs Oct 21 '13 at 08:29

How to get data from database and echo on php page?

2 Answers2

Linked