Admin Admin Panel Select User [insert_php] $servername = “localhost”; $username = “silverpo_auth”; $password = “,4mzF7mBre+z”; $dbname = “silverpo_accounting”; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die(“Connection failed: “); } $sql = “SELECT user FROM users ORDER BY user”; $result = $conn->query($sql); while($row = $result->fetch_assoc()) { echo “” . $row[‘user’] . ““; } [/insert_php] Confirm Written Checks [insert_php] $sql = “SELECT * FROM payments ORDER BY checkNum”; $result = $conn->query($sql); while($row = $result->fetch_assoc()) { echo “” . $row[‘checkNum’] . ““; } [/insert_php] Confirmed Deposits [insert_php] $sql = “SELECT checkNum FROM payments ORDER BY checkNum”; $result = $conn->query($sql); while($row = $result->fetch_assoc()) { echo “” . $row[‘checkNum’] . ““; } [/insert_php] Set Page Security [insert_php] $pageSec = isset($_POST[‘pageSec’])? $_POST[‘pageSec’] : “”; $txt_file = file_get_contents(‘/home/silverpond/public_html/wp-content/themes/twentyseventeen/perms.txt’); $rows = explode(“\n”, $txt_file); array_shift($rows); echo “ – “; foreach($rows as $row => $data) { $dataLen = – strlen($data) + 12; $dataCmp = substr($data,$dataLen); echo “” . $dataCmp . ““; } echo “ “; echo “Permissions: “; echo “ Admin: “; echo “ Level 2: “; echo “ Level 3: “; echo “ “; echo “"; [/insert_php] New Page: Note: Any page added must include full path and closing slash like the options above. No checks are in place to avoid duplicates.
