Today sharing blog have new topic to share. It is basic example to use ajax with php in order to insert data to database. Here is following code in order to insert data to database:
HTML Code:
<!DOCTYPE html>
<head>
<title>
</title>
</head>
<body>
Mydata1:<input type="text" id="data1">
Mydata2:<input type="text" id="data2">
<input type="button" value="Submit" onclick="get_data()">
</body>
</html>
JavaScript Code:
<script>
function get_data{
var data1 = document.getElementById("date1").value;
var data2 = document.getElementById("date2").value;
var base_url= "<?php echo base_url()?>";
$.ajax({
type: "POST",
url:base_url+"folder/insert.php",
data: {data1: data1,data2:data2},
success: function(data){
alert("success");
}
});
}
</script>
PHP Code:
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$data1 = $_POST['data1'];
$data2 = $_POST['data2'];
$sql = "INSERT INTO Mytable (data1, data2)
VALUES ($data1,$data2)";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>
We hope that all code above can help and make your work run smoothly :)
