Joining Multiple Table and showing in PHP Grid and also saving data in different table from php grid

QuestionsJoining Multiple Table and showing in PHP Grid and also saving data in different table from php grid

Hi,
1.)While implementing the php Grid view we found problems in joining multiple table and showing its result in the grid.
2.) while saving data to multiple table at the time of edit / Save or Add/Save from Php grid.

please also help me if there is any possibility to save data through 'store procedure'.

Regards
Dibyendu Poddar

2 Answers
Abu Ghufran answered 10 years ago

Hello,

1) You can use $grid->select_command to write custom SQL query with JOINs.
2) To update multiple tables, you have to use custom events (on_insert, on_update, on_delete). In those events you can also call stored procedures. For reference, please check code in demos/editing/custom-events.php

Also, add [email protected] in gtalk for chat support.

Regards,

Van Canh Vu answered 8 years ago

1

Your Answer

19 + 20 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?