<?php
define('DB_SERVER','localhost');
define('DB_USER','root');
define('DB_PASS' ,'');
define('DB_NAME', 'insertdb');
$con = mysqli_connect(DB_SERVER,DB_USER,DB_PASS,DB_NAME);
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>
index.php
<?php
include_once("config.php");
if(isset($_POST['submit']))
{
$name=$_POST['name'];
$email=$_POST['email'];
$contactno=$_POST['contactno'];
$gender=$_POST['gender'];
$education=$_POST['education'];
$adress=$_POST['addrss'];
$query=mysqli_query($con,"insert into data(name,email,contactno,gender,education,address) values('$name','$email','$contactno','$gender','$education','$adress')");
if($query)
{
echo "<script>alert('Data inserted successfully');</script>";
}
else
{
echo "<script>alert('Data not inserted');</script>";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta charset="utf-8">
<title> How to Insert Data into MySql Using PHP</title>
<meta name="generator" content="Bootply" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<!--Bootstrap -->
<link rel="stylesheet" href="css/bootstrap.css" type="text/css">
<link rel="stylesheet" href="css/bootstrap.min.css" type="text/css">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-12">
<h3>How to Insert Data into MySql Using PHP </h3>
<form class="forms-sample" method="post" enctype="multipart/form-data" class="form-horizontal">
<div class="row ">
<div class="form-group col-md-6">
<label>Name</label>
<input type="text" name="name" id="name" value="" class="form-control" required />
</div>
</div>
<div class="row ">
<div class="form-group col-md-6">
<label >Email id</label>
<input type="email" name="email" id="email" value="" class="form-control" required />
</div>
</div>
<div class="row ">
<div class="form-group col-md-6">
<label >Contact No</label>
<input type="text" name="contactno" id="contactno" value="" class="form-control" maxlength="10" required />
</div>
</div>
<<div class="row ">
<div class="form-group col-md-6">
<label>Gender</label>
<input type="radio" name="gender" value="Male" checked >Male <input type="radio" name="gender" value="Female" >female
</div>
</div>
<div class="row ">
<div class="form-group col-md-6 ">
<label >Education</label>
<select name="education" id="email" class="form-control" required >
<option value="">Select your Education</option>
<option value="Post Graduate">Post Graduate</option>
<option value="Graduate">Graduate</option>
<option value="Intermediate">Intermediate</option>
<option value="High School">High School</option>
<option value="Other">Other</option>
</select>
</div>
</div>
<div class="row ">
<div class="form-group col-md-6">
<label >Address</label>
<textarea name="addrss" class="form-control" required></textarea>
</div>
</div>
<button type="submit" name="submit" value="Submit" class="btn btn-primary mr-2 mb-4">Save</button>
</form>
</div>
</div>
</div>
<!-- Loading Scripts -->
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>
Download
