Can someone help me with this? this has been my problem with php ever since I started learning the language. I cannot insert any data in my mysql, it doesn't show any error but it is also doesn't insert any data.
Here's my php:
<?php
include "db__con.php";
if(isset($_POST['submit'])){
$fname = $_POST['first_name'];
$lname = $_POST['last_name'];
$emai = $_POST['email'];
$gender = $_POST['gender'];
$sql = "INSERT INTO `crud`(`id`, `fname`, `lname`, `email`, `gender`) VALUES (NULL,'$fname','$lname','$emai','$gender')";
$result = mysqli_query($conn, $sql);
if($result){
header("Location: index.php?msg=New record created successfully");
}else{
echo "FAILED: " . mysqli_error($conn);
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Bootstrap demo</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-iYQeCzEYFbKjA/T2uDLTpkwGzCiq6soy8tYaI1GyVh/UjpbCx/TYkiZhlZB6+fzT" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.2.0/css/all.min.css" integrity="sha512-xh6O/CkQoPOWDdYTDqeRdPCVd1SpvCA9XXcUnZS2FmJNp1coAFzvtCN9BmamE+4aHK8yyUHUSCcJHgXloTyT2A==" crossorigin="anonymous" referrerpolicy="no-referrer" />
</head>
<body>
<nav class="navbar navbar-light justify-content-center fs-3 mb-5" style="background-color: #00ff5573">
SIMPLE CRUD
</nav>
<div class="container">
<div class="text-center mb-4">
<h3>Add new user</h3>
<p class="text-mute">Complete the form beloew to add a new user</p>
</div>
<div class="container d-flex justify-content-center">
<form action="" method="post" style="width:50vw; min-width:300px">
<div class="row">
<div class="col">
<label class="form-label">First name:</label>
<input type="text" class="form-control" name="first_name" placehoder="Clark">
</div>
<div class="col">
<label class="form-label">Last name:</label>
<input type="text" class="form-control" name="lname" placehoder="Labasan">
</div>
<div class="mb-3">
<label class="form-label">Email:</label>
<input type="text" class="form-control" name="email" placehoder="@asasdaskd.com">
</div>
<div class="formgroup mb-3">
<label> Gender:</label>
<input type="radio" class="form-check-input" name="gender" id="male" value="=male">
<label for="male" class="form-input-label">Male</label>
<input type="radio" class="form-check-input" name="gender" id="female" value="=female">
<label for="female" class="form-input-label">Female</label>
</div>
</div>
<div>
<button type="sumbit" class="btn btn-success" name="sumbit">Save</button>
<a href="index.php" class="btn btn-danger">Cancel</a>
</div>
</form>
</div>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.1/dist/js/bootstrap.bundle.min.js" integrity="sha384-u1OknCvxWvY5kfmNBILK2hRnQC3Pr17a+RTT6rIHI7NnikvbZlHgTPOOmMi466C8" crossorigin="anonymous"></script>
</body>
</html>
Here's my Database connection:
<?php
$sname = "localhost";
$uname = "root";
$password = "";
$dbname = "data_table";
$conn = new mysqli($sname,$uname,$password,$dbname);
if(!$conn){
die("Error: failed to connect to database");
}
?>