connect to db oop, return value

Vote count:

0

did I coding something wrong it is connect to database success but not output anything, is it correct return $dbh?

connect_db.php

class dbconnect {
 public function system_db() {
      $host = 'localhost';
      $dbname = 'system_db';
      $user = 'db_root';
      $password = '654321';

      try {
           $dbh = new PDO('mysql:host='.$host.';dbname='.$dbname.'', $user, $password);
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

           print 'conneted to database';
        } catch (PDOException $e) {

           print $e->getMessage();
           die();
        }

      return $dbh;
}
}

action.php

 require 'config/connect_db.php';
 $dbconnect = new dbconnect();
 $dbconnect->system_db();

 $sql = "SELECT * FROM service_api";
 $sth = $dbconnect->prepare($sql);
 $sth->execute();
 $rows = $sth->fetchAll();

asked 1 min ago

user1775888

423