function.php 973 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. <?php
  2. require_once "../path.php";
  3. function channel_get_title($id)
  4. {
  5. if (isset($id)) {
  6. PDO_Connect( _FILE_DB_CHANNAL_);
  7. $query = "SELECT name FROM channal WHERE id = ? ";
  8. $channel = PDO_FetchRow($query, array($id));
  9. if ($channel) {
  10. return $channel["name"];
  11. } else {
  12. return "";
  13. }
  14. } else {
  15. return "";
  16. }
  17. }
  18. class Channal
  19. {
  20. public $dbh;
  21. public function __construct() {
  22. $dns = ""._FILE_DB_CHANNAL_;
  23. $this->dbh = new PDO($dns, "", "",array(PDO::ATTR_PERSISTENT=>true));
  24. $this->dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  25. }
  26. public function getChannal($id){
  27. $query = "SELECT * FROM channal WHERE id= ? ";
  28. $stmt = $this->dbh->prepare($query);
  29. $stmt->execute(array($id));
  30. $channal = $stmt->fetchAll(PDO::FETCH_ASSOC);
  31. if(count($channal)>0){
  32. return $channal[0];
  33. }
  34. else{
  35. return false;
  36. }
  37. }
  38. }
  39. ?>