<?php require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/ItemDto.php'; require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/dao/ItemDao.php'; require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/Util.php'; try { $dao = new ItemDao(); $item = new ItemDto(); $util = new Util(); $code = $_POST['code']; $name = $_POST['name']; $price = $_POST['price']; $qty = $_POST['qty']; $detail = $_POST['detail']; $priCd = $_POST['priCd']; $qtyCd = $_POST['qtyCd']; $item->setCode($code); $item->setName($name); $item->setPrice($price); $item->setQty($qty); $item->setDetail($detail); $items = array(); $items = $dao->getItem($item, $priCd, $qtyCd); } catch (Exception $e) { $error = $e->getMessage(); } header('Content-Type: text/html; charset=utf-8'); ?> <!DOCTYPE html> <html> <head>
<?php require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/ItemDto.php'; require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/dao/ItemDao.php'; require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/Util.php'; try { $dao = new ItemDao(); $item = new ItemDto(); $util = new Util(); $bcode = $_POST['code']; $item->setCode($bcode); $item->setName(""); $item->setPrice(0); $item->setQty(0); $item->setDetail(""); $items = array(); $items = $dao->getItem($item, 0, 0); } catch (Exception $e) { $error = $e->getMessage(); } header('Content-Type: text/html; charset=utf-8'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>変更情報入力</title> </head> <body> <?php if (isset($error)) {
<?php require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/ItemDto.php'; require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/dao/ItemDao.php'; require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/Util.php'; try { $dao = new ItemDao(); $item = new ItemDto(); $util = new Util(); $code = $_POST['code']; $item->setCode($code); $item->setName(""); $item->setPrice(0); $item->setQty(0); $item->setDetail(""); $result = $dao->deleteItem($code); } catch (Exception $e) { $error = $e->getMessage(); } header('Content-Type: text/html; charset=utf-8'); ?> <!DOCTYPE html> <html> <head> <script type="text/javascript" src="../javascript/jquery/jquery-2.1.4.js"></script> <script type="text/javascript" src="zapp.js"></script> <title>削除結果</title> </head> <body> <?php
/** * itemテーブルのレコードを上書きします。 * * @param int $beforeCode * 変更したい商品のコード * @param ItemDto $item * 上書きする商品の内容 * @return int 更新に成功したレコード数 */ public function updateItem($beforeCode, $item) { $code = $item->getCode(); $name = $item->getName(); $price = $item->getPrice(); $qty = $item->getQty(); $detail = $item->getDetail(); $sql = 'update item set code = ?, name = ?, price = ?, qty = ?, detail = ? where code = ? '; $stmt = $this->pdo->prepare($sql); $stmt->bindValue(1, $code, PDO::PARAM_INT); $stmt->bindValue(2, $this->esc_str($name), PDO::PARAM_STR); $stmt->bindValue(3, $price, PDO::PARAM_INT); $stmt->bindValue(4, $qty, PDO::PARAM_INT); $stmt->bindValue(5, $this->esc_str($detail), PDO::PARAM_STR); $stmt->bindValue(6, $beforeCode, PDO::PARAM_INT); $stmt->execute(); return $stmt->rowCount(); }
<?php require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/ItemDto.php'; require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/dao/ItemDao.php'; require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/Util.php'; try { $dao = new ItemDao(); $item = new ItemDto(); $util = new Util(); $code = $_POST['code']; $name = $_POST['name']; $price = $_POST['price']; $qty = $_POST['qty']; $detail = $_POST['detail']; $item->setCode($code); $item->setName($name); $item->setPrice($price); $item->setQty($qty); $item->setDetail($detail); $result = $dao->insertItem($item); } catch (Exception $e) { $error = $e->getMessage(); } header('Content-Type: text/html; charset=utf-8'); ?> <!DOCTYPE html> <html> <head> <script type="text/javascript" src="../javascript/jquery/jquery-2.1.4.js"></script> <script type="text/javascript" src="zapp.js"></script>
<?php require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/ItemDto.php'; require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/dao/ItemDao.php'; require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/Util.php'; try { $dao = new ItemDao(); $item = new ItemDto(); $util = new Util(); $bcode = $_POST['bcode']; $code = $_POST['code']; $name = $_POST['name']; $price = $_POST['price']; $qty = $_POST['qty']; $detail = $_POST['detail']; $item->setCode($code); $item->setName($name); $item->setPrice($price); $item->setQty($qty); $item->setDetail($detail); $result = $dao->updateItem($bcode, $item); } catch (Exception $e) { $error = $e->getMessage(); } header('Content-Type: text/html; charset=utf-8'); ?> <!DOCTYPE html> <html> <head> <script type="text/javascript" src="../javascript/jquery/jquery-2.1.4.js"></script>