dashboard/pei.php

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php
include('include/config.inc.php');

$sql = 'SELECT * FROM morder WHERE id='.$_GET['id'];
$ord = $db->execute_dql($sql);
$ord = $ord[0];

$sql = 'SELECT * FROM bikes WHERE id='.$ord['bike_id'];
$bike = $db->execute_dql($sql);
$bike = $bike[0];

$money = ($bike['price']*$ord['borrow_hour'])*$ord['num'];

$sql = 'SELECT * FROM members WHERE id='.$_SESSION['userid'];
$user = $db->execute_dql($sql);
$user = $user[0];

$left = $user['money']-$money;

if(($left)<0)
{
    echo '<script>';
    echo 'alert("余额不足");';
    echo 'window.history.back(-1);';
    echo '</script>';
    exit;
}


$sql = 'UPDATE morder SET step=2 WHERE id='.$_GET['id'];
$db->execute_dml($sql);
$sql = 'UPDATE members SET money='.$money.' WHERE id='.$user['id'];
$db->execute_dml($sql);

echo '<script>';
echo 'window.history.back(-1);';
echo '</script>';