PHP db_test::update Examples

Example #1

File: ajaxagentpay.php Project: Xiaoyuyexi/client-server

        $where = 'tfmglist';
        break;
    default:
        break;
}
if ($agpmisagentpay == 0) {
    // $query = "UPDATE tb_".$table." SET fd_".$where."_isagentpay = '2' WHERE fd_".$where."_bkordernumber = '".$bkordernumber."'";
    // $db->query($query);
    // $query1 = "UPDATE tb_agentpaymoneylist SET fd_agpm_isagentpay = '2' WHERE fd_agpm_bkordernumber = '".$bkordernumber."'";
    // $db->query($query1);
    // file_put_contents("text.txt", $query1);
    // echo 'success';
    $talbename = "tb_" . $table;
    $dataArray = array("fd_" . $where . "_isagentpay" => "2");
    $whereArray = "fd_" . $where . "_bkordernumber = '" . $bkordernumber . "'";
    $result1 = $db->update($talbename, $dataArray, $whereArray);
    unset($talbename);
    unset($dataArray);
    unset($whereArray);
    $talbename = "tb_agentpaymoneylist";
    $dataArray = array("fd_agpm_isagentpay" => "2");
    $whereArray = "fd_agpm_bkordernumber = '" . $bkordernumber . "'";
    $result2 = $db->update($talbename, $dataArray, $whereArray);
    if ($result1 && $result2) {
        echo 'success';
    } else {
        echo 'failure';
    }
} else {
    echo 'failure';
}