php - MySQL 使用 PHP

Question

关闭。此题需要 details or clarity 。目前不接受答案。

---

想要改进这个问题吗？通过 editing this post 添加详细信息并澄清问题.

已关闭 5 年前。

Improve this question

我在正确运行此 php 脚本时遇到问题。

“redirect_to()”和“$link”均在附加文件中定义。

任何提示将不胜感激。

if (isset($_POST['submit'])) {
$id = $_GET["section"];

$about_me = "../include/about_me.php";

$providers_2 = "../include/2providers.php";

$more_providers = "../include/more_proiders.php";

$section_change = $_POST["section_change"];

$query  = "UPDATE sections SET ":
$query .= "`File Path` = '{$section_change}' ";
$query .= "WHERE id = '{$id}' ";
$query .= "LIMIT 1";
$result = mysqli_query($link, $query);

if ($result && mysqli_affected_rows($link) == 1) {
  // Success
  $_SESSION["message"] = "Section Changed.";
  redirect_to("../index.php?admin=true");
} else {
  // Failure
  echo "System Failure. Please try again later. If problem persists please notify your admin at aqeke.com/powerplaylife-help"
}
}
else {
    print_r( $_POST);

}

Answer 1

试试这个。

你有

1. :代替;
2. 额外的大括号 。您在“系统故障”行末尾缺少一个分号。

以后，您可以使用格式化工具来帮助您快速诊断问题 - http://beta.phpformatter.com/

<?php


if (isset($_POST['submit'])) {
    $id = $_GET["section"];

    $about_me = "../include/about_me.php";

    $providers_2 = "../include/2providers.php";

    $more_providers = "../include/more_proiders.php";

    $section_change = $_POST["section_change"];

    $query = "UPDATE sections SET ";
    $query .= "`File Path` = '{$section_change}' ";
    $query .= "WHERE id = '{$id}' ";
    $query .= "LIMIT 1";
    $result = mysqli_query($link, $query);

    if ($result && mysqli_affected_rows($link) == 1) {
        // Success
        $_SESSION["message"] = "Section Changed.";
        redirect_to("../index.php?admin=true");
    } else {
        // Failure
        echo "System Failure. Please try again later. If problem persists please notify your admin at aqeke.com/powerplaylife-help";
    }
} else {
    print_r($_POST);

}

?>