A database consists of one or more tables.
You will need special CREATE privileges to create or to delete a MySQL database.
Create a MySQL Database Using MySQLi and PDO
The CREATE DATABASE statement is used to create a database in MySQL.
The following examples create a database named "myDB":
Example [MySQLi Object-oriented]
Note: When you create a new database, you must only specify the first three arguments to the mysqli object [servername, username and password].
Tip: If you have to use a specific port, add an empty string for the database-name argument, like this: new mysqli["localhost", "username", "password", "", port]
Example [MySQLi Procedural]
Note: The following PDO example create a database named "myDBPDO":
Example [PDO]
Tip: A great benefit of PDO is that it has exception class to handle any problems that may occur in our database queries. If an exception is thrown within the try{ } block, the script stops executing and flows directly to the first catch[]{ } block. In the catch block above we echo the SQL statement and the generated error message.
View Discussion
Improve Article
Save Article
View Discussion
Improve Article
Save Article
What is a
database?
Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes the data in the form of tables, views, schemas, reports etc. For Example, university database organizes the data about students, faculty, and admin staff etc. which helps in efficient retrieval, insertion and deletion of data
from it.
We know that in MySQL to create a database we need to execute a query. You may refer to this article for the SQL query to create data-bases.
The basic steps to create MySQL database using PHP are:
- Establish a connection to MySQL server from your PHP script as described in this article.
- If the connection is successful, write a SQL query to create a database and store it in a string variable.
- Execute the query.
We have already learnt about establish a connection and creating variables in PHP. We can execute the query from our PHP script in 3 different ways as described below:
- Using MySQLi Object-oriented procedure: If the MySQL connection is established using Object-oriented procedure then we can use the query[] function of mysqli class
to execute our query as described in the below syntax.
Syntax:
Note:Specify the three arguments servername, username and password to the mysqli object whenever creating a database.
Output:
- Using MySQLi Procedural procedure: If the MySQL connection is
established using procedural procedure then we can use the mysqli_query[] function of PHP to execute our query as described in the below syntax.
Syntax:
Output:
- Using PDO procedure: If the MySQL connection is established using PDO procedure then we can execute our query as
described in the below syntax.
Syntax:
Note:The exception class in PDO is used to handle any problems that may occur in our database queries. If an exception is thrown within the try{ } block, the script stops executing and flows directly to the first catch[]{ } block.
Output: