How To Connect My Php Program With Database

How To Connect My Php Program With Database

A beginner's guide to connecting PHP with MySQL using MySQLi and PDO.

Here’s a beginner-friendly content draft for "How to Connect My PHP Program with a Database" — perfect for a blog or article post.

🛠️ How To Connect My PHP Program With a Database

Connecting a PHP program to a database is an essential skill for web developers. Whether you're building a login system, a CMS, or a custom web app, database connectivity allows your application to store and retrieve data efficiently.

In this guide, we'll walk through the steps to connect PHP with a MySQL database using both MySQLi and PDO methods.

🧱 Prerequisites

Before starting, make sure you have the following:

PHP installed (v7.x or later)

MySQL or MariaDB server running

A database and user created

A code editor like VS Code or Sublime Text

📁 Step 1: Create a Database

Use phpMyAdmin or the MySQL CLI:

CREATE DATABASE my_database;

Also, create a user (optional):

CREATE USER 'my_user'@'localhost' IDENTIFIED BY 'my_password'; GRANT ALL PRIVILEGES ON my_database.* TO 'my_user'@'localhost';

🔌 Step 2: Connect Using MySQLi (Object-Oriented)

<?php $servername = "localhost"; $username = "my_user"; $password = "my_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); } echo "Connected successfully"; ?>

🔐 Step 3: Connect Using PDO (More Secure & Flexible)

<?php $host = 'localhost'; $db   = 'my_database'; $user = 'my_user'; $pass = 'my_password'; $charset = 'utf8mb4'; $dsn = "mysql:host=$host;dbname=$db;charset=$charset"; $options = [    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ]; try {    $pdo = new PDO($dsn, $user, $pass, $options);    echo "Connected successfully"; } catch (\PDOException $e) {    throw new \PDOException($e->getMessage(), (int)$e->getCode()); } ?>

💡 When to Use MySQLi vs PDO?

Recommendation: Use PDO for new projects due to flexibility and security.

✅ Final Tips

Always use prepared statements to avoid SQL injection.

Store database credentials in a separate config file for security.

Use .env or similar for storing credentials in production.

📌 Conclusion

Connecting PHP to a database is your first step toward dynamic web applications. Whether you choose MySQLi for simplicity or PDO for flexibility, ensure your connection is secure and efficient.

Happy coding! 💻

Let me know if you want this in a PDF, blog HTML format, or tailored for a specific platform (like WordPress or Laravel).