PHP WITH MYSQL DATABASE CREATION - PHP LESSON 19 STUDENTSBLOG100

In the last lesson we have seen, How to connect php with Mysql?.Here you are going to study, how to create a database in MySql using php. The database creating query syntax is same as SQL query.

Syntax For Database Creation:

create database database_name;

Example in Php:

$sql = "create database DB_1"; // Here sql is variable name and DB_1 is database name

Example Program:

<?php $conn = mysqli_connect("localhost", "root", ""); //connection to Mysql Server if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "CREATE DATABASE DB_1"; // Creating Database named DB_1. if (mysqli_query($conn, $sql)) { echo "Database created successfully"; } else { echo "Error creating database: " . mysqli_error($conn); } mysqli_close($conn); ?>

---

Note : In MySql, we can create Database using front end tools too.. For that goto --> http://localhost/phpmyadmin/  --> Databases

---

Output: Goto --> http://localhost/phpmyadmin

PHP WITH MYSQL DATABASE CREATION

---

Lesson 18 ◄ Previous | Main Page | Next ► Lesson 20

---