Method count_db_rows

models/db.php:586–605

* Count DB rows * @param string table * @param array filters [ array ( * 'name' => $name, 'value' => $value, 'page' => $page) ] */

(
        $table, $filters = []
    )

     * 'name' => $name, 'value' => $value, 'page' => $page) ]
     */
    public static function count_db_rows(
        $table, $filters = []
    ){

        // SQL
        $sql = 'SELECT COUNT(*) AS TOTAL FROM `'.$table.'`';
        $params = array();

        // Add optional filters.
        $filters = self::filters($filters);
        $sql.= $filters['sql'];

        // Query
        $results = self::query($sql, $filters['params'], true);

        // Result
        $data = $results->fetch_object()->TOTAL;
        return $data;

    }
    
    /**
     * Get Meta Value