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