PHP/MySQL Create/Display databases

[GUIR]

Hi! all

Can someone pls let me know the following.

Is it possible to create new databases in MySQL using PHP.

Is it possible to list all databases in MySQL using either PHP or SQL.

Thanks and BR.

[AdamGundry]

Yes, you can use CREATE DATABASE (http://dev.mysql.com/doc/mysql/en/create-database.html) and SHOW DATABASES (http://dev.mysql.com/doc/mysql/en/show-databases.html) queries. However, you might be better off getting a MySQL administration tool such as phpMyAdmin (http://www.phpmyadmin.net/).

Adam

[gebezis]

if you have the privileges to create the databases the followig should work:

$query = 'create database dbname';
mysql_query($query);

[GUIR]

HI!

Thanks for your support....

Best Regards