PHP MySQLi Insert Data 🚀

Welcome to this comprehensive tutorial on PHP MySQLi Insert Data! In this lesson, we'll learn how to insert data into a MySQL database using PHP's MySQLi extension. Let's dive in!

What is MySQLi? 📝

MySQLi (MySQL Improved) is an extension for interacting with MySQL databases in PHP. It offers improved performance and additional features compared to the traditional MySQL extension.

Why Use MySQLi? 💡

Improved performance
Object-oriented and procedural interfaces
Support for prepared statements
Improved error handling

Preparing the Environment 🎯

Install a local web server (e.g., XAMPP, WAMP, or MAMP) that comes with PHP and MySQL.
Create a new database and a table to insert data. Let's create a simple "users" table:

sql

CREATE DATABASE my_database;
USE my_database;

CREATE TABLE users (
    id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    firstname VARCHAR(255) NOT NULL,
    lastname VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL UNIQUE,
    PRIMARY KEY (id)
);

Connecting to the Database 📝

Now let's connect to our database using PHP and MySQLi.

php

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "my_database";

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

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

Inserting Data 🎯

Here's a simple example of inserting a user into the "users" table.

php

// Prepare an SQL statement
$sql = $conn->prepare("INSERT INTO users (firstname, lastname, email) VALUES (?, ?, ?)");

// Bind parameters
$sql->bind_param("sss", $firstname, $lastname, $email);

// Set parameters
$firstname = "John";
$lastname = "Doe";
$email = "john.doe@example.com";

// Execute the SQL statement
$sql->execute();

// Close the statement
$sql->close();

Quiz 📝

Wrapping Up 🎯

Congratulations! You've now learned the basics of inserting data into a MySQL database using PHP's MySQLi extension. As you progress, you'll discover more about this powerful combination. Happy coding! 🚀💻

Stay tuned for more tutorials on CodeYourCraft! 📝🎯