I cant get the data from my jquery to php file. I have tried multiple solutions, i dont get any errors but the data is not showing up on my database. This is the first time using ajax. I need an external php submit code, becouse if i include the php code on my index.php the values are remembered and they get submited when I refresh the page. Thanks in advance.
This is my html
<form class="form-inline" method="post" >
<div id="div_id_value" class="form-group">
<input class="numberinput form-control"
id="value" name="value"
placeholder="Value (mmol/L)"
required="True" type="number" step="any" min="0"/>
</div>
<div id="div_id_category" class="form-group">
<select id="id_category" name="category">
<option value="Breakfast">Breakfast</option>
<option value="Lunch" >Lunch</option>
<option value="Dinner">Dinner</option>
<option value="Snack">Snack</option>
<option value="Bedtime">Bedtime</option>
<option value="No Category" selected="selected">No Category</option>
</select>
</div>
<input type="submit" name="submit" value="Quick Add" id="quick">
</form>
This is my jquery
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js">
$("#quick").click(function() {
var sugar2 = $("#value").val();
var category2 = $("#category").val();
$.ajax({
type:'POST',
url:'quick.php',
data:{ 'sugar': sugar2, 'category':category2},
dataType:'json',
success: function(output) {
alert(output);
};
});
});
and this is my php
<?php
session_start();
include 'conn.php';
if (isset($_POST['sugar'])) {
$sugar = $_POST['sugar'];
$category = $_POST['category'];
$email= $_SESSION['email'];
$query = "INSERT INTO data (email, sugar, category)
VALUES($email, $sugar, $category )";
if(mysqli_query($link, $query)) {
header("Location: index.php");
};
};
?>