What is Php Mysql Database How php connect to database

Question

Want to know PHP + MySQL Database System  connection in web page?

Answer 1

Hello kartik,

MySQL is the most popular database system used with PHP.

What is MySQL?

• MySQL is a database system used on the web
• MySQL is a database system that runs on a server
• MySQL is ideal for both small and large applications
• MySQL is very fast, reliable, and easy to use
• MySQL uses standard SQL
• MySQL compiles on a number of platforms
• MySQL is free to download and use
• MySQL is developed, distributed, and supported by Oracle Corporation.

Open a Connection to MySQL

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = mysqli_connect($servername, $username, $password);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>

NOTE:The connection will be closed automatically when the script ends. To close the connection before, use the following:

$conn->close();