问mysqli oop返回空

EN

class sub_category
{
    private $con;
    function __construct()
    {
        $this->con = new mysqli("localhost", "root", "", "whatever");
    }

    function show_all()
    {
        $per_page=5;
        if(isset($_GET['page']))
        {
            $page = $_GET['page'];
        }
        else
        {
            $page = 1;
        }

        $start_from = ($page-1)*$per_page;

        $sql = "SELECT sub_kategori.id_sub_kategori, kategori.nama_kategori, sub_kategori.nama_sub_kategori FROM sub_kategori INNER JOIN kategori ON kategori.id_kategori = sub_kategori.id_kategori ORDER BY sub_kategori.id_sub_kategori LIMIT ?, ?";
        $stmt = $this->con->prepare($sql);
        $stmt->bind_param('ii', $start_from, $per_page);
        $stmt->execute();
        $stmt->bind_result($id, $namecat, $cat);
        while($stmt->fetch())
        {
            echo "<tr>";
            echo "<td>$id</td>";
            echo "<td>$namecat</td>";
            echo "<td>$cat</td>";
            echo "<td><a href='javascript:'>Update</a></td>";
            echo "<td><a href='sub_category.php?ghgfh=$id'>Delete</a></td>";
            echo "<td><a href=''>Report</a></td>";
            echo "</tr>";
        };
        $stmt->close();
        $page_sql = "SELECT sub_kategori.id_sub_kategori, kategori.nama_kategori, sub_kategori.nama_sub_kategori FROM sub_kategori INNER JOIN kategori ON kategori.id_kategori = sub_kategori.id_kategori ORDER BY sub_kategori.id_sub_kategori";
        $stmt_page = $this->con->query($page_sql);
        $total_record = $stmt_page->num_rows;
        $total_page = ceil($total_record/$per_page);
        echo "</tbody>";
        echo "</table>";
        echo "<center>";
        echo "<ul class='pagination'>";
        echo "<li><a href=sub_category.php?page=1>First Page</a></li>";
        for($i=1;$i<=$total_page;$i++)
        {
            if(isset($_GET['page']))
            {
                if($i==$_GET['page'])
                {   
                    echo "<li class='active'><a href=sub_category.php?page=$i>$i</a></li>";
                }
                else
                {
                    echo "<li><a href=sub_category.php?page=$i>$i</a></li>";
                }
            }
            else
            {
                echo "<li><a href=sub_category.php?page=$i>$i</a></li>";
            }
        }
        echo "<li><a href=sub_category.php?page=$total_page>Last Page</a></li>";
        echo "</ul>";
        echo "</center>";
        $stmt_page->close();
    }

    function show($nama_sub_kategori)
    {

        $per_page=5;
        if(isset($_GET['page']))
        {
            $page = $_GET['page'];
        }
        else
        {
            $page = 1;
        }

        $start_from = ($page-1)*$per_page;

        $nama_sub_kategori = "%$nama_sub_kategori%";
        $sql = "SELECT sub_kategori.id_sub_kategori, kategori.nama_kategori, sub_kategori.nama_sub_kategori FROM sub_kategori INNER JOIN kategori ON kategori.id_kategori = sub_kategori.id_kategori WHERE sub_kategori.id_sub_kategori LIKE ? OR sub_kategori.nama_sub_kategori LIKE ? OR kategori.nama_kategori LIKE ? ORDER BY sub_kategori.id_sub_kategori LIMIT ?, ?";
        $stmt = $this->con->prepare($sql);
        $stmt->bind_param('sssii', $nama_sub_kategori, $nama_sub_kategori, $nama_sub_kategori, $start_from, $per_page);
        $stmt->execute();
        $stmt->bind_result($id, $namecat, $cat);
        while($stmt->fetch())
        {
            echo "<tr>";
            echo "<td>$id</td>";
            echo "<td>$namecat</td>";
            echo "<td>$cat</td>";
            echo "<td><a href=''>Update</a></td>";
            echo "<td><a href='sub_category.php?ghgfh=$id'>Delete</a></td>";
            echo "<td><a href=''>Report</a></td>";
            echo "</tr>";
        };
        $stmt->close();
        $page_sql = "SELECT count(*) as total FROM sub_kategori INNER JOIN kategori ON kategori.id_kategori = sub_kategori.id_kategori WHERE sub_kategori.id_sub_kategori LIKE ? OR sub_kategori.nama_sub_kategori LIKE ? OR kategori.nama_kategori LIKE ? ORDER BY sub_kategori.id_sub_kategori";
        $stmt_page = $this->con->prepare($page_sql);
        $stmt_page->bind_param('sss', $nama_sub_kategori, $nama_sub_kategori, $nama_sub_kategori);
        $stmt_page->execute();
        $stmt_page->bind_result($row);
        $total_record = $row;
        echo $total_record;
        $total_page = ceil($total_record/$per_page);
        echo "</tbody>";
        echo "</table>";
        echo "<center>";
        echo "<ul class='pagination'>";
        echo "<li><a href=sub_category.php?page=1>First Page</a></li>";
        for($i=1;$i<=$total_page;$i++)
        {
            if(isset($_GET['page']))
            {
                if($i==$_GET['page'])
                {   
                    echo "<li class='active'><a href=sub_category.php?page=$i>$i</a></li>";
                }
                else
                {
                    echo "<li><a href=sub_category.php?page=$i>$i</a></li>";
                }
            }
            else
            {
                echo "<li><a href=sub_category.php?page=$i>$i</a></li>";
            }
        }
        echo "<li><a href=sub_category.php?page=$total_page>Last Page</a></li>";
        echo "</ul>";
        echo "</center>";
        $stmt_page->close();
    }
 }