Add CRUD to AdminLTE, SB Admin, Tabler & Any Bootstrap Template

Turn AdminLTE, SB Admin, Tabler & Any Bootstrap Template Into a Working Application. Bootstrap admin templates solve the design problem, GridPHP solves the functionality problem. Integrate GridPHP with popular templates to get Full CRUD capabilities in under 2 hours.

The Problem Every Developer Faces

You’ve just downloaded or purchased a beautiful admin template – maybe AdminLTE, Sb-Admin, Tabler, or a premium ThemeForest theme. The dashboard looks stunning. The charts are polished. The UI components are pixel-perfect. The documentation is comprehensive.

But here’s what’s missing: actual functionality.

Admin templates give you beautiful layouts, stunning widgets, and impressive demo pages. What they don’t give you is the ability to actually manage data. There’s no way to:

  • Create new users, products, or records
  • Display database records in searchable, sortable tables
  • Edit existing data with validated forms
  • Delete records with proper confirmation
  • Filter and search through your data
  • Export data to CSV, Excel, or PDF
  • Handle pagination for large datasets
  • Manage relationships between database tables

In short: admin templates lack CRUD (Create, Read, Update, Delete) operations – the fundamental building blocks of any real application.

This means developers spend 40-60 hours after buying a template to hand-code these basic operations. You’re essentially paying for a beautiful frontend, then rebuilding the entire backend from scratch for every project.

Use Cases & Scenarios

Small Business Owners Running Their Own Tech

You’re managing a retail shop, restaurant, or service business. You need to track inventory, customers, or bookings but can’t justify hiring a developer or paying for monthly SaaS subscriptions. You have basic PHP knowledge but realize the template you downloaded has no actual functionality.

Solo Developers Taking on Small Client Projects

You’re a freelancer building internal tools for local businesses on tight budgets. You can’t spend days building CRUD interfaces from scratch and still make money. You need something that works fast so you can focus on the business-specific logic.

Non-Profits and Community Organizations

You work for a non-profit with zero budget for software subscriptions. You need to manage donors, volunteers, or event attendees. Someone on your team knows enough PHP to run a website on shared hosting, and you need something that looks professional without ongoing fees.

Students and Bootcamp Graduates Building Portfolio Projects

You’re learning web development and need portfolio pieces that demonstrate real-world skills. You want to show you can build full-stack applications with professional UI, but hand-coding admin interfaces for every project eats up time you could spend learning other technologies.

IT Staff at Small-to-Medium Companies

You work in-house IT and management keeps asking for internal tools but won’t approve budget for enterprise software or outside developers. You’re already stretched thin and can’t spend weeks building admin interfaces for employee directories, asset tracking, or PTO request systems

How GridPHP Solves This

GridPHP bridges this gap by providing production-ready CRUD functionality that integrates seamlessly with any Bootstrap admin template:

What GridPHP Adds:

  • Database-driven datagrids – Display any database table with sorting, searching, and pagination
  • Inline editing – Edit records directly in the grid or through modal forms
  • Advanced filtering – Filter by any column with dropdown, date range, or text search
  • Bulk operations – Delete, export, or update multiple records at once
  • Data validation – Built-in validation rules for forms
  • Export functionality – Export to CSV, Excel, PDF with one click
  • Responsive design – Works perfectly on desktop, tablet, and mobile
  • Customizable themes – Automatically matches your template’s styling

The Result: Your AdminLTE, Sb-Admin, or any Bootstrap template goes from “beautiful but empty” to “beautiful and functional” in under 2 hours – without writing repetitive CRUD code or modifying the template’s design.

Instead of spending weeks building user management, product catalogs, order processing, and other data operations from scratch, you configure GridPHP once and get all of it working immediately.

Testcase Templates

I integrated GridPHP with multiple admin templates – from premium to free, Bootstrap 4 to Bootstrap 5 – to discover something powerful: any Bootstrap-based admin template (AdminLTE, AdminKit, Vuexy, SB Admin 2, Tabler, and hundreds more) can become a fully functional application in under 2 hours. I validated the integration approach with these templates representing different styles and price points:

Free Templates:

  • AdminLTE – 45,000+ GitHub stars, most popular
  • SB Admin 2 – 16,997+ downloads, Bootstrap 4 classic
  • Tabler – Modern Bootstrap 5, minimal and fast

Premium Templates:

  • Vuexy – 29,600+ ThemeForest sales, Bootstrap 5
  • Limitless – Material Design, enterprise-grade

These represent the full spectrum of Bootstrap templates available today. The same approach works with Sneat, Gentelella, Material Dashboard, Argon, and virtually any other Bootstrap-based template.

Integration Results

All templates integrated successfully with full CRUD capabilities including: create/read/update/delete operations, search and filtering, pagination, data export (CSV, Excel, PDF), responsive design, and template styling preservation.

✅ AdminLTE (Free – Bootstrap 4)

Integration Time: 40 minutes
Difficulty: Very Easy
Result: Perfect integration

AdminLTE is the most popular free admin template with 45,000+ GitHub stars. Its clean Bootstrap 4 structure and extensive documentation made integration straightforward.

Screenshot:

✅ Vuexy (Premium – Bootstrap 5)

Integration Time: 45 minutes
Difficulty: Easy
Result: Perfect integration with dark mode

Vuexy represents modern Bootstrap 5 templates with 29,600+ ThemeForest sales. The integration matched the template’s modern aesthetic perfectly, including dark mode support.

Screenshot:

✅ SB Admin 2 (Free – Bootstrap 4)

Integration Time: 35 minutes
Difficulty: Very Easy
Result: Flawless integration

With 16,997+ downloads, SB Admin 2 was the fastest integration thanks to its straightforward Bootstrap 4 structure and standard classes.

Screenshot:

✅ Tabler (Free – Bootstrap 5)

Integration Time: 40 minutes
Difficulty: Very Easy
Result: Fast, modern integration

Tabler is a popular open-source Bootstrap 5 template known for its minimal design and fast performance. The clean codebase made integration smooth.

Screenshot:

✅ AdminKit (Free – Bootstrap 5)

Integration Time: 50 minutes
Difficulty: ⭐⭐☆☆☆ (Easy)
Result: Clean, contemporary integration

AdminKit represents modern minimalist templates like Volt or Soft UI Dashboard. The modern Bootstrap 5 approach and minimal design philosophy resulted in a fast, contemporary admin panel with excellent mobile responsiveness.

Screenshot:

✅ Limitless (Premium – Material Design)

Integration Time: 1 hour 15 minutes
Difficulty: Moderate
Result: Excellent integration

Limitless represents Material Design templates. While requiring slightly more configuration due to custom components, the result was seamless integration with advanced filtering options.

Screenshot:

Integration Guidelines

You can review the integration guide and sample code snippet of the dashboards on this link.

Cost-Benefit Analysis

Traditional Hand-Coded CRUD Approach:

  • Development time: 40-60 hours
  • Developer cost (@$50/hr): $2,000-$3,000
  • Template cost: $0-$49
  • Total: $2,000-$3,049

GridPHP Integration Approach:

  • Integration time: 2-4 hours
  • Developer cost (@$50/hr): $100-$200
  • Template cost: $0-$49
  • GridPHP license: Free (or $99 Pro)
  • Total: $100-$348

Savings: $1,700-$2,700 per project (85-90% reduction)

Who Should Use This Approach?

Perfect For:

✅ Freelancers building client admin panels
✅ Agencies with multiple similar projects
✅ Startups needing fast MVPs
✅ Developers tired of repetitive CRUD coding
✅ Anyone who bought a template and needs backend functionality

Not Ideal For:

❌ Highly custom, unique data operations
❌ Projects requiring complex business workflows
❌ Applications with non-standard data models

Conclusion: Works with AdminLTE, CoreUI, and Any Bootstrap Template

After validating GridPHP integration with AdminLTE, CoreUI, Vuexy, SB Admin 2, Tabler, and Limitless – representing premium and free, Bootstrap 4 and 5, Material Design and standard – the conclusion is clear:

Any Bootstrap-based admin template (AdminLTE, CoreUI, Tabler, Sneat, Gentelella, Material Dashboard, Argon, Volt, and hundreds more) can be transformed into a fully functional application using the same integration pattern.

Key Takeaways:

  1. Integration is consistently fast – 35 minutes to 1.5 hours regardless of template
  2. The pattern is truly universal – Works with AdminLTE, Sb-Admin, Adminkit, Vuexy, Tabler, and more
  3. No template modifications needed – Keep your template pristine
  4. Significant ROI – 85-90% reduction in development time vs hand-coding
  5. Production-ready – All CRUD operations work flawlessly

Your Template Will Work Too

Using AdminLTE? Sb-Admin? Tabler? Some premium ThemeForest template? It doesn’t matter. If it uses Bootstrap (3, 4, or 5), the integration pattern shown here will work.

Ready to transform your admin template?

Get Started

Ready to elevate your applications? Contact our support team to learn how these features can transform your next project.

Start building better applications today with GridPHP templates!

Powerful New Features to Elevate Your Applications

We’re thrilled to announce new game-changing features that make our GridPHP application templates even more powerful and user-friendly. These enhancements streamline workflows and provide enterprise-level editing capabilities right out of the box.

1. Related Detail Grid as Popup Box

Seamless Master-Detail Relationships

Managing related data has never been easier! Our new popup-based detail grid feature transforms how users interact with master-detail relationships in your applications.

How It Works

When viewing records in your main grid, users can now click to instantly view and manage related details in an elegant popup overlay. No more navigating away from your current view or losing context.

Perfect For:

  • Order Management: View order items directly from the orders grid
  • Customer Records: See contact details, transactions, or notes in one place
  • Invoice Systems: Access line items without leaving the invoice list
  • Project Management: View tasks and assignments from the projects overview
  • Inventory Control: Check stock movements and transactions instantly

What This Means for Your Users

Your application users will appreciate the streamlined workflow. Whether they’re processing orders, managing customers, or tracking inventory, they can now work faster and more efficiently without the frustration of constant page navigation.

2. Retaining Filters – Global Filter Management

Set It Once, Filter Everywhere

Introducing a powerful new filtering paradigm that revolutionizes how users work with data across your application. With retaining filters, you can set global filters that persist across all grid operations, while still maintaining the ability to apply additional filters on top.

How It Works

Set a global filter once – such as “Show only active customers” or “Display current year records” – and that filter remains active across your entire session. All subsequent filtering, searching, and operations work within that globally filtered dataset.

Key Capabilities:

  • Persistent Global Filters: Set base-level filters that apply across the entire grid
  • Layered Filtering: Apply additional filters on top of global filters
  • Context Preservation: Global filters remain active even when navigating between sections
  • Easy Toggle: Turn global filters on/off without losing your settings
  • Multi-Criteria Support: Combine multiple global filter conditions

Real-World Use Cases

Multi-Tenant Applications:

  • Set global filter: Current client/company
  • Users automatically see only their organization’s data
  • Additional filters work within that scope for reports and analysis

Time-Based Data:

  • Set global filter: “Current fiscal year” or “Last 30 days”
  • All grid operations and reports stay within that time window
  • Drill down further with status, category, or other criteria

Perfect For:

  • Multi-user applications with role-based data access
  • Applications with large datasets that need regular scoping
  • SaaS platforms serving multiple clients/organizations
  • Time-sensitive applications (current period vs historical data)
  • Department-specific views in enterprise applications
  • Territory-based sales and CRM systems

3. Advanced HTML Text Editor Integration

Rich Content Editing Made Easy

Our templates now include a powerful, feature-rich HTML text editor that brings word processor capabilities directly into your web applications. The integrated HTML editor provides everything your users need to create professional, formatted content.

Formatting Options:

  • Text Styling: Bold, italic, underline, strikethrough
  • Headings: Multiple heading levels for proper document structure
  • Font Controls: Change fonts, sizes, and colors
  • Alignment: Left, center, right, and justify text
  • Lists: Bulleted and numbered lists with nesting support
  • Clean HTML Output: Generates semantic, standards-compliant HTML
  • Paste from Word: Intelligently handles content from Microsoft Word
  • Source Code View: Switch between visual and HTML editing modes

Ideal Applications

This feature is perfect for templates and applications that require rich content:

  • Content Management: Blog posts, articles, and pages
  • Email Composition: Professional email templates and messages
  • Documentation: User manuals, help articles, and guides
  • Notes and Comments: Detailed project notes and customer communications
  • Product Descriptions: Rich, formatted product information
  • Announcements: Company news and internal communications

Available Across All Templates

These features are now available in all our application templates:

  • Event Planning
  • Employee Directory
  • Expense Tracker
  • Donation Management
  • Sales CRM
  • Inventory Management
  • Patient Management

Each template is pre-configured with these features, ready to use and easy to customize for your specific needs.

Building on Excellence

These new features complement the robust capabilities already included in every template:

  • Dashboard with KPI boxes for at-a-glance insights
  • Multiple visualization options including bar charts, pie charts, and tables
  • Powerful data grid with full CRUD operations
  • Secure authentication and role-based authorization
  • User management system built-in
  • Mobile responsive design throughout

Get Started Today

Ready to experience these powerful new features? Visit our Template Center to explore all available templates and see these enhancements in action.

Why Upgrade or Get Started Now?

Faster Development: Build sophisticated applications in a fraction of the time Better User Experience: Your users will love the intuitive popup navigation and rich text editing Professional Quality: Enterprise features without enterprise development costs Future-Proof: Regular updates and enhancements keep your applications modern Excellent Support: Our team is ready to help you succeed

Next Actions

Active License Subscription customers can get free upgrade using this link.

Ready to elevate your applications? Explore our templates or contact our support team to learn how these features can transform your next project.

Start building better applications today with GridPHP templates!

Application Templates just got better!

We’re excited to announce major enhancements to our GridPHP application templates! Our template center has been completely revamped with powerful new features that make building data-driven applications faster and more intuitive than ever before.

What’s New?

Our enhanced templates now come packed with enterprise-grade features that transform how you visualize and interact with your data. Whether you’re building a CRM, inventory system, or any data-intensive application, these improvements will supercharge your development workflow.

Enhanced Dashboard with KPI Boxes

Get instant insights at a glance with our new KPI (Key Performance Indicator) boxes. The dashboard now features:

  • Real-time metrics displayed in clean, modern KPI cards
  • At-a-glance overview of your most important business metrics
  • Color-coded indicators for quick status assessment
  • Responsive layout that adapts beautifully to any screen size

Perfect for executives and team members who need to monitor critical business metrics without diving into detailed reports.

Advanced Data Visualizations

Interactive Bar Charts

Transform your data into compelling visual stories with our new bar chart visualization:

  • Dynamic filtering and drill-down capabilities
  • Customizable colors and themes
  • Hover tooltips for detailed information
  • Export functionality for presentations and reports

Ideal for comparing performance across categories, tracking trends over time, or analyzing sales by region.

Beautiful Pie Charts

Our pie chart visualization makes it easy to understand proportions and distributions:

  • Interactive segments with click-to-filter functionality
  • Percentage labels for clear data representation
  • Legend with color coding for easy reference
  • Smooth animations that engage users

Perfect for showing market share, budget allocation, or any categorical data distribution.

Comprehensive Table Visualizations

Need a detailed view? Our enhanced table visualization offers:

  • Sortable columns for quick data organization
  • Advanced filtering options
  • Pagination for large datasets
  • Inline editing capabilities
  • Export to Excel/CSV functionality

Great for users who need to work with detailed data records and perform in-depth analysis.

Powerful Data Grid

At the heart of every template is our enhanced data grid that gives you complete control:

  • CRUD operations (Create, Read, Update, Delete) out of the box
  • Advanced search and filtering
  • Bulk operations for efficiency
  • Inline and form editing modes
  • Column reordering and resizing
  • Conditional formatting for visual cues

Master your data with a grid that’s both powerful and user-friendly.

Organized Reports Menu

Navigate your application effortlessly with our new reports menu structure:

  • Hierarchical organization of reports and dashboards
  • Quick access to frequently used views
  • Custom menu items for your specific needs
  • Icon support for visual navigation
  • Collapsible sections to reduce clutter

Everything you need is just a click away, making navigation intuitive for all users.

Built on Solid Foundations

All these enhancements build upon the core features that have made GridPHP templates so popular:

  • Secure authentication system with login protection
  • Role-based authorization for granular access control
  • User management built-in
  • Mobile responsive design that works on all devices
  • Easy setup with loads of customization flexibility

Ready to Get Started?

Our enhanced templates are available now and include:

  • Event Planning
  • Employee Directory
  • Expense Tracker
  • Donation Management
  • Sales CRM
  • Inventory Management
  • Patient Management

Each template comes with all these new features pre-configured and ready to customize for your specific needs.

Why Choose GridPHP Templates?

  1. Save Development Time: What would take weeks to build from scratch is ready in minutes. Focus on customization instead of building basics.
  2. Professional Quality: Get enterprise-grade features without enterprise-level development costs.
  3. Outstanding Support: Our technical support team is here to help you succeed with quick, helpful responses.
  4. Easy Customization: Start with a working application and modify it to match your exact requirements.

Get Your Template Today

Visit our Template Center to explore all available templates and see these enhancements in action. Each template comes with complete source code, documentation, and our commitment to your success.

Transform your data into insights. Build applications that users love. Get started with GridPHP templates today!

Questions about our templates? Contact our support team – we’re here to help you choose the right template and get started quickly.

 

Handle Many-to-Many relations in GridPHP

Hello,

In this post, we’re showing a practical example, handling data of companies with multiple business interests.

GridPHP - Handling Many to Many Relations

The Problem

You have companies. Each company has multiple interests (Software Development, Cloud Computing, etc.). Each interest can belong to multiple companies.

The traditional approach means:

  • 3 tables with complex JOINs
  • Custom forms for managing relationships
  • Manual junction table handling
  • Hours of debugging

A Simpler Way

Here’s a working example using GridPHP that handles all the complexity automatically.

Database Setup

-- Three simple tables
CREATE TABLE companies (
  id int PRIMARY KEY AUTO_INCREMENT,
  name varchar(255),
  address varchar(255),
  phone varchar(15)
);

CREATE TABLE ref_interest (
  id int PRIMARY KEY AUTO_INCREMENT,
  name varchar(45)
);

CREATE TABLE company_interest (
  company_id int,
  interest_id int,
  PRIMARY KEY (company_id, interest_id)
);

The Smart Query

Instead of showing relationships in separate rows, use GROUP_CONCAT:

$g->select_command = "SELECT c.id, c.name, c.address, c.phone, 
                      GROUP_CONCAT(i.id) as interests
                      FROM companies c 
                      LEFT JOIN company_interest ci ON c.id = ci.company_id 
                      LEFT JOIN ref_interest i ON ci.interest_id = i.id 
                      GROUP BY c.id";

This displays all interests for each company in a single row.

Auto-Handle Junction Table

The key is custom handlers that manage the junction table automatically:

function update_company_interest($data) {
    global $g;

    // Update company info
    $g->execute_query("UPDATE companies SET name=?, address=?, phone=? WHERE id=?", 
                      array($data["params"]["name"], 
                            $data["params"]["address"], 
                            $data["params"]["phone"], 
                            $data["id"]));

    // Delete old relationships
    $g->execute_query("DELETE FROM company_interest WHERE company_id=?", 
                      array($data["id"]));

    // Insert new relationships
    if (!empty($data["params"]["interests"])) {
        $interest_ids = explode(",", $data["params"]["interests"]);
        foreach ($interest_ids as $interest_id) {
            $g->execute_query("INSERT INTO company_interest VALUES (?, ?)", 
                            array($data["id"], $interest_id));
        }
    }
}

Multi-Select Interface

Add a searchable multi-select dropdown:

$col["edittype"] = "select";
$col["editoptions"] = array(
    "value" => $g->get_dropdown_values("SELECT id, name FROM ref_interest"),
    "multiple" => true,
    "dataInit" => "function(el){ 
        jQuery(el).select2({tags:true}); 
    }"
);

The Result

Users see a grid with companies and their interests. When editing:

  1. Click edit on any row
  2. Multi-select dropdown appears with search
  3. Select/deselect interests
  4. Save – junction table updates automatically

Time saved: 3 days → 1 hour

GridPHP - Handling Many to Many Relations

Use This Pattern For:

  • Users ↔ Roles
  • Products ↔ Categories
  • Students ↔ Courses
  • Posts ↔ Tags

Complete Code

Full working example: GitHub Gist

Bottom line: Many-to-many relationships don’t need to be complicated. Use GROUP_CONCAT for display, custom handlers for the junction table, and a multi-select UI for user-friendly management.

Have a many-to-many challenge? This pattern works for any scenario with 3 tables and complex relationships.

Next Actions

Active License Subscription customers can get free upgrade using this link.

Expand Row to View Details

Hello,

Exciting update for PHP developers! GridPHP now allows you to view row data by expanding the row grid, making data exploration more intuitive and user-friendly.

The working demo can be checked online and inside full version package in demos/master-detail/subgrid-view.

Live Demo: Click Here

Next Actions:

Active License Subscription customers can get free upgrade using this link.

DataGrid AI Assistant – Smarter Data Analysis & Insights!

Experience the Power of AI in Grid 4 PHP Framework!

We’re thrilled to introduce a game-changing feature in Grid 4 PHP – the AI Assistant! Now, you can interact with your DataGrid like never before. Simply ask questions about your data, and the AI Assistant will provide instant insights, trends, and summaries – saving your time and effort.

Get a quick overview by watching the intro video.

What Can AI Assistant Do for You?

✔ Get instant summaries and reports from your DataGrid
✔ Ask complex queries and receive smart insights
✔ Automate analysis without writing complex SQL queries
✔ Provide smart suggestions for better data analysis

How to Use the AI Assistant?

Open Your DataGrid & Click on the AI Assistant button.

It will suggest you some insights which you may ask. Type your query (e.g., “Show me the top 10 sales regions”).

Get instant insights and smart recommendations!

Unlock This Feature Today!

  • If you’re on a free version, now is the best time to upgrade and unlock the full potential of AI-driven data intelligence – Buy Licensed Version.
  • If your subscription has expired, renew today and stay ahead with cutting-edge technology! – Upgrade Now to latest version.
  • This feature update is available for free to all users with an Active Subscription! – Get your Free Upgrade using this link.

Stay ahead with the next generation of data intelligence in Grid 4 PHP Framework!

Released Version 3.0

Welcome to the new release (version 3.0) of the Grid 4 PHP Framework. There are many updates in this version that we hope you will like. The following are some of the key highlights.

  • Ready-made Application Templates
  • Laravel v12 Integration
  • Improved WordPress v6 Integration
  • UI and Design improvements
  • Free Version with Premium Features
  • Several Optimizations & Updates

Ready-made Applications: We’ve developed several ready-to-use applications using our PHP DataGrid Framework, which includes built-in features such as:

  • Authentication System
  • Role-based authorization
  • User management.

In the code, simplicity is maintained to make it easier to understand and customizable. Making these applications significantly enhanced the core library and added many improvements.

We have released five application templates so far, with more coming soon.

  1. Sales CRM
  2. Inventory Tracking System
  3. Employee Directory
  4. Donation Management
  5. Expense Tracker

Following is the screen of Sales CRM Demo:

Following is the screen of Employee Directory Demo:

Laravel v12 Integration: Grid 4 PHP Framework is tested with Laravel v12. Seamlessly combine the power of responsive PHP DataGrid with Laravel to build your next web application with ease and efficiency.

WordPress6 Integration: We’ve further enhanced the integration of our DataGrid solution with WordPress, now supporting Master-Detail Sub-Grids and file uploads. Read more here.

Bootstrap5 Integration: Grid 4 PHP Framework is ready to use with Bootstrap v5.3. Roll-out your next web-application with combining power of responsive PHP Data Grid and Bootstrap5 UI design.

Free Version with Premium Features:

In this release, we’ve revamped the packaging of our free version! It now includes all premium features, including sample application templates, allowing free users to experience the full power of our product. The only limitation? A restricted number of records per grid.

The free version is available for evaluation and non-commercial use, giving you a complete preview of what our framework can do before upgrading.

Other Updates & Optimizations:

  • Direct URL of add/edit/view dialogs
  • Enhanced URL based filtering scheme
  • Import module now updates data based on existing first column
  • Integrated select2 component for dropdowns if JS library included
  • Audit log data added for insert and update events

Next Actions:

Active License Subscription customers can get free upgrade using this link.

Laravel DataGrid Guide

Looking for a robust DataGrid solution for your Laravel application? Our product offers a comprehensive DataGrid interface with CRUD (Create, Read, Update, Delete) features, providing a seamless way to manage and display data without relying on Eloquent.

Following is the guide to integrate PHP Editable DataGrid with Laravel v12.

Step1: Folder placements in Laravel.

There are 2 main folders in Grid 4 PHP Framework package archive. You need to:

Copy the contents of lib/inc folder —> <Laravel>/app/Classes/Gridphp
Copy the contents of lib/js folder —> <Laravel>/public/assets/gridphp

The ‘app/Classes’ folder does not exist by default in Laravel. You may create it for 3rd party class libraries.
Create another folder inside it with name ‘Gridphp’ and move all contents of ‘lib/inc’ in it. Final result will look like this:

In similar way, copy the files from lib/js to laravel/public/assets/gridphp. Final result should look like following:

Step2: Setting Up Factory Class & Controller:

To use datagrid object in controller, we have setup a factory class in ‘laravel/app/Gridphp.php’. The purpose of this class is to:

  • Set the database configuration.
  • Autoload the library files
  • Provide a get() method to be used in controller.

Now in controller, we used the namespace of our factory class and called the get() function to get the datagrid object. The rest code is same as in our demos. Finally, we passed the output of render() function to view with a variable name ‘grid’.

For demo purpose, we’ve modified ‘laravel/app/Http/Controllers/WelcomeController.php’

Step3: Setting View code:

  1. In view code, we included the JS/CSS files from the ‘js’ folder which we copied in Step 1.1
  2. And using blade template variable output, we pushed the grid output in our desired place in html.
  3. We have html meta tag for ‘csrf-token’, which is required by laravel for POST operations. Also added JavaScript code to pass CSRF-TOKEN in ajax request calls, as mentioned in Laravel docs.

For demo purpose, we slightly modified ‘laravel/resources/views/welcome.blade.php’

Step4: Setting Routes

The Last step in this tutorial is to set the routes to our controller. We will use both GET and POST routes as our grid uses both methods.

Note: The DataGrid does not rely on Eloquent ORM model of Laravel. It uses its own backend libraries.

Result: The Editable DataGrid for Laravel!

Next Actions:

Using Grid 4 PHP Framework in WordPress

As popularity of WordPress is growing really fast, we’ve published a new simplified tutorial on how to integrate Grid 4 PHP Framework with WordPress Sites. WordPress misses a comprehensive Editable Table, DataGrid and a CRUD solution, so we’ve integrated it to solve the problem.

It allows using all features of our Data Grid inside WordPress and much simpler than previous implementations. Steps required to integrate are following:

Updated 10-Dec-2024: New revised tutorial supports:

  • Nested Sub-Grids for Master-Detail views supported now.
  • File uploading Support

Updated 30-July-2024: New revised tutorial supports:

  • PHP 8.3 and WordPress 6.4.3
  • DataGrid custom event handlers as well.

Step1: Download Free version or Buy package from our website (if not already done) and move “lib” folder from package in your WordPress root directory, and rename “lib” folder as “phpgrid”

and inside this folder the contents should be:

Step2: Install WordPress plugin “Code Snippets” from wordpress.org/plugins/code-snippets/ OR download from Github Repository and install manually.

Step3: Goto admin panel and click Add Snippet as in image. Add any title you like and in code section, copy paste this Sample Snippet Grid Code in code section shown below:

Step4: In this code, we have created a shortcode here same as class name: [phpgrid_users] and we will now place it on page where we want to show our Datagrid.

Result: Now Save the page and open / preview it, you will get the Datagrid.

WordPress featuring Sub-Grids:

Adding Grid in WordPress Admin Area:

Following steps will be required to make shortcode available in admin area – plugin development.

Step1: Add admin_init & admin_footer hook along with others.

Step2: Select ‘Run Snippet everywhere’ after snippet code block.

Step3: Call do_shortcode() function where you want to show datagrid.

Result:

You can create more snippets by copying code from package demos and assign new unique class name for each grid which can be placed on your page/post of WordPress.

Let us know your feedback. If you have any questions, contact our support center.

Next Actions:

Active License Subscription customers can get free upgrade using this link.

Released Version 2.9

Welcome to the new release (version 2.9) of the Grid 4 PHP Framework. There are many updates in this version that we hope you will like, Following are some of the key highlights.

  • PHP 8.3 support
  • CodeIgniter v4 Integration
  • Using with Laravel v11
  • WordPress v6 Integration
  • Bootstrap v5 Integration
  • Drag-and-Drop Row Sorting, Effortlessly
  • Capture Digital Signatures with DataGrid
  • Badges and Dropdown rows
  • Rating plugin
  • New Html Input Types support: e.g. color, number, date
  • Export to MS-Word
  • UI and Design improvements
  • Security updates

CodeIgniter 4 Integration: We’ve made a quick walk-through how to integrate the smart PHP DataGrid with CodeIgniter framework.

Row Drag-and-Drop Sorting: To manage and organize your data in an intuitive and user-friendly manner.

WordPress6 Integration: We’ve published a new simplified tutorial on how to integrate Grid 4 PHP Framework with WordPress Sites.

Bootstrap5 Integration: Grid 4 PHP Framework is ready to use with Bootstrap5. Roll-out your next web-application with combining power of responsive PHP Data Grid and Bootstrap5 UI design.

Capturing Digital Signature: You can now take Digital Signatures using DataGrid and save it in the database.

Star Rating Plugin: Add a rating star plugin to be used as a column formatter.

Fixes:

  • Database layer library update
  • Toolbar button position, Autoheight update
  • Excel export library update
  • Better MS SQL Server FreeTDS support
  • Informix database fixes
  • Many reported bug fixes and updates.

This version will work on PHP v7 and onwards. For older PHP versions, v2.8.2 was the last stable release.

Next Actions: