/** * * @param int $state :state in Transaction_state_config * @return */ public function update($state, $conn) { require_once 'class/Config_commodity.php'; require_once 'class/DBupdater.php'; $ary = array(Config_commodity::commodity_state => $state); $where = ' where ' . Config_commodity::id . ' = ' . "'{$this->commodity_id}'"; $DBupdater = new DBupdater(Config_commodity::table_name, $ary, $this->where); return $DBupdater->excute($conn); }
function update_transaction_state($conn, $commodity_id) { include_once 'class/DBupdater.php'; include_once 'class/Config_transaction.php'; include_once 'class/commodity/Transaction_state_config.php'; $ary = array(Config_transaction::state => Transaction_state_config::both_comfirmed); $where = ' where ' . Config_transaction::choosed_id . ' = ' . "'" . $commodity_id . "'"; $DBupdater = new DBupdater(Config_commodity::table_name, $ary, $where); return $DBupdater->excute($conn); }
/** * 执行更新操作更新商品信息,并根据商品ID查询商品信息 * @param 数据库连接 $conn * @param bigint $commodity_id * @param tinyint $state * @return array 以数组形式返回查询结果 */ function update_commodity_state_and_return_commodity($conn, $commodity_id, $state) { require_once 'class/commodity/Transaction_state_config.php'; require_once 'class/Config_commodity.php'; require_once 'class/DBupdater.php'; require_once 'class/DBtraverser.php'; $ary = array(Config_commodity::commodity_state => $state); $where = ' where ' . Config_commodity::id . ' = ' . "'{$commodity_id}'"; $DBupdater = new DBupdater(Config_commodity::table_name, $ary, $where); $DBupdater->excute($conn); $DBtraveser = new DBtraverser(Config_commodity::table_name, $where); $retval = $DBtraveser->excute($conn); return mysqli_fetch_array($retval, MYSQLI_ASSOC); }
<?php /** * id * */ session_start(); if (isset($_SESSION['CURRENT_LOGIN_ID'])) { require_once 'class/Config_commodity.php'; require_once 'class/DBtraverser.php'; require_once 'class/DBupdater.php'; require_once 'class/Config_commodity.php'; require_once 'class/Config.php'; require_once 'class/commodity/Transaction_state_config.php'; require_once 'Include_is_publisher.php'; $conn = Config::connect(); $commodity_id = (int) $_GET['id']; $where = ' where ' . Config_commodity::id . ' = ' . "'" . $commodity_id . "'"; if (loginer_isPublisher($conn, $where)) { require_once 'class/DBupdater.php'; $updater_ary = array(Config_commodity::commodity_state => Transaction_state_config::commodity_deleted); $DBupdater = new DBupdater(Config_commodity::table_name, $updater_ary, $where); $DBupdater->excute($conn); } mysqli_close($conn); } else { include 'Login.php'; }