douyue1926 2012-04-19 19:36
浏览 85
已采纳

php拍卖采取同时提交的平等出价

i'm developing a website with auctions. I've programmed my own auction system. The auctions run for a specific period of time, and users place their bid. The highest bidder at the ending time wins the auction (just like ebay). When the user places his/her bid, database checking is done if that was the highest bid and if it is, then the bid gets placed, else not.

Everything works great but the problem is that, i have kept my two laptops aside, logged in from different accounts and submitted the bids at the exact time and both of the bids gets placed (both the bids are greater than the current highest and both are equal). Two equal bids cannot be placed on the same product right? and this happens if two users submit the bid at the same time.

Can anybody tell the logic to get rid of this problem?

  • 写回答

2条回答 默认 最新

  • dongqie2028 2012-04-19 19:42
    关注

    you need to implement a way to manage concurrent writes to the database. There are a couple of ways to achieve this. I suggest you start here : http://en.wikipedia.org/wiki/Lock_%28database%29

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 Vue3 大型图片数据拖动排序
  • ¥15 划分vlan后不通了
  • ¥15 GDI处理通道视频时总是带有白色锯齿
  • ¥20 用雷电模拟器安装百达屋apk一直闪退
  • ¥15 算能科技20240506咨询(拒绝大模型回答)
  • ¥15 自适应 AR 模型 参数估计Matlab程序
  • ¥100 角动量包络面如何用MATLAB绘制
  • ¥15 merge函数占用内存过大
  • ¥15 使用EMD去噪处理RML2016数据集时候的原理
  • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大