function credit($creditAmount, $accountNum)
{
$accdb = "accounts";
$conn = connRTServer($accdb);
$sql = "select balance from accounts where accNum = " . $accountNum . ";";
$result = $conn->query($sql);
$currBal = $result->fetch_row();
$newBal = $creditAmount + $currBal[0];
$sql2 = "update accounts set balance = " . $newBal . " where accNum = " . $accountNum . ";";
$conn->query($sql2);
$conn->close();
}
function newEmail($checkThis)
{
$db = "loginAccounts";
$conn = connRTServer($db);
$sql = "SELECT * FROM regUsers WHERE email = '" . $checkThis . "';";
$result = $conn->query($sql);
//Check number of emails
if ($result->num_rows > 0) {
return false;
} else {
return true;
}
}
<?php
require 'rules.php';
require 'helper.php';
session_start();
$db = "accounts";
$conn = connRTServer($db);
$sql = "select accName, balance, accNum from accounts where accounts.username = '******';";
$res = $conn->query($sql);
echo "<p style=\"text-align:right;\">" . $_SESSION['username'] . " <input type=\"button\" onclick=\"location.href='userSettings.php'\" \n value=\"Edit Profile\" style=\"color:White; background-color:Blue; border:2px solid Blue;\"/><input type=\"button\" \n onclick=\"location.href='logout.php'\" value=\"Logout\" style=\"color:White; background-color:#A80000; border:2px solid #A80000;\"/></p>";
echo "<p style=\"text-align:center;\">Welcome to RT Bank, " . $_SESSION['firstname'] . "!";
//Loop through and display all accounts
for ($j = 0; $j < $res->num_rows; $j++) {
if ($j == 0) {
echo "<table align=\"center\" sytle='width:40%'><col width=\"400px\"/><col width=\"100px\"/><col width=\"200px\"/><tr><th>Account Name</th><th>Account Number</th><th>Balance</th></tr>";
}
$result = $res->fetch_row();
if (minBalance($result[1])) {
echo "<tr><td><font color=\"#FF0000\">Balance is Below Bank Minimum! Deposit more money immediately!</font><td></tr>";
}
echo "<tr><td>" . $result[0] . "</td><td align=\"center\">" . $result[2] . "</td><td align=\"right\">\$" . $result[1] . "</td></tr>";
echo "<td><form action=\"closeSetup.php\" method=\"get\"><input type=\"hidden\" name=\"closeAcc\" value=\"" . $result[2] . "\"><input type=\"submit\" value=\"Close\"></form></td>";
}
echo "</table></p>";
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="index.css">
<link rel="shortcut icon" href="http://www.iconj.com/ico/c/j/cjmjbapkib.ico" type="image/x-icon" />
<title>
<head>
<link rel="stylesheet" type="text/css" href="index.css">
<link rel="shortcut icon" href="http://www.iconj.com/ico/c/j/cjmjbapkib.ico" type="image/x-icon" />
<title>
Admin|RT Bank
</title>
</head>
<body>
<?php
require 'helper.php';
session_start();
$db = "accounts";
$logdb = "loginAccounts";
$conn = connRTServer($db);
$logconn = connRTServer($logdb);
$cred = "SELECT * FROM admin WHERE accountName = '" . $_SESSION['username'] . "' and password = '******'password'] . "';";
$checkcred = $logconn->query($cred);
//Check if user loged in
if ($checkcred->num_rows != 1) {
header('Location:index.html');
$conn->close();
exit;
}
echo "<p style=\"text-align:right;\">";
echo "<input type=\"button\" onclick=\"location.href='logout.php'\" value=\"Logout\" style=\"color:White; background-color:#A80000; border:2px solid #A80000;\"/></p>";
$sql = "SELECT * FROM accounts";
$result = $conn->query($sql);
for ($x = 0; $x < $result->num_rows; $x++) {
if ($x == 0) {
echo "<table align=\"center\" style='width:50%'><col width=\"350px\"/><col width=\"400px\"/><col width=\"200px\"/><col width=\"200px\"/><tr><th>User</th><th>Account Name</th><th>Account Number</th><th>Balance</th></tr>";
<title>
Edit Profile|RT Bank
</title>
</head>
<body>
<p style="text-align:right;"/><input type="button" onclick="location.href='logout.php'" value="Logout" style="color:White; background-color:#A80000; border:2px solid #A80000";/></p>
<h3><p style="text-align:center;"/>Edit your RT Bank profile and settings from here!</p></h3>
<form action="updateUserInfo.php" method="get" target="_self">
<?php
require 'helper.php';
session_start();
$db = "loginAccounts";
$accdb = "accounts";
$conn = connRTServer($db);
$acc = connRTServer($accdb);
//Retrieves current user info
$sql = "SELECT * FROM regUsers WHERE accountName = '" . $_SESSION['username'] . "';";
$result = $conn->query($sql);
$userinfo = $result->fetch_row();
echo "<p style=\"text-align:center;\"/>Update your contact info!</p>";
echo "<p style=\"text-align:center;\"/><font color=\"Red\"> Email already registered!</font><br>Phone:<input type=\"number\" name=\"phone\" min=\"9\" value=\"" . $userinfo[4] . "\" required>";
echo " Email:<input type=\"email\" name=\"email\" value=\"" . $userinfo[5] . "\" required><br>";
echo "Street Address Line 1:<input type=\"text\" name=\"address1\" value=\"" . $userinfo[6] . "\" required><br>";
echo "Street Address Line 2:<input type=\"text\" name=\"address2\" placeholder=\"(Optional)\"><br>";
echo "City:<input type=\"text\" name=\"city\" value=\"" . $userinfo[8] . "\" required><br>";
echo "State:<select name='state'>\n\t<option value=" . $userinfo[9] . " selected>" . $userinfo[9] . "</option>\n\t<option title=Other>Other</option>\n\t<option title=Alabama>Alabama</option>\n\t<option title=Alaska>Alaska</option>\n\t<option title=Arizona>Arizona</option>\n\t<option title=Arkansas>Arkansas</option>\n\t<option title=California>California</option>\n\t<option title=Colorado>Colorado</option>\n\t<option title=Connecticut>Connecticut</option>\n\t<option title=Delaware>Delaware</option>\n\t<option title=Florida>Florida</option>\n\t<option title=Georgia>Georgia</option>\n\t<option title=Hawaii>Hawaii</option>\n\t<option title=Idaho>Idaho</option>\n\t<option title=Illinois>Illinois</option>\n\t<option title=Indiana>Indiana</option>\n\t<option title=Iowa>Iowa</option>\n\t<option title=Kansas>Kansas</option>\n\t<option title=Kentucky>Kentucky</option>\n\t<option title=Louisiana>Louisiana</option>\n\t<option title=Maine>Maine</option>\n\t<option title=Maryland>Maryland</option>\n\t<option title=Massachusetts>Massachusetts</option>\n\t<option title=Michigan>Michigan</option>\n\t<option title=Minnesota>Minnesota</option>\n\t<option title=Mississippi>Mississippi</option>\n\t<option title=Missouri>Missouri</option>\n\t<option title=Montana>Montana</option>\n\t<option title=Nebraska>Nebraska</option>\n\t<option title=Nevada>Nevada</option>\n\t<option title=NewHampshire>New Hampshire</option>\n\t<option title=NewJersey>New Jersey</option>\n\t<option title=NewMexico>New Mexico</option>\n\t<option title=NewYork>New York</option>\n\t<option title=NorthCarolina>North Carolina</option>\n\t<option title=NorthDakota>North Dakota</option>\n\t<option title=Ohio>Ohio</option>\n\t<option title=Oklahoma>Oklahoma</option>\n\t<option title=Oregon>Oregon</option>\n\t<option title=Pennsylvania>Pennsylvania</option>\n\t<option title=RhodeIsland>Rhode Island</option>\n\t<option title=SouthCarolina>South Carolina</option>\n\t<option title=SouthDakota>South Dakota</option>\n\t<option title=Tennessee>Tennessee</option>\n\t<option title=Texas>Texas</option>\n\t<option title=Utah>Utah</option>\n\t<option title=Vermont>Vermont</option>\n\t<option title=Virginia>Virginia</option>\n\t<option title=Washington>Washington</option>\n\t<option title=WestVirginia>West Virginia</option>\n\t<option title=Wisconsin>Wisconsin</option>\n\t<option title=Wyoming>Wyoming</option>\n</select>";
echo " ZIP:<input type=\"text\" name=\"zipcode\" value=\"" . $userinfo[10] . "\" required></p>";
echo "<p style=\"text-align:center;\">Select a default account to be used in transfers! <br>(NOTE! If no account is selected, you will not be able to recieve moeny transfers from other bank customers!)";
echo "<p style=\"text-align:center;\">Current Default Account:";
//Retreive users accounts
