How can get all database name using Php and Sql?
- 1 Answers
- 2277 Views
- NIIT, I also Faced
- E-Mail Answers
Answer / Vipul Negi
Answer: To get all the database names using PHP and MySQL, you can use the following code:nn```phpn$connection = new mysqli('localhost', 'username', 'password', 'database_name');nif ($connection->connect_error) {n die("Connection failed: " . $connection->connect_error);n}n$result = $connection->query('SHOW DATABASES');nwhile($row = $result->fetch_assoc()) {n echo $row['Database'] . "n";n}n$connection->close();n```
| Is This Answer Correct ? | 0 Yes | 0 No |
What is main difference between Cookie and Cache?
Hi I have a dynamic dropdown reading in data from a MQSql database, I need to refresh just the dropdown (not the whole page) for any new values in the database. I am trying to use the getElementById in javascript but I have no idea how to get it to refresh. Does any one have an examples or any ideas how this can be done? Regards Srilanka_3
Given a string=”me,I,myself”; .Using javascript only create an array out of this string and then send a POST request to the url “record.php” without reloading the page. The post key parameters should be n1,n2 and n3 respectively.
What is difference between ksort and krsort in php?
How to Connect and Insert Record to MYSQL using PHP?
what is main difference between array_push and array_pop?
How can manage theme in php?
How can export database using php code?
How can import database to mysql using php code?
I have array like $array = array(1, "hello", 1, "world", "hello"); if i want the following output then how can i do this? Array ( [1] => 2 [hello] => 2 [world] => 1 )
Is there any way to open notepad within php?
I am attempting to work on a game panel with multi-server support, so in one of the pages there is a dropdown menu with servers on it, this is the part i am having issues with is server 1 is chosen i need access to the username running a script to server 1 chosen i need a script that will realize its been chosen and pop up below with a username thats associated with it because the users differ on each server so i choose server 1 i need a code to pull from the db and choose the user associated with the said server please help..
PHP Code 
