verify_code.php

<?php
session_start();
$con=mysqli_connect("localhost","root","","pin_verification_original") or die(mysqli_error($con));
$pin_id=$_SESSION['pin_sess'];
$code=$_POST['code'];
$amount=$_POST['amount'];
$auth_query="select email_pin,pin_id from pin where email_pin='$code' and pin_id='$pin_id'";
$auth_result=mysqli_query($con,$auth_query) or die(mysqli_error($con));
$rows_fetched=mysqli_num_rows($auth_result);
if($rows_fetched>0){ 
$update_query=$con->query("UPDATE pin SET verified='1' WHERE pin_id='$pin_id'"); 
$pin_query="insert into transactions (pin_id,amount) values ('$pin_id','$amount')";
$query_result=mysqli_query($con,$pin_query) or die(mysqli_error($con));
echo '<script>window.alert("TRANSACTION COMPLETE!");</script>';
echo("<script>location.href = 'index.php';</script>");}else{
   echo '<script>window.alert("Wrong Code");</script>';
   echo("<script>location.href = 'logout.php';</script>"); 
}

?>