public function LoadData() { $DB = new conn(); $DB->connect(); $sql = "SELECT * FROM finance_options"; $result = $DB->query($sql); while ($row = mysql_fetch_assoc($result)) { $financeDetails[] = $row; } $DB->close(); return $financeDetails; }
<TABLE class="data"> <th>id</th> <th>Location Name</th> <th>Commands</th> <?php while ($row = mysql_fetch_assoc($result)) { ?> <TR><TD><?php echo $row["storagelocation_id"]; ?> </TD> <TD><?php echo $row["storagelocation_name"]; ?> </TD> <TD><a href="#">Edit</a></TD> </TR> <?php } ?> </TABLE> <?php } $DB->close(); ?> <Br><a href="AddLocation.php">Add a New Storage Location</a> <?php include $_SERVER['DOCUMENT_ROOT'] . "/" . $ROOTPATH . "/Includes/Bottom.php";
<?php include "./findconfig.php"; include $_SERVER['DOCUMENT_ROOT'] . "/" . $ROOTPATH . "/Includes/Top.php"; $F = new FormElements(); $db = new conn(); $firephp->log($_REQUEST); if ($_REQUEST["report"]) { // Inventory Report if ($_REQUEST["report"] == "inventory") { if ($_REQUEST["StartDate"] && $_REQUEST["EndDate"]) { $db->connect(); $startDate = $db->Sanitize($_REQUEST["StartDate"]); $endDate = $db->Sanitize($_REQUEST["EndDate"]); $productType = $db->Sanitize($_REQUEST["ProductType"]); $db->close(); header("Location: NexusReport_Inventory.php?startDate=" . $startDate . "&endDate=" . $endDate . "&productType=" . $productType); } } $firephp->log($_REQUEST["report"]); $firephp->log($_REQUEST["generalSalesStartDate"]); $firephp->log($_REQUEST["generalSalesEndDate"]); // Individual Sale if ($_REQUEST["report"] == "IndividualOrder") { if ($_REQUEST["OrderID"]) { $db->connect(); $order_id = $DB->sanitize($_REQUEST["OrderID"]); $db->close(); header("Location: NexusReport_IndividualOrder.php?OrderID=" . $order_id); } }
function ddlTeams($selected = "", $css = "") { ?> <li class="validated" style="<?php echo $css; ?> " id="tbTeams_li"> <label for="r_tbTeams">Team:</label> <div id="tbTeams_img"></div> <select class="validated" name="Teams" id="ddlTeams" > <?php $DB = new conn(); $DB->connect(); $perms = $DB->getTeams(); $DB->close(); foreach ($perms as $perm) { ?> <OPTION value="<?php echo $perm["team_id"]; ?> "><?php echo $perm["team_name"]; ?> (<?php echo $perm["LastName"]; ?> )</OPTION><?php } ?> </SELECT> <div id="tbTeams_msg"></div> </li> <?php if ($selected) { ?> <SCRIPT type="text/javascript"> $('#ddl<?php echo $id; ?> ').val("<?php echo $selected; ?> "); </SCRIPT> <?php } ?> <?php }