Skip to main content

crud-whith-query

Using Custom Queries​

ArtiGrid allows you to execute any SQL query as the data source for your grid.
You are not limited to a single table — you can use SELECT, JOIN, filtered queries, subqueries, or even database views.

This gives you full flexibility to control exactly what data is displayed.

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