通过 php 运行许多 mySQL 查询 [英] Run many mySQL queries through php

问题描述

我有一个包含许多表的数据库.在第 1 侧，我有一个按钮将我传递到第 2 侧.在第 2 侧，我希望代码删除每个命名表中的每一行，这些表具有我存储在变量中的特定 pid.我在第 2 面有一个代码，但它没有做任何事情.

I have a database with many tables. On side 1, I have a button that passes me to side 2. On side 2, I want the code to remove every row in every named table that has a specific pid that I have stored in a variable. I have a code on side 2 but it doesn't do anything.

第 2 面的代码:

$pid3 = $_POST['pid2'];

$del = "DELETE FROM answer_det WHERE pid='$pid3'";
$del .= "DELETE FROM project WHERE pid='$pid3'";
$del .= "DELETE FROM question WHERE pid='$pid3'";
$del .= "DELETE FROM respondent WHERE pid='$pid3'";
$del .= "DELETE FROM result WHERE pid='$pid3'";
$del .= "DELETE FROM users WHERE pid='$pid3'";

$run = mysqli_query($mysqli,$del);

if($run)
{
   echo "<h1>Project is deleted!</h1>";
}

推荐答案

使用 mysqli_multi_query

$pid3 = $_POST['pid2'];

$del = "DELETE FROM answer_det WHERE pid='$pid3';";
$del .= "DELETE FROM project WHERE pid='$pid3';";
$del .= "DELETE FROM question WHERE pid='$pid3';";
$del .= "DELETE FROM respondent WHERE pid='$pid3';";
$del .= "DELETE FROM result WHERE pid='$pid3';";
$del .= "DELETE FROM users WHERE pid='$pid3';";

$run = mysqli_multi_query($mysqli,$del);

if($run)
{
   echo "<h1>Project is deleted!</h1>";
}

这篇关于通过 php 运行许多 mySQL 查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！