Log In
0
Copy Link Report

Define MySQL? Write a program to create a login form having Username and Password and then connect it with database.

This question are relatited by fronted web. I want to this question for education of education. some one reply this question answer. I am waiting for your answer.

Web Development
3 days ago 11 1 Answer Follow
1 Answer
0
img
Puran Katuwal . 3 days ago
Copy Link Report

MySQL is an open-source Relational Database Management System that stores data in a structured format using rows and columns.

MYSQL language is easy to use as compared to other programming language like C, C++, Java, etc. By learning some basic commands we can work, create and interact with the Database.

Here's an example program in PHP that creates a login form with a username and password and connects it to a MySQL database.

1) HTML Form (login.html):

 <!DOCTYPE html>
<html>
<head>
<title>Login Form</title>
</head>
<body>
<h2>Login Form</h2>
<form action="login.php" method="POST">
<label for="username">Username:</label>
<input type="text" id="username" name="username" required><br><br>
<label for="password">Password:</label>
<input type="password" id="password" name="password" required><br><br>
<input type="submit" value="Login">
</form>
</body>
</htm>

2) PHP Code (login.php):

// Retrieve the submitted username and password $username = $_POST['username']; $password $ POST['password'];
// Connect to the MySQL database $servername = "localhost"; SpasswordDB = "your_mysql_password"; $dbName = "your_database_name";
ŞusernameDB = "your_mysql_username";
$conn = new mysqli($servername, $usernameDB, $passwordDB, $dbName);
// Check the database connection
if ($conn->connect_error)
die("Connection failed: Sconn xpr);
AC // Query the database to check if the username and password match $sql = "SELECT FROM users WHERE overname $username' AND password='$password";
$result = $conn->query($sql);
// Check if the query returned any rows if ($result->num_rows > 0) {
echo "Login successful!";
} else {
echo "Invalid username or password."; }
// Close the database connection
$conn->close(); 
?>

We use cookies to enhance your experience, to provide social media features and to analyse our traffic. By continuing to browse, you agree to our Privacy Policy.