PHP MySQL请求错误:分析错误:语法错误，意外'；%'； - PHP MySQL Request Error: Parse error: syntax error, unexpected '%'

PHP MySQL Request Error: Parse error: syntax error, unexpected '%'

本文关键字：错误意外 MySQL 请求 PHP 语法 | 更新日期: 2023-09-27

我有一个关于我的PHP代码的查询：

$result = mysqli_query($con,"UPDATE operasyonkayitlari SET tarihgun=FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-28800, "%Y.%m.%d"), tezgah='".$_REQUEST['tezgah']."', operatoradi='".$_REQUEST['operator']."', ayarepoch=UNIX_TIMESTAMP(NOW()), durum='AYARDA' where isemri='".$_REQUEST['isemri']."' and operasyonno='".$_REQUEST['operasyonno']."'");

仔细看一下：

FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-28800, "%Y.%m.%d")

带有%符号的字符出现以下语法错误：

Parse error: syntax error, unexpected '%' in C:'wamp'www'ayarabasla.php on line 4

我是如何用%符号编写查询的？

语法高亮显示您的错误。这是一个报价问题。逃离你内心的双引号：

$result = mysqli_query($con,"UPDATE operasyonkayitlari SET tarihgun=FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-28800, '"%Y.%m.%d'"), tezgah='".$_REQUEST['tezgah']."', operatoradi='".$_REQUEST['operator']."', ayarepoch=UNIX_TIMESTAMP(NOW()), durum='AYARDA' where isemri='".$_REQUEST['isemri']."' and operasyonno='".$_REQUEST['operasyonno']."'");

你也可以使用单引号：

$result = mysqli_query($con,"UPDATE operasyonkayitlari SET tarihgun=FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-28800, '%Y.%m.%d'), tezgah='".$_REQUEST['tezgah']."', operatoradi='".$_REQUEST['operator']."', ayarepoch=UNIX_TIMESTAMP(NOW()), durum='AYARDA' where isemri='".$_REQUEST['isemri']."' and operasyonno='".$_REQUEST['operasyonno']."'");