Trongate Docs
switch to dark modeswitch to dark mode
»
»
Table Joins

How Trongate Makes Table Joins Easy

Trongate comes with a model file that makes database interaction easy.  Full details about how this works are available from:

https://trongate.io/docs_m/information/how-trongate-works-with-databases

Did You Know?
Trongate does not use any third party libraries nor does it have an ORM.  Instead, Trongate uses PDO - a library that comes free of charge will all modern installations of PHP.  So, that's one more thing you don't have to learn and one more thing that you don't have to worry about!
 

When it comes to the business of perform table joins, the other PHP frameworks appear to be lost.  All of them essentially tackle this technical challenge with classes that usually take a long time to learn.  They're all difficult to learn, slow and not particularly flexible.  Trongate is different.

Trongate is the only web development framework in the world that gives users a 100% free graphical query builder.  By the way, it will always be free - and that's a promise!

With Trongate's graphical query builder you can easily create simple or complex table joins in seconds.  The graphical query builder will leave you with pure SQL code.  That means less overheads and considerably faster page loads than you'd find with other PHP frameworks.

Just To Let You Know
If you are creating an SQL query that accepts parameters from an end-user then you should use query binding to prevent SQL injection.  Full details can be found at:

https://trongate.io/docs_m/information/the-query-bind-method

Below is a video, demonstrating how to use Trongate's graphical query builder:

Video Demo

In this video I'm going to demonstrate how to use Trongate's graphical query builder to quickly generate SQL table joins



HELP & SUPPORT

If you have a question or a comment relating to anything you've see here, please goto the Help Bar.

 
×