Odtnhj

So my database does not add this data into the database when the button is pressed.
I have created a form, and all the id's are perfect and the email is a foreign key so it is taken from sessionStorage of the logged in user. I need help with why it is not working, I have no idea. The page alerts me "the order was successful" when I press submit but the data does not get stored in the database.
My SQL statement also works definitely, I tried it in my database.
Here are my php and js:

<?php
header("Content-Type: application/json; charset=UTF-8");
 $servername = "localhost";
 $username = "root";
 $password = "leaf123";
 $dbname = "laxmi";

 // Create Connection

 $conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection

if (!$conn)

die("Connection failed:" . mysqli_connect_error());

else


// Obtain the contents

$request = file_get_contents('php://input');

// decode json so PHP can use it

$jsonRequest = json_decode($request);

// Query
$sql = "INSERT INTO checkout(email, ccName, ccNumber, month, year, cvc) VALUES ('$jsonRequest->email', '$jsonRequest->ccName', '$jsonRequest->ccNumber', '$jsonRequest->month', '$jsonRequest->year', '$jsonRequest->cvc')"






// Execute Query

$results = mysqli_query($conn, $sql);
echo json_encode("success");
mysqli_close($conn);

my javascript

$(document).ready(function () 
//When the submit button on the checkout form is pressed.
$("#SubmitOrder").on("click", function () 
 //store each individual entry into a separate variable.
 var email = sessionStorage.getItem("loggedInUser");
 var ccname = document.getElementById("ccName").value;
 var ccnum = document.getElementById("ccNumber").value;
 var month = document.getElementById("month").value;
 var year = document.getElementById("year").value;
 var cvc = document.getElementById("cvc").value;


 //create an array with the details in.
 var checkout = 
 email: email,
 ccname: ccname,
 ccnum: ccnum,
 month: month,
 cvc: cvc,
 
 //direct the user to the login page and alert them that their registration was successful.
 alert("Your order was successful.")
 window.location.href = "../index.html" 
 //posts the JSON object to the php file so it can fill the database, and converts the checkout array into JSON so it can be read. 
 var jqxhr = $.post("../php/checkoutOrder.php", JSON.stringify(checkout))
)

)

First off, you're displaying the success message before even trying to send the post request to your PHP file. So your first job is to re-order things

var jqxhr = $.post("../php/checkoutOrder.php", JSON.stringify(checkout));
alert("Your order was successful.");
window.location.href = "../index.html";

Secondly, you're currently not checking for a response from the server as to whether the request was successful or not. I've modified the example from the jQuery docs https://api.jquery.com/jquery.post/

var jqxhr = $.post("../php/checkoutOrder.php", JSON.stringify(checkout))
 .done(function() 
 alert("Your order was successful.");
 window.location.href = "../index.html";
 )
 .fail(function() 
 alert( "error" );
 )
 .always(function() 
 alert( "finished" );
 );

Once you're done with that, you'll want to look into returning a response from PHP to say whether the query worked etc, but the above is at least enough to get you something that works for now :)