What is the correct way to hash passwords in PHP using MD5 and store them in a MySQL database?

When storing passwords in a database, it is important to hash them for security purposes. In PHP, you can use the MD5 hashing algorithm to securely hash passwords before storing them in a MySQL database. To do this, you can use the md5() function in PHP to hash the password before inserting it into the database.

<?php
// Get the password from the user input
$password = $_POST['password'];

// Hash the password using MD5
$hashed_password = md5($password);

// Connect to the MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Insert the hashed password into the users table
$query = "INSERT INTO users (password) VALUES ('$hashed_password')";
mysqli_query($connection, $query);

// Close the database connection
mysqli_close($connection);
?>