/**
*
* @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';
}
