recharge.php

<?php
session_start();
include 'dbms_server_conn.php';
$m_no=$_SESSION['user'];
$amt=$_GET["amount"];
$pwd=$_GET["password"];
$querry= "SELECT * FROM hashcash.user WHERE mobilenumber='$m_no' AND password='$pwd'";
$result = mysqli_query($con,$querry);

if(!$result)
{
	#echo "Transaction Failed";
	echo ("<script LANGUAGE='JavaScript'>
    window.alert('Transaction Failed');
    </script>");
    mysqli_close($con);
}
else
{
    $row = mysqli_fetch_array($result, MYSQLI_ASSOC);
    $amt2=$row["balance"]+$amt;
    $querry2= "UPDATE hashcash.user SET balance=$amt2 where mobilenumber=$m_no";
    $result2 = mysqli_query($con,$querry2);
    $querry7= "INSERT INTO hashcash.trdetails (mobilenumber,currentbalance) VALUES ('$m_no','$amt2')";
    $result7 = mysqli_query($con,$querry7);
    if(!$result2)
    {   
        #echo "Transaction Failed";
		echo ("<script LANGUAGE='JavaScript'>
    window.alert('Transaction Failed');
    </script>");
        mysqli_close($con);
    }
    else
    {
        #echo "\n";
		echo ("<script LANGUAGE='JavaScript'>
    window.alert('Validating Card :)');
    </script>");
        
    }
}


require 'vendor/autoload.php';

$params = array(
    'credentials' => array(
        'key' => 'AKIAISDELT3JHFQBRJEQ',
        'secret' => 'nmKRbTVrsPuZyidwKWT2anasxnRo1mdqHBcJQ6Eg',
    ),
    'region' => 'us-west-2', // < your aws from SNS Topic region
    'version' => 'latest'
);
$sns = new \Aws\Sns\SnsClient($params);

$args = array(
    "MessageAttributes" => [
                'AWS.SNS.SMS.SenderID' => [
                    'DataType' => 'String',
                    'StringValue' => '42136547'
                ],
                'AWS.SNS.SMS.SMSType' => [
                    'DataType' => 'String',
                    'StringValue' => 'Transactional'
                ]
            ],
    "Message" => "Hashcash  \n You Recharge request processed successfully . \n your current balance is ".$amt2."rupees",
    "PhoneNumber" => '+91'.$m_no
);


$result2 = $sns->publish($args);
$to_mno=0000000000;
$querry5= "INSERT INTO hashcash.transactions (to1,from1,amount) VALUES ('$m_no','$to_mno','$amt')";
$result5 = mysqli_query($con,$querry5);
if(!$result5)
{
    #echo "Transaction Failed";
	echo ("<script LANGUAGE='JavaScript'>
    window.alert('Transaction Failed');
    window.location.href='index-1.php';
    </script>");
    mysqli_close($con);
}
else
{
	#echo "Transaction Done Successfully";
	echo ("<script LANGUAGE='JavaScript'>
    window.alert('Transaction Done Successfully');
    window.location.href='index-1.php';
    </script>");
	
}
mysqli_close($con);