Listing Databases in Select list in MATE
$sql3 = " SHOW DATABASES ";
$result3 = $conn->query($sql3);
while($row3 = $result3->fetch_assoc())
{
$db_list[] = $row3["Database"];
}
$db_list_final = array_combine($db_list, $db_list);
$tableColumns['db_name'] = array(
'display_text' => 'DB Name',
'perms' => 'ACFHOQSTVX',
'req' => true,
'select_array' => $db_list_final
);
Comments