MySQL Database in PHP

 MySQL Database in PHP

PHP can be used to interact with a MySQL database. MySQL functions are used to connect to the database, execute queries, and fetch results.

Example:

php

// connect to database

$servername = "localhost";

$username = "username";

$password = "password";

$dbname = "myDB";

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

// execute query

$sql = "SELECT * FROM customers";

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

// fetch results

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

    echo "Name: " . $row["name"] . " - Email: " . $row["email"];

}