如何在 php 中运行 mysql 脚本？

Question

我有一个 mysql 脚本需要在 php 中运行，我尝试过，但没有成功。有人可以帮我吗？我也尝试使用 mysqli_multi_query，但它也不起作用。<?php include 'connection.php';if(isset($_GET["action"])&&($_GET["action"]=="versave")){ $gp_name = $_GET['gp_name'];$version = $_GET['version'];$query_vers = "CREATE TEMPORARY TABLE tmp SELECT * from `gp_info` WHERE `gp_name`= $gp_name";$query_vers .= "UPDATE tmp SET `version` = $version";$query_vers .= "ALTER TABLE tmp DROP id";$query_vers .= "INSERT INTO `gp_info` SELECT 0, tmp.* FROM tmp";$query_vers .= "DROP TABLE tmp";mysqli_multi_query($connect, $query_vers);header("Location: gp_data.php");}?><form id="verForm" name="versaveForm" method="get"><input type="hidden" name="action" value="versave"><div><input type="text" id="gp_name" name="gp_name"><input type="text" id="version" name="version"></div><input type="submit" name="vers" value="Version" id="versave"></form>

Answer 1

如果您使用的是 GET 方法，请使用 $_GET 来获取提交表单数据。

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "test";

session_start();

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);

} 

if(isset($_GET["action"])&&($_GET["action"]=="versave")){ 

$gp_name = $_GET['gp_name'];

$version = $_GET['version'];

$query_vers = "CREATE TEMPORARY TABLE IF NOT EXISTS tmp SELECT * from `gp_info` WHERE `gp_name`= '$gp_name';

UPDATE tmp SET `version` = '$version';

ALTER TABLE tmp DROP id;

INSERT INTO `gp_info` SELECT 0, tmp.* FROM tmp";

if(mysqli_multi_query($conn, $query_vers)){

    echo "query exicute";

}

 //header("Location: gp_data.php");

}

?>

<form id="verForm" name="versaveForm" method="get">

    <input type="hidden" name="action" value="versave">

    <div>

    <input type="text" id="gp_name" name="gp_name">

    <input type="text" id="version" name="version">

    </div>

    <input type="submit" name="vers" value="Version" id="versave">

</form>

Answer 2

使用mysqli_query代替mysql_query。它在新版本中已被弃用，php并且仅使用了 1 个参数。我们没有在mysql_query.

mysql_query($connect, $query_vers);

将此行更新为 mysqli_query

mysqli_query($connect, $query_vers);

Answer 3

使用 PDO 而不是mysql_query()

<?php

if(isset($_POST["action"])&&($_POST["action"]=="versave")) {

    $query_vers = "CREATE TEMPORARY TABLE tmp SELECT * from `gp_info` WHERE `gp_name`= gp_name;

            UPDATE tmp SET `version` = version;

            ALTER TABLE tmp DROP id;

            INSERT INTO `gp_info` SELECT 0, tmp.* FROM tmp;

            DROP TABLE tmp";

    $db = new PDO('mysql:host=localhost;dbname=test', 'username', 'passwd');

    $st = $db->exec($query_vers);

}