Query OO

main.php

<?php

require __DIR__.'/Query.php';

$mysql = new PDO('mysql:host=localhost;dbname=world', 'root', '');

$threeCountry = new Query($mysql, 'SELECT * FROM country LIMIT 3');
$countryByCode = new Query($mysql, 'SELECT * FROM country WHERE code = :code');

// -- 

$result = $threeCountry->execute();
while ($country = $result->fetch()) {
  print_r($country);
}

$result = $countryByCode->execute([
  ':code' => 'IDN'
]);
$country = $result->fetch();
print_r($country);

// -- panggil lagi

$result = $threeCountry->execute();
while ($country = $result->fetch()) {
  print_r($country);
}

$result = $countryByCode->execute([
  ':code' => 'IDN'
]);
$country = $result->fetch();
print_r($country);

Query.php

<?php

class Query
{
  private $pdo;
  private $sql;
  
  public function __construct(PDO $pdo, $sql)
  {
    $this->pdo = $pdo;
    $this->sql = $sql;
  }
  
  public function execute(array $data = [])
  {
    $result = $this->pdo->prepare($this->sql);
    $result->execute($data);
    
    return $result;
  }
}