reenadak

Listing Databases in Select list in MATE

Sep 25th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. $sql3 = " SHOW DATABASES ";
  2. $result3 = $conn->query($sql3);
  3.  
  4. while($row3 = $result3->fetch_assoc())
  5. {
  6. $db_list[] = $row3["Database"];
  7. }
  8.  
  9. $db_list_final = array_combine($db_list, $db_list);
  10.  
  11.  
  12. $tableColumns['db_name'] = array(
  13. 'display_text' => 'DB Name',
  14. 'perms' => 'ACFHOQSTVX',
  15. 'req' => true,
  16. 'select_array' => $db_list_final
  17. );
Add Comment
Please, Sign In to add comment