无法使用PHP在MySql上删除

问题描述：

您好我是Php语言的新手。

我有一个简单的MySql删除查询，我想通过PDO在Php（前端）上执行它但是它会抛出以下异常

解析错误：语法错误，第10行的... \ index.php中的意外T_OBJECT_OPERATOR

这是我的代码：

Hi I'm new to Php language.
I have a simple MySql delete query and i want to to execute it on Php(front end) via PDO but it throws the following exception

Parse error: syntax error, unexpected T_OBJECT_OPERATOR in ...\index.php on line 10

Here is my Code:

<?php
	require_once("../config.php");
	include("../header.php");
?>
//connect to database PDO

$conn=new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_DATABASE, DB_USER, DB_PASSWORD);
                 
$sth=conn -> prepare("DELETE FROM `tshuser` WHERE UserID='FindMe'");//line 10
$sth -> execute();
	
 ?>
 
<?php
	include("../footer.php");
?>

答

conn = new PDO（ mysql：host =。DB_HOST。; dbname =。DB_DATABASE，DB_USER，DB_PASSWORD）;

conn=new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_DATABASE, DB_USER, DB_PASSWORD);

sth = conn - > prepare（DELETE FROM`tshuser` WHERE UserID ='FindMe'）; //第10行

sth=conn -> prepare("DELETE FROM `tshuser` WHERE UserID='FindMe'");//line 10

sth - >执行（）;

？>

<？ php
include（ ../ footer.php跨度>）;
？>

sth -> execute(); ?> <?php include("../footer.php"); ?>

无法使用PHP在MySql上删除

相关推荐