?> </td> <?php echo "</tr>"; } echo "</table>"; } if (session_status() == PHP_SESSION_NONE) { session_start(); } require_once "../config.php"; require_once ROOT_PATH . "/opendb.php"; require_once ROOT_PATH . TEMPLATES_PATH . "/header.php"; require_once "crud.php"; require_once "show.php"; require_once "../permissions.php"; if (Can_Do_Inventory() && isset($_POST['list_delete_btn'])) { $key = $_POST['inventorynum']; $key_array = array('inventorynum' => $_POST['inventorynum']); RowDelete($database, 'inventory_items', $key_array); } if (isset($_POST['create_btn'])) { unset($_POST['create_btn']); RowCreate($database, 'inventory_items', $_POST); } if (Can_Do_Inventory()) { $result = TableRetrieve($database, "inventory_items"); MemberTableShow($result); } else { echo "Insufficient permissions."; }
<?php if (isset($_POST['submit'])) { $tid = getNextID($database, 'transaction', 'transactionid') + 2; $quantity = $_POST['quantityDrop']; $transDate = date("20y-m-d"); $inventoryNum = 0; // get inventory num from $resultItem foreach ($resultItem as $row => $value) { if ($itemValue == $value["name"]) { $inventoryNum = $value["inventorynum"]; } } $membId = 0; $total = $price * $quantity; //echo $memberValue." itemNum=" . $inventoryNum . " itemvalue = ".$itemValue." tid = ".$tid." total = ".$total; $namesArr = preg_split("/[\\s,]+/", $memberValue); $firstName = $namesArr[0]; $lastName = $namesArr[1]; $query = "SELECT memberid FROM member WHERE firstname = '" . $firstName . "' AND lastname = '" . $lastName . "'"; $membId = mysqli_query($database, $query) or die(mysqli_error($database)); $rez = mysqli_fetch_assoc($membId); $membId = $rez['memberid']; //echo " memberid = " . $membId; $value_array = array('transactionid' => $tid, 'date' => $transDate, 'memberid' => $membId, 'inventorynum' => $inventoryNum, 'amount' => $quantity, 'totals' => $total, 'cashierid' => $_SESSION['memberid']); RowCreate($database, "transaction", $value_array); header("Location: transactionList.php"); } //} ?>
<?php if (session_status() == PHP_SESSION_NONE) { session_start(); } require_once "../config.php"; require_once ROOT_PATH . "/opendb.php"; require_once ROOT_PATH . TEMPLATES_PATH . "/header.php"; require_once "crud.php"; require_once "../permissions.php"; if (isset($_POST['create_btn'])) { unset($_POST['create_btn']); RowCreate($database, 'member', $_POST); } if (Can_Create_Members()) { $currDate = date("20y-m-d"); ?> <form method="post" action="<?php $_PHP_SELF; ?> " > <table border='0' > <tr> <td> <b>Member ID:</b> </td> <td> <input type='text' name='memberid' value="<?php echo isset($_POST['memberid']) ? $_POST['memberid'] : ''; ?> ">