xxxxxxxxxx
$sql = 'SELECT publisher_id, name
FROM publishers
WHERE publisher_id = :publisher_id';
$statement = $pdo->prepare($sql);
$statement->bindParam(':publisher_id', $publisher_id, PDO::PARAM_INT);
$statement->execute();
$publisher = $statement->fetch(PDO::FETCH_ASSOC);
xxxxxxxxxx
$stmt = $pdo->prepare("SELECT * FROM table WHERE id = ?");
$stmt->execute([$id]);
$result = $stmt->fetchAll();
xxxxxxxxxx
$sql = "SELECT * FROM payment WHERE tno=? && status=?";
$stmt =$pdo->prepare($sql);
$stmt->execute([$_POST["tranjection"],"active"]);
// retutn all data
$data = $stmt->fetchAll();
// retu ntotal row
$row = $stmt->rowCount();