$query = $sql->prepare("delete from products where upc = ? and description=?"); $args = array($upc, $desc); //echo $query; //return; } else { $query = $sql->prepare("delete from products where upc = ?"); $args = array($upc); } //echo $query; $result = $sql->execute($query, $args); $extraQ = $sql->prepare("delete from prodExtra where upc=?"); $extraR = $sql->execute($extraQ, array($upc)); if (isset($_POST["scale_delete"]) && $_POST["scale_delete"] == "on") { $plu = substr($upc, 3, 4); include "hobartcsv/parse.php"; deleteitem($plu); } echo "<script language=JavaScript>"; // reloading opener works in Firefox, not in Safari (loses POST data) //echo "opener.location.reload();"; echo "close();"; echo "</script>"; } else { if (isset($_POST['No'])) { echo "<script language=JavaScript>"; echo "close();"; echo "</script>"; } else { $upc = $_GET['upc']; echo "Are you sure you want to delete item {$upc}"; if (isset($_GET['description'])) {
return $so->idscorm_organization; } } if (isset($GLOBALS['op'])) { switch ($GLOBALS['op']) { /*case "display": { display(); }; break;*/ case "additem": additem(); break; case "insitem": insitem(); break; case "deleteitem": deleteitem(); break; case "dodelete": dodelete(); break; case "category": category(); break; case "categorysave": categorysave(); break; case "play": play(); break; case "tree": require dirname(__FILE__) . '/scorm_page_tree.php';
getprivilages(); break; case 'getquota': getquota(); break; case 'getitems': getitems($_POST['playlistid']); break; case 'uploaditemfile': uploaditemfile($_FILES['file'], $_POST['playlistid']); break; case 'createitementry': createitementry($_POST['name'], $_POST['title'], $_POST['description'], $_POST['type'], $_POST['playlistid']); break; case 'deleteitem': deleteitem($_POST['itemid']); break; case 'getplaylistitems': getplaylistitems(); break; case 'uploadplaylistfile': uploadplaylistfile($_POST['playlistid'], $_FILES['file']); break; case 'createplaylistentry': createplaylistentry($_POST['name'], $_POST['description'], $_POST['thumbname']); break; case 'deleteplaylist': deleteplaylist($_POST['playlistid']); break; case 'editplaylistentry': editplaylistentry($_POST['id'], $_POST['name'], $_POST['description'], $_POST['thumbname']);
include 'parse.php'; if (!class_exists("SQLManager")) { require_once "../../sql/SQLManager.php"; } include '../../db.php'; $fetchQ = "select plu from scaleItems where plu='0027985000000'"; $fetchR = $sql->query($fetchQ); $plus = array(); $i = 0; while ($fetchW = $sql->fetch_array($fetchR)) { preg_match("/002(\\d\\d\\d\\d)0/", $fetchW[0], $matches); $plu = $matches[1]; if (!empty($plu)) { $plus[$i] = $plu; $i++; } } deleteitem($plus, $_GET['scale']); echo "Item delete requested"; } else { echo "<form action=delete.php method=get>"; echo "<select name=scale>"; $i = 0; foreach ($scale_ips as $s) { echo "<option value={$i}>{$s}</option>"; $i++; } echo "</select>"; echo "<input type=submit value=Delete />"; echo "</form>"; }