How to join multi tables with INNER JOIN to view desired columns from tables

[ZeroDev96]

Hello guys,

How is the coding part for ajax.php and index.html for doing a multiple INNER JOIN and viewing specific columns from tables?

Thanks

[optikalefx]

You would use the fields and joins properties as normal.

$grid = new Grid("users", array(
    "fields" => [
         "table2.foo" => "bar",
         "table3.baz => "butts"
    ],
    "joins" => [
         "inner join ...",
         "inner join ..."
    ]
  ));

Then in the HTML

<th col="bar">
<th col="butts">

[ZeroDev96]

What do you mean by Bar,Butts??
This is my actual code:
index.html

Clienti

    <table class="clienti" action="ajax.php">
        <tr>
            <th col="id">ID Cliente</th>
            <th col="nome">Ragione Sociale</th>
            <th col="citta">Città</th>
            <th col="indirizzo">Indirizzo</th>
        </tr>
             </table>

ajax.php

require_once("grid.php");
$grid = new Grid("clienti", array(
"fields" => [
"sedi.citta" => "citta",
"sedi.indirizzo" => "indirizzo"
],

        "joins" => [
            "inner join sedi on sedi.id_cli = clienti.id"

        ]

    ));

Columns id and nome are in table Clienti, while columns Citta and Indirizzo are in table Sedi.
I tried your join command but not working. The web table is blank

[optikalefx]

do you get any errors either in your PHP errors file or in the network request in the browser?

[ZeroDev96]

No