Multi table relation (nested tables) Editing of related records in other table (Added in v 2.0)

PDOCrud allows the editing of related records of different table i.e. similar to nested table. Nested Table is a table inside a table. It is not stored in that way but similar concept is used. You can define relation between the two tables data using some binding column value. Click here for tab version

  
                                 //student table object
                                $pStudent = new PDOCrud();
                                //student's class object
                                $pStudentClass = new PDOCrud(true);
                                $pStudentClass->crudTableCol(array("class_id", "class_name", "code"));
                                $pStudentClass->dbTable("class");

                                //first paramater is first table(object) columnn name and 2nd parameter is 2nd object column name
                                $pStudent->multiTableRelation("class_id", "class_id", $pStudentClass);

                                //student's class object - adding one more table 
                                $pStudentTransport = new PDOCrud(true);
                                $pStudentTransport->dbTable("vehicle");

                                //first paramater is first table(object) columnn name and 2nd parameter is 2nd object column name
                                $pStudent->multiTableRelation("transport_id", "vehicle_id", $pStudentTransport);
                                //2nd level of nesting  - relating section to class(first student to class and then class to section)
                                $pStudentSection = new PDOCrud(true);
                                $pStudentSection->dbTable("section");

                                //first paramater is first table(object) columnn name and 2nd parameter is 2nd object column name
                                $pStudentClass->multiTableRelation("class_id", "class_id", $pStudentSection);

                                $pStudent->crudTableCol(array("student_id","first_name","last_name"));//optional
                                echo $pStudent->dbTable("student")->render();
                        

Student

Showing 1 to 10 of 10 entries

# Student id First name Last name Actions
1 1 Nitishassss Patil
2 2 vaishali patel
3 3 ankit patidar
4 4 x x
5 5 rahul verma
6 6 snehal kri
7 7 aliya bhatt
8 8 kareena khan
9 9 karishma kapoor
10 10 nn sdf
# Student id First name Last name Actions