语法错误意外的'from'(t\u string)

ezykj2lf 于 2021-06-21 发布在 Mysql

关注(0)|答案(2)|浏览(320)

这个问题在这里已经有答案了：

分析错误：语法错误，意外的'from'（t\u string）[关闭]（2个答案）
php解析/语法错误；以及如何解决这些问题（18个答案）
两年前关门了。
我是php和mysql的初学者，不知道怎么了。第8行显示错误：

syntax error unexpected 'FROM' (T_STRING)

代码如下：

<?php
require "conn.php";

$category = $_POST["category"];
$fruit = $_POST["fruit"];
$cost = $_POST["cost"];

DELETE FROM `Temptable` WHERE image_path = "";
UPDATE Temptable SET (`category`, `fruit`, `cost`) VALUES ('$category','$fruit','$cost');
$mysql_qry = "INSERT INTO Datatable (`category`, `fruit`, `cost`) SELECT `categrory`, `fruit`, `cost` FROM `Temptable` WHERE `id` >= '1'";

if($Datatable->query($mysql_qry) === true) {
	echo "Successful";
}
else {
	echo "Error: " . $mysql_qry . "<br>" . $Datatable->error;
}
$Datatable->close();
$Temptable->close();
?>

mysql php syntax

来源：https://stackoverflow.com/questions/48355291/syntax-error-unexpected-from-t-string

2条答案

按热度按时间

7y4bm7vi1#

生成错误的原因很简单，因为您将mysql查询直接放入php代码中，php无法理解这些代码。你应该把 DELETE 以及 UPDATE 语句作为字符串变量 INSERT 声明

<?php
require "conn.php";

$category = $_POST["category"];
$fruit = $_POST["fruit"];
$cost = $_POST["cost"];

$delete_query = "DELETE FROM `Temptable` WHERE image_path = ''";
$update_query = "UPDATE Temptable SET (`category`, `fruit`, `cost`) VALUES ('$category','$fruit','$cost')";
$mysql_qry = "INSERT INTO Datatable (`category`, `fruit`, `cost`) SELECT `categrory`, `fruit`, `cost` FROM `Temptable` WHERE `id` >= '1'";

if($Datatable->query($mysql_qry) === true) {
    echo "Successful";
}
else {
    echo "Error: " . $mysql_qry . "<br>" . $Datatable->error;
}

$Datatable->close();
$Temptable->close();
?>

赞(0）回复(0）举报 2021-06-21

rkkpypqq2#

这个 delete 以及 update 语句需要被注解掉，或者作为变量正确地创建—因为这些字符串，您得到了一个错误

<?php
    require "conn.php";

    $category = $_POST["category"];
    $fruit = $_POST["fruit"];
    $cost = $_POST["cost"];

    #DELETE FROM `Temptable` WHERE image_path = "";
    #UPDATE Temptable SET (`category`, `fruit`, `cost`) VALUES ('$category','$fruit','$cost');
    $mysql_qry = "INSERT INTO Datatable (`category`, `fruit`, `cost`) SELECT `categrory`, `fruit`, `cost` FROM `Temptable` WHERE `id` >= '1'";

    if($Datatable->query($mysql_qry) === true) {
        echo "Successful";
    }
    else {
        echo "Error: " . $mysql_qry . "<br>" . $Datatable->error;
    }
    $Datatable->close();
    $Temptable->close();
?>

赞(0）回复(0）举报 2021-06-21

我来回答

语法错误意外的'from'(t\u string)

2条答案

相关问题

热门标签

最新问答