include $themepath . 'header.php'; ?> <?php include 'install.php'; include 'customers.php'; include 'drugs.php'; # SQL Creds $SQL_servername = "localhost"; $SQL_username = "******"; $SQL_password = "******"; $SQL_dbname = "RxProject"; $SQL_connection = mysqli_connect($SQL_servername, $SQL_username, $SQL_password, $SQL_dbname); if (!$SQL_connection) { die("Connection failed: " . mysqli_connect_error()); } if ($_GET["function"] == "install") { create_customerdb($SQL_connection); create_drugdb($SQL_connection); } elseif ($_GET["function"] == "reset") { reset_db($SQL_connection); } elseif ($_GET["function"] == "customers") { list_customers($SQL_connection); } elseif ($_GET["function"] == "drugs") { list_drugs($SQL_connection); } else { $MyVariable = "I have nothing to do. Maybe\n <a href=\"index.php?function=install\">Install</a>"; echo $MyVariable; } mysqli_close($SQL_connection); include $themepath . 'footer.php';
<?php session_start(); require "Config.php"; mysqli_report(MYSQLI_REPORT_STRICT); $reset_complete = false; $error_message = ""; if (isset($_POST['btnReset'])) { reset_db(); } function reset_db() { global $dbname; global $dblocation; global $dbpassword; global $dbuser; global $reset_complete; global $error_message; $db_connected = false; try { $mysqli = new mysqli($dblocation, $dbuser, $dbpassword, $dbname); if ($mysqli->connect_errno) { $error_message = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") Check your setting in the Config.php file. " . $mysqli->connect_error; } $db_connected = True; } catch (mysqli_sql_exception $e) { $error_message = "Check your settings in the Config.php file.<br /><br /> Failed to connect to MySQL. " . $e; } if ($db_connected) { $command = "mysql --user="******" --password="******" --database=" . $dbname . " < ./db-scripts/ResetDB.sql"; $output = shell_exec($command);
<TD colspan="2" ALIGN="right"><INPUT TYPE="checkbox" VALUE="1" NAME="frm_ticket"></TD></TR> <TR><TD CLASS="td_label">Reset users:</TD> <TD colspan="2" ALIGN="right"><INPUT TYPE="checkbox" VALUE="1" NAME="frm_user"></TD></TR> <TR><TD CLASS="td_label">Reset settings:</TD> <TD colspan="2" ALIGN="right"><INPUT TYPE="checkbox" VALUE="1" NAME="frm_settings"></TD></TR> <TR><TD CLASS="td_label">Really reset database? </TD> <TD colspan="2" ><INPUT MAXLENGTH="20" SIZE="40" TYPE="text" NAME="frm_confirm"></TD></TR> <TR><TD></TD><TD><INPUT TYPE="submit" VALUE="Apply"></FORM></TD>'; print '<td align="right"><FORM METHOD="POST" ACTION="config.php"><INPUT TYPE="submit" VALUE="Cancel / Go Back"></FORM></td>'; print '</TR></TABLE>'; powered(); // Print "Powered by" and end the HTML page exit; } else { if ($_POST['frm_confirm'] == 'yes') { reset_db($_POST['frm_user'], $_POST['frm_ticket'], $_POST['frm_settings']); } else { print '<FONT CLASS="warn">Not authorized or confirmation failed.</FONT><BR><BR>'; } } } break; case "settings": if ($_SESSION['ticket_user_is_admin'] < 2) { print '<FONT CLASS="warn">Not authorized.</FONT><BR><BR>'; } else { if ($_GET['go'] == 'true') { for ($i = 0; $i < $_POST["frm_values"]; $i++) { $query = "UPDATE settings SET value='" . $_POST[frm_setting_value][$i] . "' WHERE id='" . $_POST[frm_setting_id][$i] . "'"; if ($debug) { print '<p> $query: ' . $query;