Connecting PHP with MySQL is a foundational task in web development. Below, I'll outline the key aspects of PHP-MySQL connectivity and provide a simple example.
Before starting, you should have:
MySQLi (MySQL Improved) is a database access extension in PHP. It can be used in an object-oriented manner or a procedural manner.
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$database = "mydb";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
mysqli_close($conn);
?>
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$database = "mydb";
// Create connection
$conn = new mysqli($servername, $username, $password, $database);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
$conn->close();
?>
PDO provides a data-access abstraction layer. It allows for connecting to multiple database types, not just MySQL.
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$database = "mydb";
try {
$conn = new PDO("mysql:host=$servername;dbname=$database", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully";
}
catch(PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
$conn = null;
?>
For MySQLi (OO approach): `$conn->close();` For MySQLi (Procedural approach): `mysqli_close($conn);` For PDO: `$conn = null;`
Selecting Data:
$sql = "SELECT id, name FROM users";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "id: " . $row["id"]. " - Name: " . $row["name"]. "<br>";
}
} else {
echo "0 results";
}
Selecting Data:
$query = "SELECT id, name FROM users";
$stmt = $conn->query($query);
while ($row = $stmt->fetch()) {
echo "id: " . $row["id"]. " - Name: " . $row["name"]. "<br>";
}
Both MySQLi and PDO support prepared statements which protect against SQL injection. For example, with PDO:
$stmt = $conn->prepare("INSERT INTO users (name, email) VALUES (:name, :email)");
$stmt->bindParam(':name', $name);
$stmt->bindParam(':email', $email);
// Insert a row
$name = "John";
$email = "john@example.com";
$stmt->execute();
UPCET Exam
Click Here
SAAT Exam
Click Here
MHT CET Exam
Click Here
IPU CET Exam
Click Here
KCET Exam
Click Here
COMEDK UG Exam
Click Here
VITEEE Exam
Click Here
BITSAT
Click Here
DSAT: Dayanand Sagar Admission Test
Click Here
Career In Animation in india
Click Here
Merchant Navy Courses in india
Click Here
Interior Design Career in india
Click Here
UGC NET Exam
Click Here
B. Ed Exam
Click Here
AFCAT - Air Force Common Admission Test
Click Here
GATE Exam
Click Here
Joint Entrance Examination (JEE)
Click Here
Common Admission Test (CAT)
Click Here
CDS - Combined Defence Services Exam
Click Here