doulang9953 2019-04-12 09:12
浏览 56
已采纳

无论如何我可以在单击按钮时插入SQL语句

I have a table set up as seen below:

Table Setup

I have a slideshow (slides are on different .php pages) and at the bottom of each page I have a button, they click on which just holds the a href to the next or on the back button, previous page.

I need to store which number slide they are on into the userTakingModule table in the checkPoint. Is there anyway someone could give me some guidance on how to do this please. The first slide they reach I guess it would be an INSERT query, then if there is already a value held in checkPoint it would be an UPDATE query. I'm so lost, anyone able to shed some much needed light?

The button code at the end of each slide:

<div class="arrow-container">
  <button><a href="dashboard.php"><i class="fas fa-arrow-circle-left"></i></a></button><button><a href="slide2.php"><i class="fas fa-arrow-circle-right"></i></a></button>
</div>
  • 写回答

1条回答 默认 最新

  • doufa5001 2019-04-12 09:41
    关注

    Simple solution for this is, If there is entry into table regarding checkpoint then update that entry with new data else insert new entry. You can insert and update with same query by using

    INSERT ... ON DUPLICATE KEY UPDATE ((which will execute the UPDATE at the end if name already exists see documentation)

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 大华dss监控平台网络关闭登不进去
  • ¥15 请使用蚁群算法解决下列问题,并给出我完整的代码
  • ¥20 关于php录入完成后,批量更新数据库
  • ¥15 请教往复密封润滑问题
  • ¥15 cocos creator发布ios包
  • ¥15 comsol压电材料数据
  • ¥35 用python实现除法算法中goldschmidt算法
  • ¥15 汇编代码转换成C代码
  • ¥15 除法算法中的归一化具体是怎么变的?
  • ¥20 集成电路的逻辑电路和晶体管简化图