Category: PHP MySQL Tutorial

PHP MySQL Database

PHP MySQL Database Using PHP with MySQL allows you to store, retrieve, update, and delete data from a database—this is the backbone of dynamic websites and web applications. We’ll cover everything step by step,...

PHP MySQL Tutorial

PHP Connect to MySQL

PHP Connect to MySQL Tutorial PHP Connect to MySQL database is the first step for any dynamic web application. You can use mysqli (procedural or object-oriented) or PDO. Using mysqli (Procedural)

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

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

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

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "test_db";

// Create connection

$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

echo "Connected successfully";

$servername...

PHP MySQL Tutorial

PHP Create a MySQL Database

PHP Create a MySQL Database Tutorial PHP can be used to create a MySQL database dynamically using the mysqli or PDO extension. This is useful when setting up applications programmatically. Using mysqli (Procedural)

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

// Create connection
$conn = mysqli_connect($servername, $username, $password);

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

// Create database
$sql = "CREATE DATABASE test_db";
if (mysqli_query($conn, $sql)) {
echo "Database created successfully";
} else {
echo "Error creating database: " . mysqli_error($conn);
}

// Close connection
mysqli_close($conn);
?>

<?php

$servername = "localhost";

$username = "root";

$password = "";

// Create connection

$conn = mysqli_connect($servername, $username, $password);

// Check connection

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

// Create database

$sql = "CREATE DATABASE test_db";

if (mysqli_query($conn, $sql)) {

echo "Database created successfully";

} else {

echo "Error creating database: " . mysqli_error($conn);

}

// Close connection

mysqli_close($conn);

...

PHP MySQL Tutorial

PHP MySQL Create Table

PHP MySQL Create Table Tutorial After creating a database, PHP MySQL Create Table to store your data. PHP can execute SQL CREATE TABLE statements using mysqli or PDO. Using mysqli (Procedural)

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

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

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

// SQL to create table
$sql = "CREATE TABLE users (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL UNIQUE,
age INT(3),
reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

// Execute query
if (mysqli_query($conn, $sql)) {
echo "Table 'users' created successfully";
} else {
echo "Error creating table: " . mysqli_error($conn);
}

// Close connection
mysqli_close($conn);
?>

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "test_db";

// Create connection

$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

// SQL to create table

$sql = "CREATE TABLE users (

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

email VARCHAR(50) NOT NULL UNIQUE,

age INT(3),

reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP

)";

// Execute query

if (mysqli_query($conn, $sql)) {

echo "Table 'users' created successfully";

} else {

echo "Error creating table: " . mysqli_error($conn);

}

// Close connection

mysqli_close($conn);

Explanation: id...

PHP MySQL Tutorial

PHP MySQL Insert Data

PHP MySQL Insert Data Below is a clear, step-by-step guide to PHP MySQL Insert Data, with real examples, security best practices, and error handling. Database & Table Example Assume you have this MySQL table:...

PHP MySQL Tutorial

PHP MySQL Get Last Inserted ID

PHP MySQL Get Last Inserted ID In PHP MySQL Get Last Inserted ID in table with an AUTO_INCREMENT primary key, you may want to get the ID of the newly inserted record. PHP provides...

PHP MySQL Tutorial

PHP MySQL Insert Multiple Records

PHP MySQL Insert Multiple Records Sometimes, you need using PHP MySQL Insert Multiple Records into a table in a single query. PHP supports this using mysqli or PDO. Using mysqli (Procedural)

<?php
$conn = mysqli_connect("localhost", "root", "", "test_db");

if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

// Insert multiple records
$sql = "INSERT INTO users (name, email, age) VALUES
('Vipul', 'vipul@example.com', 25),
('Amit', 'amit@example.com', 28),
('Ravi', 'ravi@example.com', 30)";

if (mysqli_query($conn, $sql)) {
echo "New records inserted successfully. Last inserted ID is: " . mysqli_insert_id($conn);
} else {
echo "Error: " . mysqli_error($conn);
}

mysqli_close($conn);
?>

<?php

$conn = mysqli_connect("localhost", "root", "", "test_db");

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

// Insert multiple records

$sql = "INSERT INTO users (name, email, age) VALUES

('Vipul', 'vipul@example.com', 25),

('Amit', 'amit@example.com', 28),

('Ravi', 'ravi@example.com', 30)";

if (mysqli_query($conn, $sql)) {

echo "New records inserted successfully. Last inserted ID is: " . mysqli_insert_id($conn);

} else {

echo "Error: " . mysqli_error($conn);

}

mysqli_close($conn);

Single...

PHP MySQL Tutorial

PHP MySQL Prepared Statements

PHP MySQL Prepared Statements Tutorial In PHP MySQL Prepared Statements provide a secure way to execute SQL queries by separating SQL logic from data. They prevent SQL injection and improve efficiency when executing similar...

PHP MySQL Tutorial

PHP MySQL Select Data

PHP MySQL Select Data Tutorial In PHP MySQL Select Data allows you to retrieve and display records in your PHP applications. You can use mysqli or PDO for this purpose. Using mysqli (Procedural)

<?php
$conn = mysqli_connect("localhost", "root", "", "test_db");

if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

// Select data
$sql = "SELECT id, name, email, age FROM users";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
echo "ID: " . $row["id"] .
" - Name: " . $row["name"] .
" - Email: " . $row["email"] .
" - Age: " . $row["age"] . "<br>";
}
} else {
echo "0 results";
}

mysqli_close($conn);
?>

<?php

$conn = mysqli_connect("localhost", "root", "", "test_db");

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

// Select data

$sql = "SELECT id, name, email, age FROM users";

$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {

while($row = mysqli_fetch_assoc($result)) {

echo "ID: " . $row["id"] .

" - Name: " . $row["name"] .

" - Email: " . $row["email"] .

" - Age: " . $row["age"] . "<br>";

}

} else {

echo "0 results";

}

mysqli_close($conn);

...

PHP MySQL Tutorial

PHP MySQL Using the WHERE Clause

PHP MySQL Using the WHERE Clause In PHP MySQL Using the WHERE Clause allows you to filter records based on a condition. In PHP, you can use it with SELECT, UPDATE, DELETE, and other...