Product Updates

Home » Product Updates » Page 2

Upgrade Spreadsheets to a Smart AI Data Tables

Upgrade Your Spreadsheet to a Database with AI-Powered DataGrid

Many developers and businesses start by managing data in Excel spreadsheets or Google Sheets. While spreadsheets are easy to use, they quickly become messy, hard to scale, and insecure when shared. If you’ve ever struggled with broken formulas, version conflicts, or slow performance, it’s time to upgrade your spreadsheet to a real database.

That’s where GridPHP comes in — turning your spreadsheet-like workflow into a powerful PHP MySQL database editor. You get the flexibility of a spreadsheet, combined with the security, scalability, and performance of a relational database.

Why Move Beyond Spreadsheets?

  • 📉 Spreadsheets don’t scale: Large data sets become slow and error-prone.
  • ⚠️ Data integrity issues: Anyone can break formulas or accidentally delete rows.
  • 🔒 Security risks: Sharing Excel files isn’t safe for sensitive data.
  • 🤝 Collaboration limits: Difficult to manage real-time, multi-user edits.

GridPHP: Your Spreadsheet-to-Database Upgrade

With GridPHP, you can replicate the spreadsheet editing experience directly on top of a MySQL or PostgreSQL database. Developers get an instant PHP CRUD editor with features like:

  • ⚡ Editable Data Grid: Inline editing & form editing just like a spreadsheet.
  • 📊 Smart Table UI: Sorting, filtering, grouping, and pagination built-in.
  • 📥 CSV/Excel Import & Export: Migrate spreadsheets directly into your database.
  • 🎨 Modern Themes: Bootstrap 5 responsive designs for admin panels.
  • 🤖 AI DataGrid Assistant: Query, filter, and summarize your data in plain English.

Code Example – From Spreadsheet to Database

Here’s how simple it is to turn your MySQL table into a live, editable PHP grid:


  <?php
  include("inc/jqgrid_dist.php");

  $db_conf = array(
      "type"     => "mysqli",
      "server"   => "localhost",
      "user"     => "root",
      "password" => "",
      "database" => "mydb"
  );

  $g = new jqgrid($db_conf);
  $g->table = "inventory"; // imported spreadsheet table

  echo $g->render("list1");
  ?>

This single snippet gives you an editable web-based database interface that feels like a spreadsheet — but powered by MySQL.

Unique Benefits

  • ✅ Spreadsheet simplicity with database reliability.
  • ✅ Multi-user support with role-based access control.
  • ✅ Avoid data corruption and maintain integrity.
  • ✅ Rapid development — no need to code CRUD manually.

Try GridPHP Today

If you’re tired of juggling messy spreadsheets, download GridPHP and instantly upgrade your workflow to a secure, scalable database editor.
Stop fixing spreadsheets — start managing real data.

Build a PHP MySQL Editor in Minutes with AI-Powered DataGrid

PHP MySQL Editor – Fast, Secure & Browser-Based Data Management

Editing and managing MySQL data is one of the most common requirements for PHP developers. Managing MySQL data shouldn’t require clunky desktop tools or endless boilerplate code. A modern PHP MySQL Editor lets you browse, edit, and manage tables directly in the browser—ideal for admin panels, internal dashboards, and CRUD-heavy apps. With the right toolkit, you can turn raw database tables into a clean, editable interface in minutes 🚀.

Instead of coding repetitive CRUD logic manually, you can use GridPHP to instantly create a PHP MySQL Editor with sorting, filtering, pagination, and inline editing — all in just a few lines of code.

What Is a PHP MySQL Editor?

A PHP MySQL Editor is a web-based interface for creating, reading, updating, and deleting MySQL records (PHP CRUD). It behaves like a spreadsheet—inline edits, instant saves, smart filters and data validation—without writing repetitive code. Think of it as a developer-friendly layer on top of MySQL that ships with the essentials out-of-the-box.

Why Use GridPHP for PHP MySQL Editing?

  • ⚡ Minimal Code: Fully functional CRUD in under 10 lines.
  • 📊 Smart Table UI: Sorting, filtering, search, and paging out of the box.
  • ✍️ Editable Grid: Inline editing and form-based editing for records.
  • 🔄 MySQL CRUD Support: Create, read, update, and delete data with built-in validation.
  • ⚡ Sorting & Pagination: Smooth navigation across large datasets.
  • ✅ Relations Support: Lookups for foreign keys, dropdowns for related tables.
  • 📂 Import/Export: Handle CSV/Excel seamlessly.
  • 🎨 Bootstrap UI: Responsive and modern look without extra effort.
  • 🤖 AI DataGrid Assistant: Ask in plain English to filter, search, or summarize your MySQL data.

Benefits Over Manual Coding

  • Speed: Ship production-ready data screens in hours, not weeks.
  • Maintainability: Centralized CRUD logic and reusable components.
  • Consistency: Uniform UX for tables, filters, and exports across modules.
  • Scalability: Server-side processing handles large tables efficiently.
  • Flexibility: Hook into events, validators, and custom actions without reinventing the wheel.

Common Use Cases

  • Admin panels for SaaS and internal tools
  • Content and catalog management (products, users, orders)
  • Operational dashboards with editable queues and statuses
  • Data cleaning and back-office editing for support teams

Code Example – PHP MySQL Editor in Action

Here’s how you can create a PHP MySQL Editor in just a few lines using GridPHP:


  <?php
  include("inc/jqgrid_dist.php");

  $db_conf = array(
      "type"     => "mysqli",
      "server"   => "localhost",
      "user"     => "root",
      "password" => "",
      "database" => "mydb"
  );

  $g = new jqgrid($db_conf);
  $g->table = "users"; // MySQL table to edit

  echo $g->render("list1");
  ?>

That’s it — this snippet instantly gives you a browser-based PHP MySQL Editor with CRUD, sorting, paging, and filtering enabled.

Try It Yourself

Stop wiring CRUD by hand. Spin up a PHP MySQL Editor that’s fast, secure, and easy to customize.

Download and try it free — build a production-ready MySQL editor in minutes.

PHP Editable Grid – Smart PHP CRUD Table & AI-Powered DataGrid

Managing data in PHP applications can be time-consuming. Developers often need to build features such as
CRUD (Create, Read, Update, Delete), editable PHP tables, search filters, pagination, import/export, and responsive
designs. Writing all of this from scratch takes significant effort and leads to repetitive work.

This is where GridPHP comes in 🚀 — a powerful PHP Editable Grid (PHP DataGrid) designed to simplify
PHP CRUD tables and accelerate development.

GridPHP – PHP Editable Grid & Smart CRUD Table

GridPHP makes it simple to create fully functional, interactive PHP datatables with minimal coding.
It offers everything developers need for a professional data management solution:

  • ✅ Inline and form-based editing for true PHP editable grids
  • ✅ Full CRUD support (Add, Edit, Delete, View)
  • ✅ Smart search, filtering, and sortable columns
  • ✅ AJAX-powered performance for seamless data handling ⚡
  • ✅ Import & Export options (Excel, CSV)
  • ✅ Master-detail grids and nested subgrids
  • ✅ Multiple database support (MySQL, PostgreSQL, MS SQL, Oracle, SQLite)

What makes GridPHP unique is its AI-powered PHP DataGrid assistant 🤖. Instead of writing complex queries,
developers can type natural language commands like:

  • “Show orders above $1000”
  • “List users who registered last month”

This makes data handling faster, smarter, and more intuitive.

Unique Benefits of GridPHP

  • ✨ Rapid Development: Build PHP CRUD tables in minutes.
  • ✨ Developer-Friendly: Clean API designed by developers, for developers.
  • ✨ AI-Powered DataGrid: Natural language queries without SQL.
  • ✨ Modern Design: Responsive, Bootstrap 5 ready, and customizable themes.
  • ✨ Multi-Database Connectivity: Works across major databases seamlessly.

Try GridPHP for Free

Why spend hours coding repetitive CRUD logic when you can set up a
fully functional PHP Editable Grid in just a few lines of code?

👉 Download the free version of GridPHP and experience how quickly you can build
PHP CRUD tables, smart datatables, and AI-powered datagrids.

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:

PHP DataGrid for CodeIgniter

Update: Checkout our docs for new Codeigniter Starter App and Master-detail grid walkthrough using composer.

We’ve made a quick walk-through how to integrate the smart PHP DataGrid with CodeIgniter framework. For this, we have used:

  • Grid 4 PHP Framework 2.9
  • Latest version of CodeIgniter (v4+)
  • PHP 8 (can work on lower supported versions as well)

In this code we used MySQL, however you can use PHP DataGrid combination with almost all famous Database engines including Oracle, Microsoft SQL Server, DB2, Postgres, SQLite, Firebird, etc.

Steps:

Steps to integrate are very simple.

  1. Download CodeIgniter archive from Github repository and extract it in your public_html / htdocs / similar web public folder of your web server. Make sure it is showing the CI startup page.
  2. Download the Grid4PHP archive from our website. You can either use free OR paid version, Comparison is available here. Free version provides basic essential functions for evaluation purpose.
  3. Extract the Grid4PHP archive and move the ‘lib’ folder from archive to the ‘public’ folder of CodeIgniter.
  4. Replace the code of CI’s Controller app\Controller\Home.php with this sample controller code.
  5. In View, include the JS and CSS files and echo variable passed from controller. CI’s View welcome_message can be replaced with this sample view code.
  6. In Controller, make sure you set the database configuration (Line 9-14) and a table to fetch data (Line 45), according to your requirement. Refer lines in sample controller code.

Troubleshooting:

  • Getting “Whoops! We seem to have hit a snag. Please try again later”. If you see this message after setting up, please check the log file of CodeIgniter in “writable/logs” folder. It will tell the exact reason behind it.
  • Make sure you have “intl” and “curl” php extensions installed. They are required by CodeIgniter 4.
  • You can always open a support ticket for us.

Next Actions:

SQL Server Integration Just Got Better with PHP Data Grid

Hello,

We’ve just added improved support to use our PHP Data Grid with MS SQL Server. The demo browser that comes with the product can now be tested with SQL Server database along with MySQL database.

To install demos with PHP and MS SQL Server, Download the package from our download page and then install the database from the MS SQL Server database script.

To connect MS SQL Server, you must have SQL Server Native driver for PHP installed on your environment. Next you can use one of the following connection settings to be set in config.php. For example:

// Using PDO
define("PHPGRID_DBTYPE","pdo");
define("PHPGRID_DBHOST","sqlsrv:Server=den1.mssql5.gear.host");
define("PHPGRID_DBUSER","testdb63");
define("PHPGRID_DBPASS","testpass");
define("PHPGRID_DBNAME","testdb63");

// Using PHP Native SQL Server Driver
define("PHPGRID_DBTYPE","mssqlnative");
define("PHPGRID_DBHOST","den1.mssql5.gear.host");
define("PHPGRID_DBUSER","testdb63");
define("PHPGRID_DBPASS","testpass");
define("PHPGRID_DBNAME","testdb63");

// Using OBDC Driver
define("PHPGRID_DBTYPE","odbc_mssql");
define("PHPGRID_DBHOST","Driver={SQL Server};Server=den1.mssql5.gear.host;Database=testdb63;");
define("PHPGRID_DBUSER","testdb63");
define("PHPGRID_DBPASS","testpass");
define("PHPGRID_DBNAME",null);

Troubleshooting:

Best way to troubleshoot database connection is to make an independent php file with just php-sqlserver connection code as shown in php manual. When it works, just put the verified configuration in config.php file of php data grid.

What Next:

Generate your Datagrid Online for Free - No Code Required
⚡️ Build with AI Now →
//