this is my index page
<!DOCTYPE html>
<html>
<head>
<title>insert</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
</head>
<body>
<form id="image_form" method="post" enctype="multipart/form-data">
<p><label>Select Image</label>
<input type="file" name="image" id="image" /></p><br />
<input type="hidden" name="action" id="action" value="insert" />
<input type="hidden" name="image_id" id="image_id" />
<input type="text" name="info" id="info" />
<input type="submit" name="insert" id="insert" value="Insert" class="btn btn-info" />
</form>
</body>
</html>
<script>
$(document).ready(function(){
$('#image_form').submit(function(event){
event.preventDefault();
var image_name = $('#image').val();
if(image_name == '')
{
alert("Please Select Image");
return false;
}
else
{
var extension = $('#image').val().split('.').pop().toLowerCase();
if(jQuery.inArray(extension, ['gif','png','jpg','jpeg']) == -1)
{
alert("Invalid Image File");
$('#image').val('');
return false;
}
else
{
$.ajax({
url:"insert_action.php",
method:"POST",
data:new FormData(this),
contentType:false,
processData:false,
success:function(data)
{
alert(data);
$('#image_form')[0].reset();
}
});
}
}
});
});
</script>
this is my action page
<?php
//action.php
if(isset($_POST["action"]))
{
$connect = mysqli_connect("localhost", "root", "", "testing");
//INSERT DATA
if($_POST["action"] == "insert")
{
$file = addslashes(file_get_contents($_FILES["image"]["tmp_name"]));
$info = $_POST["info"];
$query = "INSERT INTO tbl_images(name),info VALUES ('$file','$info')";
if(mysqli_query($connect, $query))
{
echo 'Image Inserted into Database';
}
}
}
?>
but info data is not stored in data base