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
<code><?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";
}
}
}
?>
</code>
<code><?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";
}
}
}
?>
</code>
<?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";
}
}
}
?>
<code><!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>
</code>
<code><!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>
</code>
<!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
New contributor
Khushal Sehrawat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.