For create database in MySql the CREATE DATABASE statement is used.
The following example is about how to create a database in mysql without open the phpmyadmin or mysql.
<?php
$servername = "localhost";
$username = "root";
$password = "password";/* Put your password here */
/* Create connection */
$conn = new mysqli($servername, $username, $password);
/* Check connection */
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
/* Create database */
$sql = "CREATE DATABASE admin";
if ($conn->query($sql) === TRUE) {
echo "Database admin created successfully";
}
else
{
echo "Error creating database: " . $conn->error;
}
$conn->close();
?>
<?php
$servername = "localhost";
$username = "root";
$password = "password";/* Put your password here*/
/* Create connection*/
$conn = mysqli_connect($servername, $username, $password);
/* Check connection*/
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
/* Create database*/
$sql = "CREATE DATABASE admin";
if (mysqli_query($conn, $sql)) {
echo "Database admin created successfully";
}
else
{
echo "Error creating database: " . mysqli_error($conn);
}
mysqli_close($conn);
?>
