+ 2
how to insert username and password in data base
2 Answers
+ 5
Connect your database with front end. Create HTML input fields and run a sql query to insert data into a database table.
+ 4
You need PHP and Mysql.
Below is the Php code that performs create new database data of username and email upon form submit.
<!DOCTYPE html>
<html lang="en">
<head><meta charset="UTF-8">
<title>Add Email Form</title>
</head>
<body>
<form method="post">
<p>
<label for="name">Username:</label>
<input type="text" name="name" id="name">
</p>
<p>
<label for="email">Email Address:</label>
<input type="text" name="email" id="email">
</p>
<input type="submit" value="Send">
</form>
</body>
</html>
<?php
if(!empty($_POST['name']) && !empty($_POST['email'])) {
$link = mysqli_connect("localhost", "root", "password", "demo"); // Check connection demo database
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
} // Escape user inputs for security
$name = mysqli_real_escape_string($link, $_POST['name']);
$email = mysqli_real_escape_string($link, $_POST['email']);
// attempt insert query execution
$sql = "INSERT INTO persons (name, email) VALUES ('$name', '$email')";
if(mysqli_query($link, $sql)){
echo "Records added successfully.";
}
else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// close connection
mysqli_close($link);
}
?>
https://code.sololearn.com/w8uC90WWcV3D/?ref=app
Often have questions like this?
Learn more efficiently, for free:
Hot today
Verify Phone Number
5 Votes
Multiple read one write
1 Votes
Anyone learning AI here ?
2 Votes
Curiosity
0 Votes
C LANGUAGE
1 Votes