Skip to content
PHP Logo

What are best practices for configuring and accessing MySQL databases for PHP projects?

When configuring and accessing MySQL databases for PHP projects, it is important to securely store database credentials, use prepared statements to prevent SQL injection attacks, and properly handle errors to ensure data integrity and security.

php
<?php
// Database credentials
$servername = "localhost";
$username = "username";
$password = "password";
$database = "dbname";

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

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

// Example query using prepared statement
$stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result();

// Handle errors
if (!$result) {
    die("Error executing query: " . $conn->error);
}

// Process result
while ($row = $result->fetch_assoc()) {
    // Do something with the data
}

// Close connection
$conn->close();
?>