Google Ad

MySQL Editor Tutorial for Laravel CRUD – CMS – Sximo 5 LTS PHP Script


MySQL Editor Tutorial for Laravel CRUD – CMS – Sximo 5 LTS PHP Script

 

At the first time you create module, system will create automatic single query table

Why SXIMO BUILDER Creating automatic ” WHERE employee.EmployeeId IS NOT NULL ” ? this is for prevent error when users submit search form.

Every fields included on query select, will be displaying at grid table including fields from join table. so make sure every field you want to show on table grid and view detail, must be on your query statement

Everytime you made changes with SQL editor , you have to rebuild Files

Working with join Query ( Displaying 2 or more table )

Example Join Query
SELECT customer.*,tb_users.* FROM customer LEFT JOIN tb_users ON customer.staffid = tb_users.id 

If we using above statment , Grid table will automatically dispaying all SELECT statment from2 tables.

Keep in your mind , althought we can displaying table grid form 2 or more table , form , insert , edit and remove operation only affected for 1 table ( primary table )

 

 

Laravel CRUD – CMS – Sximo 5 LTS PHP Script Download

 

 

Have any Question or Comment?

Leave a Reply

Your email address will not be published. Required fields are marked *