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 基于卷积神经网络的声纹识别
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图
  • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
  • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
  • ¥15 CSAPPattacklab
  • ¥15 一直显示正在等待HID—ISP
  • ¥15 Python turtle 画图
  • ¥15 stm32开发clion时遇到的编译问题