Back To Top Button - warwickfoster/qurantools GitHub Wiki

File: app/admin/page_usage_statistics.php

Purpose

The provided code snippet is a PHP script that generates a page usage statistics report. It includes the following features:

Data Retrieval

• Retrieves page usage data from a database.
• Filters data based on user type (all users, administrators, or excluding administrators).
• Sorts data based on page, category, or load count.

Output

• Displays a table showing page usage statistics, including page name, category, and load count.
• Displays a chart showing page usage statistics by category.

Key Features

• Filtering Users can filter the data to include all users, administrators, or only administrators.
• Sorting Data can be sorted by page, category, or load count.
• Display Modes The report can be displayed as a table or a chart.

Code Breakdown

• Database Connection Establishes a connection to the database where the page usage data is stored.
• Data Retrieval Queries the database based on the selected filter and sorting criteria.
• Table Output Generates an HTML table with page usage statistics.
• Chart Output Creates a JavaScript chart using the FusionCharts library to display the page usage statistics by category.
• User Interface Provides buttons for filtering, sorting, and switching between table and chart view.

Usage

To use this script, follow these steps:

1. Configure the database connection settings.
2. Run the script.
3. The report will be displayed in a web browser.

Additional Features

• The report could be extended to include additional statistics, such as user demographics or session duration.
• The chart could be customized with different colors, fonts, and other styling options.

Conclusion

The PHP script provides a comprehensive page usage statistics report with filtering, sorting, and display mode options. This information can be valuable for website administrators to understand how users interact with their website and identify areas for improvement.