Crud whith Query

ArtiGrid also allows you to build a CRUD interface using custom SQL queries through the query() method.

This gives you full control over the data source, enabling you to filter, join, or manipulate data directly from the query instead of relying on a fixed table.

It is especially useful for advanced scenarios where you need specific results or complex data structures.

<?php
    $grid = new ArtiGrid();
    $grid->query('SELECT * FROM products WHERE productCode = "S32_2206" ')
        ->template('bootstrap5')
        ->modal();
    echo $grid->render();
?>