04-05-2021, 07:12 AM
(This post was last modified: 04-05-2021, 07:14 AM by pippuccio76.)
hi sorry for english , there is a way to get db name ?
i have this code to get db table :
Can i get the name to use in this method ? i know that db name are in .env but i want create a tool and i must get it
i have this code to get db table :
Code:
$db = \Config\Database::connect();
$tableList = array();
$query = $db->query("SHOW TABLES");
$results = $query->getResult();
foreach ($results as $row)
{
$tableList[] =$row->Tables_in_name_of_db;
}
$data['tableList']= $tableList;
Can i get the name to use in this method ? i know that db name are in .env but i want create a tool and i must get it