PHP Classes

multiple table

Recommend this page to a friend!

      phpMyDataGrid - AJAX Enabled Datagrid  >  All threads  >  multiple table  >  (Un) Subscribe thread alerts  
Subject:multiple table
Summary:since I can do this without errors
Messages:6
Author:sebabustelo
Date:2006-09-26 05:19:57
Update:2012-03-06 11:37:23
 

  1. multiple table   Reply   Report abuse  
Picture of sebabustelo sebabustelo - 2006-09-26 05:19:57
how can show (insert,delete,update) multiple table with phpMyDatagrid
becouse me cause error when it attempt.For show not problem but when want save or update me cause error.
this is my consult:

$Browse -> sqlstatement("select ic.id,ic.fecha,ic.tipo,ic.num, p.cuit,p.apellido,ic.idprov,ic.idcont,ic.imp_neto,ic.imp_total_fac
from proveedor p ,iva_compra ic ,contribuyente c
where ic.idcont = c.id and
p.idprov=ic.idprov")


congratulations for this clase, I am myself very useful
excuse my writing,I do not understand much English

  2. Re: multiple table   Reply   Report abuse  
Picture of Gustavo Arcila Gustavo Arcila - 2006-09-26 12:41:23 - In reply to message 1 from sebabustelo
Hi,


sorry, the class is capable to save data from only one table.


Regards,

  3. Re: multiple table   Reply   Report abuse  
Picture of tanvir anowar tanvir anowar - 2007-02-04 19:09:36 - In reply to message 2 from Gustavo Arcila
Dear Gustavo

is it possible to update your code ( phpMyDataGrid ) for multi table support. it found your class very useful but the only one limitation i have found is "don't supporting multi table."

thanking you

Tanvir.

  4. Re: multiple table   Reply   Report abuse  
Picture of Fábio Fábio - 2012-03-06 11:37:23 - In reply to message 2 from Gustavo Arcila
Its search for the selects from the database, and make selects and subselects?

  5. Re: multiple table   Reply   Report abuse  
Picture of Naveen Upadhyay Naveen Upadhyay - 2014-12-29 05:45:12 - In reply to message 2 from Gustavo Arcila
if i set the table name as a php variable,
eg:
...
...
if(isset($_REQUEST['tablename'])) $tablename=$_REQUEST['tablename'];
$objGrid -> tabla("$tablename");
...
...

the table does not get updated in the database, no errors at all.
while if i take a simple string referring to the table name, say 'tablename' it works fine.
Any comments ?
please help.

  6. Re: multiple table   Reply   Report abuse  
Picture of Gustavo Arcila Gustavo Arcila - 2015-01-07 01:58:21 - In reply to message 5 from Naveen Upadhyay
you must propagate tablename parameter using $objGrid->linkparam("tablename=" . $_REQUEST['tablename']);


regards