Advertisement
Guest User

Untitled

a guest
Nov 17th, 2019
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.61 KB | None | 0 0
  1. // model
  2. public function get(string $field, string $value)
  3. {
  4.     $database = Database::getInstant();
  5.     $sql = "SELECT * FROM :table WHERE :field = :value;";
  6.     $result = $database->query($sql, [
  7.         ':table' => $this->table,
  8.         ':field' => $field,
  9.         ':value' => $value,
  10.     ], static::class);
  11.     return $result;
  12. }
  13.  
  14. // database
  15. public function query(string $sql, array $params = [], string $className = 'stdClass')
  16. {
  17.     $sth = $this->pdo->prepare($sql);
  18.     $result = $sth->execute($params);
  19.     if ($result === false) return null;
  20.     return $sth->fetchAll(PDO::FETCH_CLASS, $className);
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement