Screenshot of ERROR
this is my code I try to resolve this issue but not able to do, Kindly help me to do :
First one is database connection code ; which i connected with my file home.php
<?php
$db_host="localhost";
$db_user="root";
$db_pass="";
$db_name="connection";
//create connection
$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
// check connection
if( !$conn){
die("connection failed: ".mysqli_connect_error());
}
// checking submit button process or not
if (isset($_REQUEST['submit'])) {
//checking for empty fields
if (($_REQUEST['name']=="" || $_REQUEST['password']="")) {
echo "fill all the fields";
}
else{
//insert data invariable
$name = $_REQUEST['name'];
$mail = $_REQUEST['mail'];
$password = $_REQUEST['password'];
$sql = "INSERT INTO user (name, password, mail) VALUES ('$name', '$mail', '$password')";
//check data is inserted or not
if (mysqli_query($conn, $sql)) {
echo "data inserted";
}
else{
echo "data not inserted";
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>API</title>
<style>
form{
border: 2px skyblue solid;
width: auto;
text-align: center;
}
</style>
</head>
<body>
<h1>API Testing</h1>
<br><br>
<form action="POST" action="connection.php">
<h2>FORM</h2>
<input type="text" name="name" placeholder="enter your Name"><br><br>
<input type="text" name="mail" placeholder="enter your Email"><br><br>
<input type="password" name="password" placeholder="enter your Password"><br><br>
<input type="submit" value="submit" name="submit">
</form>
</body>
</html>
this is my code where i made a form and here connection is the file name of database connection of file with PHP
Khushal Sehrawat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3
Make sure the hostname, username, password, and database name are correctly configured.
Verify that your database server is running. Check if your MySQL server or other database server is up and running.
Check if your web server is running. If your web server is running on Port 80, make sure it is not conflicting with the database server.
Ensure that the necessary PHP extensions (e.g. mysql, mysqli, pdo) are enabled in your PHP configuration file (php.ini).
Check your firewall settings to ensure that Port 80 is open and accessible for database connections.
Restart your web server and database server to apply any changes you’ve made.
If the issue persists, try connecting to the database using a different client to see if the problem is with your PHP code or the database itself.
West is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.