PDOStatement.php

<?php
 
$stmt = $pdo->prepare("SELECT ItemSales.date,
ItemSales.price,
ItemSales.price * ItemSales.quantity as earnings
FROM ItemSales as sales,Items
WHERE ItemSales.itemId = Items.id
AND Items.id = :Items_id"); // Note: :Items.id change to :Items_id
 
$stmt->bindParam(':Items_id', $id); // Note: 'Items.id' change to ':Items_id'
 
$stmt->execute();
 
?>