1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
| <?php
function balanceEnquiry($pin,$phone){
$balance = "Select * from accountDetails where mobile = '$phone'";
$result = mysql_query($balance);
$response = "Available cash:";
$balanceObject = mysql_fetch_object($result);
$response = $response." Balance: ".$balanceObject->balance;
return $response;
}
function viewStatements($pin,$phone){
$statement = "Select * from Activities ac, accountDetails acc where ac.accountNo = acc.accountNo and mobile= '$phone'";
$result = mysql_query($statement);
$response = "Activities Done for the Account:";
while($statementObject = mysql_fetch_object($result)){
$response = $response."Account Number: ".$statementObject->accountNo." |Activity Type:".$statementObject->activityType." |Amount:".$statementObject->Amt." |Activity DateTime:".$statementObject->activityDateTime;
return $response;
}
}
function Transfer($pin,$phone,$accNo,$amt){
$sql= "SELECT * FROM accountDetails where mobile=$phone";
$result = mysql_query($sql);
while($row = mysql_fetch_object($result)){
$accNo1 = $row->accountNo;
}
$Type = "Funds Transfer";
$insertbal1 = "insert into Activities(accountNo,pin,Amt,activityType) values ('$accNo1','$pin',$amt *-1,'$Type')";
$sqlupdate1="UPDATE accountDetails set balance = balance-$amt where mobile='$phone'";
$insertbal2 = "insert into Activities(accountNo,pin,Amt,activityType) values('$accNo','$pin','$amt','$Type')";
$sqlupdate2="UPDATE accountDetails set balance = balance+$amt where mobile='$phone'";
if((mysql_query($insertbal1)) && (mysql_query($insertbal2))){
mysql_query($sqlupdate1);
mysql_query($sqlupdate2);
return "Your transfer has been updated with ".$amt." successfully.";
}
else
{
return "Sorry, Account cant be updated";
}
}
function Withdraw($pin,$phone,$accNo,$amt){
$sql= "SELECT * FROM accountDetails where mobile=$phone";
$result = mysql_query($sql);
$Type = "withdraw";
$insertbal = "insert into Activities(accountNo,pin,Amt,activityType) values ('$accNo','$pin',$amt *-1,'$Type')";
$sqlupdate = "UPDATE accountDetails set balance = balance-$amt where mobile='$phone'";
if(mysql_query($insertbal)){
mysql_query($sqlupdate);
return "You have withdrawn. ".$amt." from your account";
}
else
{
return "Sorry, Cant withdraw";
}
}
function Deposit($pin,$phone,$accNo,$amt){
$sql= "SELECT * FROM accountDetails where mobile=$phone";
$result = mysql_query($sql);
$Type = "Deposit";
$insertbal = "insert into Activities(accountNo,pin,Amt,activityType) values ('$accNo','$pin',$amt,'$Type')";
$sqlupdate = "UPDATE accountDetails set balance = balance+$amt where mobile='$phone'";
if(mysql_query($insertbal)){
mysql_query($sqlupdate);
return "You have Deposited. ".$amt." to your account";
}
else
{
return "Sorry, Cant Deposit";
}
}
?> |
Partager