Module 5
Database Integration & Prepared Statements
30 mins read
Lesson 1: Databases & MySQLi
1.1 Establishing Database Connection
Connecting to MySQL server using mysqli object-oriented API in `userconnection.php`.
PHP
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mastercode_";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>