hamit asked 10 years ago
I am a student. I use phpgrid at my Project. I set the ID field to selectbox. But as I show namefield value from another table … I want to show with TCPDF showing the namefield. However, the ID field is displayed.
My Database Tables is lesson and selectedcourses . I am sending tables and my php file in the appendix.
These tables are connected to each other via the ID field.
http://www.hamitaksoy.com/problem.zip //Files is here.
Thank you for your help.
yours sincerely,
Hamit AKSOY
Abu Ghufran answered 10 years ago
Hello,
1) Set dbname and remove formatter
$col["dbname"] = "invheader.client_id";
2) Set label as id_field (c.name as client_id)
$g->select_command = "SELECT i.id, invdate, c.name as client_id FROM invheader i
INNER JOIN clients c ON c.client_id = i.client_id";
Demo: http://phpgrid.org/demo/demos/export/export-excel.php
Code: http://phpgrid.org/demo/demos/export/export-excel.phps
