PHP MySQLi: Create Database 🎯

Welcome to our comprehensive guide on creating a database using PHP MySQLi! This tutorial is designed for beginners and intermediates, so don't worry if you're new to these concepts. Let's dive in!

What is PHP MySQLi? 📝

PHP MySQLi is a PHP extension for connecting and working with MySQL databases. It provides improved performance and features compared to the older MySQL extension.

Why Use PHP MySQLi? 💡

Improved performance due to buffered queries.
Support for prepared statements which help prevent SQL injection attacks.
Object-oriented programming (OOP) support for easier handling of database resources.

Setting Up Your Environment 📝

Before we start, ensure you have:

A local web server installed (e.g., XAMPP, WAMP, MAMP)
PHP installed and configured correctly
MySQL Server installed and running

Connecting to MySQL Database 🎯

php

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully!";
?>

Creating a Database 🎯

In PHP, we don't create databases directly. Instead, we create a new database using the MySQL command line or phpMyAdmin. Let's create a database named myDB.

MySQL Command Line

sql

CREATE DATABASE myDB;

phpMyAdmin

Log in to phpMyAdmin.
Click on the "Databases" tab.
Enter myDB as the new database name and click "Create Database".

Quiz 🎯

That's it for creating a database using PHP MySQLi! In the next lesson, we'll learn how to create tables and perform CRUD operations. Stay tuned! 🚀