// end while
             // we did not find the foreign field in the tables of current db,
             // must be defined in another db so show it to avoid erasing it
             if (!$found_foreign_field && $foreign_field) {
                 echo '                ' . '<option value="' . htmlspecialchars($foreign_field) . '"';
                 echo ' selected="selected"';
                 echo '>' . $foreign_field . '</option>' . "\n";
             }
             ?>
         </select>
         </span>
         <span class="formelement">
             <?php 
             PMA_generate_dropdown('ON DELETE', 'on_delete[' . $myfield_md5 . ']', $options_array, isset($existrel_foreign[$myfield]['on_delete']) ? $existrel_foreign[$myfield]['on_delete'] : '');
             echo '</span>' . "\n" . '<span class="formelement">' . "\n";
             PMA_generate_dropdown('ON UPDATE', 'on_update[' . $myfield_md5 . ']', $options_array, isset($existrel_foreign[$myfield]['on_update']) ? $existrel_foreign[$myfield]['on_update'] : '');
             echo '</span>' . "\n";
         } else {
             echo $strNoIndex;
         }
         // end if (a key exists)
         echo '        </td>';
     }
     // end if (InnoDB)
     ?>
 </tr>
     <?php 
 }
 // end for
 unset($myfield, $myfield_md5, $myfield_html);
 echo '    </table>' . "\n";
Example #2
0
             // end while
             // we did not find the foreign field in the tables of current db,
             // must be defined in another db so show it to avoid erasing it
             if (!$found_foreign_field && $foreign_field) {
                 echo '                ' . '<option value="' . htmlspecialchars($foreign_field) . '"';
                 echo ' selected="selected"';
                 echo '>' . $foreign_field . '</option>' . "\n";
             }
             ?>
         </select>
         </span>
         <span class="formelement">
             <?php 
             PMA_generate_dropdown('ON DELETE', 'on_delete[' . htmlspecialchars($save_row[$i]['Field']) . ']', $options_array, isset($existrel_innodb[$myfield]['on_delete']) ? $existrel_innodb[$myfield]['on_delete'] : '');
             echo '</span>' . "\n" . '<span class="formelement">' . "\n";
             PMA_generate_dropdown('ON UPDATE', 'on_update[' . htmlspecialchars($save_row[$i]['Field']) . ']', $options_array, isset($existrel_innodb[$myfield]['on_update']) ? $existrel_innodb[$myfield]['on_update'] : '');
             echo '</span>' . "\n";
         } else {
             echo $strNoIndex;
         }
         // end if (a key exists)
         echo '        </td>';
     }
     // end if (InnoDB)
     ?>
 </tr>
     <?php 
 }
 // end for
 echo '    </table>' . "\n";
 echo '</fieldset>' . "\n";