doumiang2297 2017-03-22 20:53
浏览 12
已采纳

table1中的数据不会移动到table2

I have this button:

<button type="button" class="btn btn-warning btn-md" title="moure a Acollits"><a href="?moureAc_id=<?php echo $row['id']; ?>" onclick="return confirm('Estàs segur que vols moure aquest gat a Acollits?')">Acollit</a></button>

And when I click on it and confirm, I want it to delete table1 data for this specific ID and move it to table2. Currently it deletes the data fine but doesn't move it to the second table so I don't know what I'm doing wrong!

Code:

if(isset($_GET['moureAc_id'])){
    $prepIexec = $conn->prepare('SELECT foto FROM TaulaGats WHERE id =:uid');
    $prepIexec->execute(array(':uid'=>$_GET['moureAc_id']));
    $imatgeRow = $prepIexec->fetch(PDO::FETCH_ASSOC);
    unlink("imatges/".$imatgeRow['foto']);

    $eliminar = $conn->prepare('DELETE FROM TaulaGats WHERE id =:uid');
    $eliminar->bindParam(':uid', $_GET['moureAc_id']);
    $eliminar->execute();

    $moure = $conn->prepare('INSERT INTO TaulaGatsA (nom, sexe, edat, foto) SELECT nom, sexe, edat, foto FROM TaulaGats WHERE id = :uid');
    $moure->bindParam(':uid', $_GET['moureAc_id']);
    $moure->execute();

    header("Location: index.php");
}
  • 写回答

1条回答 默认 最新

  • douzhang2092 2017-03-22 20:56
    关注

    Looks like you're deleting the data before moving it. Execute the INSERT statement, then the DELETE statement.

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

报告相同问题?

悬赏问题

  • ¥15 求购HI3519AV100开发板
  • ¥15 请问1553 RT怎么测试,没有BC有方法吗
  • ¥100 业务编程如何选择学习方向和内容?
  • ¥15 wamp3.3.5安装完成后图标正常显示绿色,鼠标左右键点击图标均无反应。求解决方法。
  • ¥15 鼠标点击的这条记录了什么?
  • ¥15 在写pid调速的程序时,电机始终维持最大速度
  • ¥15 【有偿】调用DXGI截图初始化失败,提示0xf 887a0004
  • ¥15 请问如何查看手机root记录?
  • ¥15 商城小程序订单号重复
  • ¥15 学校优化算法sbo和蚁群算法怎么结合