PHPackages webuccinoco/sre-community - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Framework](/categories/framework) 4. / 5. webuccinoco/sre-community ActiveProject[Framework](/categories/framework) webuccinoco/sre-community ========================= An open source PHP reporting framework, empowering the dynamic creation of professional reports (for MYSQL or Maria DB) directly from your projects. v1.1.4(2y ago)9516↑71.4%GPL-1.0-or-laterPHPPHP >=7.0 Since Aug 6Pushed 4mo ago1 watchersCompare [ Source](https://github.com/webuccinoco/PHP-Reporting-Library-For-MYSQL)[ Packagist](https://packagist.org/packages/webuccinoco/sre-community)[ Docs](https://mysqlreports.com/engine/documentation/index.php?post=community_install)[ RSS](/packages/webuccinoco-sre-community/feed)WikiDiscussions main Synced 3d ago READMEChangelog (4)DependenciesVersions (11)Used By (0) Smart Report Engine – PHP MySQL Report Generator & Reports Builder (Community Edition) ========================================================================================== [](#smart-report-engine--php-mysql-report-generator--reports-builder-community-edition) [![License](https://camo.githubusercontent.com/90b951677596e865d2336edfcb994d4b6c872d43bda4578472008408ea410cb8/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d636f6d6d756e6974792d626c7565)](https://camo.githubusercontent.com/90b951677596e865d2336edfcb994d4b6c872d43bda4578472008408ea410cb8/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d636f6d6d756e6974792d626c7565)[![PHP](https://camo.githubusercontent.com/1150142271e92a6b30ce3ef37f5548f25d15d1e9cd200eea972f746cc7a2c40a/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7068702d372e342532422d626c7565)](https://camo.githubusercontent.com/1150142271e92a6b30ce3ef37f5548f25d15d1e9cd200eea972f746cc7a2c40a/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7068702d372e342532422d626c7565)[![MySQL](https://camo.githubusercontent.com/14acf6c5bfb42504d43b25ff7c5b64a1c7fb062ab4b110f73f53de3abb5187d7/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f44617461626173652d4d7953514c2532302537432532304d6172696144422d6f72616e6765)](https://camo.githubusercontent.com/14acf6c5bfb42504d43b25ff7c5b64a1c7fb062ab4b110f73f53de3abb5187d7/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f44617461626173652d4d7953514c2532302537432532304d6172696144422d6f72616e6765)[![Status](https://camo.githubusercontent.com/d2656a901783e71666d7809f3464464fa4464d567a223f27ce4a2b747864f169/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7374617475732d6163746976652d627269676874677265656e)](https://camo.githubusercontent.com/d2656a901783e71666d7809f3464464fa4464d567a223f27ce4a2b747864f169/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7374617475732d6163746976652d627269676874677265656e) Smart Report Engine is a **PHP reporting library for MySQL and MariaDB** that allows developers to generate professional, dynamic reports programmatically inside their own PHP applications. Build SQL reports, grouped summaries, calculated fields, and formatted outputs using a clean PHP API instead of manually writing report logic. [![Watch the video](https://camo.githubusercontent.com/f4807a96683b1dcbde46585e46cc7b75aa854a01a55655f99fd6b0d9cded26b9/68747470733a2f2f6d7973716c7265706f7274732e636f6d2f766964656f2e706e67)](https://www.youtube.com/embed/ZLa24Eo5gmE) --- 🔹 Official Project ------------------ [](#-official-project) Official Website: Product Page: Community Edition Repository: ⚠️ This is the original and official repository of Smart Report Engine Community Edition. --- 📑 Table of Contents ------------------- [](#-table-of-contents) - [Why Smart Report Engine is a powerful PHP reporting library for MySQL](#why-smart-report-engine-is-a-powerful-php-reporting-library-for-mysql) - [Features](#-features) - [Community Edition vs Pro Edition vs Smart Report Maker](#comunity-edition-vs-pro-edition-vs-smart-report-maker) - [Screenshots & Videos](#-screenshots--videos) - [Use Cases](#-use-cases) - [Getting started](#getting-started-with-smart-report-engine---php-reports-builder-for-mysql---community-edition) - [Code Example & Walkthrough](#code-example--walkthrough) - [Documentation](#--documentation) - [Frequently Asked Questions (FAQ)](#frequently-asked-questions-faq) - [Customer Support](#customer-support) - [Important links](#important-links) - [Support the Project](#-support-the-project) - [License](#-license) - [Trademark](#-trademark) - [Contributing](#-contributing) - [Topics](#-topics) - [Author](#-author) --- Why Smart Report Engine is a powerful PHP Reporting Library for MySQL --------------------------------------------------------------------- [](#why-smart-report-engine-is-a-powerful-php-reporting-library-for-mysql) ### Streamlined Development & Integration [](#streamlined-development--integration) - Intuitive API: Effortlessly generate professional PHP reports for MySQL or MariaDB in minutes using a developer-friendly interface. - Flexible Architecture: As a robust PHP library, it offers extensive methods that are easy to manage, customize, and extend directly within your codebase. - Native PHP & Laravel Ready: Every license includes both the native PHP engine and a dedicated Laravel package for seamless integration. - Rapid Deployment: Drastically cut down on development, debugging, and maintenance hours by automating the creation of fully functional reports. ### Advanced Reporting Capabilities [](#advanced-reporting-capabilities) - Versatile Data Sources: Build unlimited reports using single or multiple tables, views, or complex SQL queries. - Multi-Level Grouping: Create high-density insights by grouping data across multiple layers, such as region, country, and city. - Dynamic Calculations: Add calculated "virtual" columns and include automated subtotals or grand totals (Sum, Avg, Min, Max, Count) for any data group. - Smart Formatting: Use conditional formatting to highlight critical data (e.g., flagging low stock in red) or apply custom cell styling like country flags and star ratings. ### Powerful Interactivity & Security [](#powerful-interactivity--security) - Dynamic Filtering: Create parameterized reports—such as date-range filters—that allow end-users to define their own views easily. - User-Specific Data: Automatically restrict data visibility so users only see their own records based on their login credentials. - Seamless Security: Built-in security functions allow for easy integration with your project’s existing authentication system. - Mobile-Optimized: Simply toggle the "mobile" layout property to deliver responsive, sturdy reports across all devices. ### Customization & Support [](#customization--support) - Tailored Branding: Fully customize your report’s style, layout, headers, and footers, with full support for multilingual labeling. - Expert Assistance: Access personalized, professional support through our dedicated ticketing system to ensure your project’s success. --- 🚀 Features ---------- [](#-features) - PHP MySQL reporting engine - Multi-level grouping - Subtotals and grand totals - Calculated fields - Filters & parameters - Conditional formatting - Responsive layout - Secure user-based filtering --- Comunity Edition vs Pro Edition vs Smart Report Maker ----------------------------------------------------- [](#comunity-edition-vs-pro-edition-vs-smart-report-maker) While the Community Edition provides a solid foundation for generating PHP reports for MySQL, you may require more advanced capabilities as your project grows. We offer two premium paths to suit your workflow: #### 1. [Smart Report Engine - Professional Edition](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/) [](#1-smart-report-engine---professional-edition) Tailored for developers who need maximum control. This version unlocks the full suite of advanced programmatic features, allowing you to code complex, high-performance reports with deeper customization and extended library methods. To help you better understand the distinctions between the community and professional editions of Smart Report Engine, see the detailed license comparison here: #### 2. [Smart Report Maker](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/) [](#2-smart-report-maker) Perfect for those who prefer a visual workflow. This comprehensive tool allows you to build reports, charts, pivot tables, and interactive dashboards through a visual interface. Once created, you can securely integrate them into your own applications using the powerful Embed Manager. [![Smart Report Maker](https://camo.githubusercontent.com/91c378d7c08a47a596e6a47e56b2c5489d1f7f919c4dbeeaa1fbcc1d6dac816b/68747470733a2f2f6d7973716c7265706f7274732e636f6d2f77702d636f6e74656e742f75706c6f6164732f323031352f30312f616c6c2e676966)](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/) ##### Screenshot of Different Modules of Smart Report Maker [](#screenshot-of-different-modules-of-smart-report-maker) #### 👉 See Smart Report Maker in Action [](#-see-smart-report-maker-in-action) Watch how the [Embed Manager](https://mysqlreports.com/srm-modules-embed-manager/) works or explore the full [Video gallery](https://mysqlreports.com/webuccino-screencasts/) to see everything you can build. --- 🖼 Screenshots & Videos -------------------------- [](#-screenshots--videos) Getting Started Video [https://www.youtube.com/embed/c2j5uR\_mxzs](https://www.youtube.com/embed/c2j5uR_mxzs) Smart Report Maker Demo --- 🎯 Use Cases ----------- [](#-use-cases) - Sales reports - Financial summaries - Inventory reports - Admin dashboards - Embedded analytics --- Getting started with Smart Report Engine - PHP Reports Builder for MYSQL - Community Edition -------------------------------------------------------------------------------------------- [](#getting-started-with-smart-report-engine---php-reports-builder-for-mysql---community-edition) 1. Clone the Community Edition repository or download it from: [https://mysqlreports.com/engine/documentation/index.php?post=community\_install](https://mysqlreports.com/engine/documentation/index.php?post=community_install) 2. Extract the package. The structure will look similar to: ``` ├── SmartReportingEngine/ ├── sre_config/ │ └── config.php ├── sre_reports/ ├── db/ │ └── example.sql ├── examples/ └── sre_bootstrap.php ``` [![Watch the video](https://camo.githubusercontent.com/2608d47061be7bc520064d60c228cc0825e42e8817fa5dc7774136b6070ff111/68747470733a2f2f6d7973716c7265706f7274732e636f6d2f636f6d6d756e6974792e706e67)](https://www.youtube.com/embed/c2j5uR_mxzs) Getting started with the community edition of Smart Report Engine - Video Tutorial 3. Import the sample MySQL database: - Locate `/db/example.sql` (creates and populates a table named `items`). - Choose an existing database or create a new one. - Import `example.sql`. 4. Configure the database connection string: - Open `sre_config/config.php`. - Update host, database, username, and password to match your database. 5. Save `config.php`. 6. Run the examples: - Open the example URLs from the `/examples` directory in your browser. - Reports generated by Smart Report Engine are saved to `/sre_reports`. --- Code Example & Walkthrough ------------------------------ [](#code-example--walkthrough) To begin writing your first project, you’ll need a new PHP script. For this tutorial, you can place it in the root directory of the Community Edition, alongside `sre_bootstrap.php`. If you manually downloaded the Community Edition (without Composer), you must require `sre_bootstrap.php` as shown below. If your code is in a different location, adjust the path accordingly. ``` use SRE\Engine\CustomEngine; use SRE\Engine\ReportOptions; require_once "sre_bootstrap.php"; try { $report = new ReportOptions(); $report->select_tables("items") ->set_grouping("country") ->set_title("Items Per country") ->select_all_fields(); $engine = new CustomEngine($report); $report_path = $engine->create_report(); if ($report_path) { header("location: ".$report_path); exit(); } } catch (Exception $e) { echo $e->getMessage(); } ``` Generate this report: [https://mysqlreports.com/engine/sre-community/sre\_reports/rep1691646585168400/rep1691646585168400.php](https://mysqlreports.com/engine/sre-community/sre_reports/rep1691646585168400/rep1691646585168400.php) ### Code Walkthrough [](#code-walkthrough) - **Namespaces:** Uses `SRE\Engine\CustomEngine` and `SRE\Engine\ReportOptions`. - **Bootstrap:** Requires `sre_bootstrap.php` for autoloading (manual install). - **ReportOptions:** Defines report options (some features are exclusive to commercial editions): - **CustomEngine:** Generates the report from the `ReportOptions`. - **create\_report():** Produces the report and returns a URL. Generated reports are saved in `/sre_reports`. --- Documentation ------------- [](#documentation) --- Frequently Asked Questions (FAQ) ================================ [](#frequently-asked-questions-faq) General ------- [](#general) ### What is Smart Report Engine? [](#what-is-smart-report-engine) [Smart Report Engine](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/) is a PHP reporting library that allows developers to generate professional, dynamic reports from MySQL and MariaDB databases programmatically within their own applications. ### What is Smart Report Maker? [](#what-is-smart-report-maker) [Smart Report Maker](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/) is a complete visual report builder that allows users to design reports, charts, dashboards, drill-down charts, and KPIs through an easy-to-use web interface without writing code. Then you can embed these reports and dashboards to your app via [Embed Manager](https://mysqlreports.com/srm-modules-embed-manager/). [![Smart Report Maker](https://camo.githubusercontent.com/69573591caf16634320d83143727d6381acab601b93da7fd557bde7117bf4126/68747470733a2f2f6d7973716c7265706f7274732e636f6d2f77702d636f6e74656e742f75706c6f6164732f323031352f30312f64617368626f61726473312e676966)](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/) ##### Dashboards and charts generated by Smart Report Maker [](#dashboards-and-charts-generated-by-smart-report-maker) ### Do I need coding skills to use these products? [](#do-i-need-coding-skills-to-use-these-products) - **Smart Report Maker:** No coding required. - **Smart Report Engine Pro & Smart Report Engine Community:** Basic PHP knowledge is required. Product Differences ------------------- [](#product-differences) ### What is the difference between Smart Report Maker and Smart Report Engine editions? [](#what-is-the-difference-between-smart-report-maker-and-smart-report-engine-editions) The difference between [Smart Report Maker](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/) and [Smart Report Engine](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/) is that Smart Report Maker is a complete product for creating professional reports, charts, dashboards, drill-down charts, and KPIs using an easy-to-use visual interface. Once created, you can easily embed these analytic resources into your own products using the built-in [Embed Manager](https://mysqlreports.com/srm-modules-embed-manager/). [![Smart Report Maker](https://camo.githubusercontent.com/2cbf2efa3d7de8f939303c404a07e20d05e2be1876c3c17dff54f720c267e7cb/68747470733a2f2f6d7973716c7265706f7274732e636f6d2f77702d636f6e74656e742f75706c6f6164732f323031352f30312f30312e676966)](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/) ##### Linked Reports generated by Smart Report Maker [](#linked-reports-generated-by-smart-report-maker) On the other hand, Smart Report Engine is a reporting engine designed for PHP developers who prefer to build reports programmatically by calling the engine’s API directly from their code. Smart Report Engine is available in two editions: the Community Edition, which can be used only in personal or open-source community projects, and the Pro Edition, which can be used in commercial applications and hosted SaaS platforms and provides access to premium features. Licensing --------- [](#licensing) ### Can I use Smart Report Engine Community in a commercial project? [](#can-i-use-smart-report-engine-community-in-a-commercial-project) No. Commercial and SaaS usage require either [Smart Report Engine Pro](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/) or [Smart Report Maker](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/). ### Can I upgrade later? [](#can-i-upgrade-later) Yes. You can upgrade from Smart Report Engine Community to either Smart Report Engine Pro or Smart Report Maker at any time. ### Do licenses expire? [](#do-licenses-expire) No. All licenses are perpetual. Technical --------- [](#technical) ### Which PHP versions are supported? [](#which-php-versions-are-supported) PHP 7.4 and higher. ### Can I use Laravel? [](#can-i-use-laravel) Yes. Both Smart Report Engine Pro and Smart Report Maker provide Laravel integration. ### Where are generated reports stored? [](#where-are-generated-reports-stored) Inside the `/sre_reports` directory. ### Can I apply custom CSS? [](#can-i-apply-custom-css) Yes. Reports can be styled using the built-in report classes and a CSS editor. ### Are reports mobile responsive? [](#are-reports-mobile-responsive) Yes. Reports are responsive and mobile-friendly. Features -------- [](#features) ### Can I use filters and parameters? [](#can-i-use-filters-and-parameters) Yes. Both Smart Report Engine & Smart Report Maker include filters and parameters. ### Can I group data? [](#can-i-group-data) Yes. Both Smart Report Engine & Smart Report Maker support multiple grouping levels, subtotals and grand totals. ### Can I schedule reports? [](#can-i-schedule-reports) - **Smart Report Maker:** Yes - **Smart Report Engine Pro:** Via custom implementation - **Smart Report Engine Community:** No Security -------- [](#security) ### Can I restrict users to their own data? [](#can-i-restrict-users-to-their-own-data) Yes. You can filter data based on the logged-in user. ### Can I integrate with my authentication system? [](#can-i-integrate-with-my-authentication-system) Yes. Both Smart Report Engine and Smart Report Maker can integrate with existing authentication systems. Deployment ---------- [](#deployment) ### Can I deploy on shared hosting? [](#can-i-deploy-on-shared-hosting) Yes. Both Smart Report Engine and Smart Report Maker can be deployed on shared hosting. ### Can I deploy on VPS or cloud servers? [](#can-i-deploy-on-vps-or-cloud-servers) Yes. Both Smart Report Engine and Smart Report Maker can be deployed on VPS. Support ------- [](#support) ### What support is included? [](#what-support-is-included) - **Smart Report Maker & Smart Report Engine Pro:** Professional ticket-based support - **Smart Report Engine Community:** Community support ### How do I contact support? [](#how-do-i-contact-support) Documentation & Resources ----------------------------- [](#documentation--resources) ### Where can I find documentation? [](#where-can-i-find-documentation) - Smart Report Engine Documentation: - Smart Report Maker Documentation: ### Where can I find examples? [](#where-can-i-find-examples) Troubleshooting --------------- [](#troubleshooting) ### My report is blank. What should I check? [](#my-report-is-blank-what-should-i-check) - Database connection - SQL syntax - PHP error logs - File permissions ### Where can I find troubleshooting guides? [](#where-can-i-find-troubleshooting-guides) --- Customer Support ---------------- [](#customer-support) Contact us here: --- Important links --------------- [](#important-links) - Smart Report Maker: - Embed Manager of Smart Report Maker: - Smart Report Engine Pro: (Priced at $64) - More examples about Smart Report Engine: - Detailed license comparison: - Smart Report Engine Troubleshooting: - Smart Report Engine documentation (classes/methods/constants): - What's new: - Home Page of Smart Report Engine: - Contact Us: --- ⭐ Support the Project --------------------- [](#-support-the-project) - Star the repo - Report issues - Suggest features --- 📜 License --------- [](#-license) Smart Report Engine Community Edition License ##### The Community Edition permits you to: [](#the-community-edition-permits-you-to) - Experiment with Smart Report Engine (Non-Premium features only). - Freely utilize Smart Report Engine for personal use. - Freely integrate Smart Report Engine into free open-source projects as long as you keep our copyright claims. ##### The Community Edition restricts you from: [](#the-community-edition-restricts-you-from) - Accessing Premium features. - Integrating Smart Report Engine into commercial or SaaS projects. - Removing the "Powered by" claim from reports generated by the community edition of Smart Report Maker. > **NOTE:** By using any of our commercial editions, you are granted access to all premium features, as well as the removal of all community restrictions mentioned above: > --- 🏷 Trademark ----------- [](#-trademark) Smart Report Engine™ is a trademark of Webuccino Inc. --- 🤝 Contributing -------------- [](#-contributing) Fork → Branch → PR --- 🔎 Topics -------- [](#-topics) mysql mysql-report mysql-report-builder php-reporting analytics report-generator --- 👤 Author -------- [](#-author) Webuccino Creating easy-to-use products since 2007 ### Health Score 33 — LowBetter than 72% of packages Maintenance50 Moderate activity, may be stable Popularity21 Limited adoption so far Community7 Small or concentrated contributor base Maturity45 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~0 days Total 10 Last Release 1056d ago ### Community Maintainers ![](https://avatars.githubusercontent.com/u/139923924?v=4)[Webuccino Products](/maintainers/webuccinoco)[@webuccinoco](https://github.com/webuccinoco) --- Top Contributors [![webuccinoco](https://avatars.githubusercontent.com/u/139923924?v=4)](https://github.com/webuccinoco "webuccinoco (70 commits)") --- Tags bussiness-intelligencedata-tablesdatatablesmysqlmysql-reporting-toolsmysql-reportsmysql-virtualizationphpphp-libraryphp-reporting-toolsphp-reportsphpgridreport-generatorreportingreporting-toolreportsPHP Reporting FrameworkPHP Reporting ToolsPHP reporting enginePHP reporting APImysql reportsmysql reportingphp report builderreport builders for MYSQL ### Embed Badge ![Health badge](/badges/webuccinoco-sre-community/health.svg) ``` [![Health](https://phpackages.com/badges/webuccinoco-sre-community/health.svg)](https://phpackages.com/packages/webuccinoco-sre-community) ``` ### Alternatives [laravel/dusk Laravel Dusk provides simple end-to-end testing and browser automation. 1.9k39.6M298](/packages/laravel-dusk)[koolreport/core An Open Source PHP Reporting Framework for easier and faster report delivery. 179513.7k2](/packages/koolreport-core)[koolphp/koolreport An Open Source PHP Reporting Framework for easier and faster report delivery. 23041.0k1](/packages/koolphp-koolreport)[nineinchnick/edatatables Grid widget for the Yii Framework, wrapper for the DataTables jQuery plugin 173.2k](/packages/nineinchnick-edatatables)[link-cloud/fast-hyperf LinkCloud Fast Hyperf 241.2k1](/packages/link-cloud-fast-hyperf) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)