Many-to-many relations Default theme
Many-to-many (FK) relations can be displayed as simple multiselect fields. This method changes only fk table.
HIDE CODE
                
                
                <?php
	$xcrud = Xcrud::get_instance();
    $xcrud->table('customers');
    $xcrud->columns('customerNumber,Customer orders,city');
    $xcrud->fk_relation('Customer orders','customerNumber','customers_orders_fk','customer_id','order_id','orders','orderNumber',array('orderNumber','orderDate'));
    echo $xcrud->render();
?>
                                
                
                Customers
        
 Add                     Export into CSV             Print                                                Search            
            
        
        	
                     
                       
                    
                        
                     	      	
        
         
        
        	
        
      
       
         
        | # | Customernumber | Customer orders | City | |
|---|---|---|---|---|
| 1 | 119 | Nantes | View Edit Remove | |
| 2 | 121 | Stavern | View Edit Remove | |
| 3 | 124 | San Rafael | View Edit Remove | |
| 4 | 125 | Warszawa | View Edit Remove | |
| 5 | 128 | Frankfurt | View Edit Remove | |
| 6 | 129 | San Francisco | View Edit Remove | |
| 7 | 131 | NYC | View Edit Remove | |
| 8 | 141 | Madrid | View Edit Remove | |
| 9 | 144 | Lula | View Edit Remove | |
| 10 | 145 | Kobenhavn | View Edit Remove | 
            
              
                    
                            
            
            ?>
            
        
        
       
        