加入表时phpmyadmin的错误（typeError：htmlspecialchars（）：参数＃1（$ string）必须是类型字符串，null给出）
我一直在尝试加入两个表，其中（ON）条件列可能包含空值。 我一直在php myadmin中遇到以下PHP错误：
TypeError: htmlspecialchars(): Argument #1 ($string) must be of type string,
null given in C:\xampp\phpMyAdmin\libraries\classes\Display\Results.php on line 2012
经过大量的调查，事实证明 phpmyadmin版本（5.1.1）与 php版本不兼容（8.0.13 ）
遵循此链接以将phpmyadmin升级到最新（5.2.0），该错误没有再次出现，我能够成功地运行我的查询。
也是我的查询也就是我的查询。
SELECT * from table uc
LEFT JOIN table u
on u.id <=> uc.user_id
I have been trying to join two tables where the (on) condition column may contain null value.
I kept getting this following php error in php myadmin:
TypeError: htmlspecialchars(): Argument #1 ($string) must be of type string,
null given in C:\xampp\phpMyAdmin\libraries\classes\Display\Results.php on line 2012
After a lot of investigtation, it turned out that the phpMyAdmin version (5.1.1) was not compatible with the PHP version (8.0.13)
Following this link to upgrade the phpMyAdmin to latest (5.2.0) the error did not appear again and I was able to run my query successfully.
Updating phpmyadmin in xampp server
Also here is my query just FYI
SELECT * from table uc
LEFT JOIN table u
on u.id <=> uc.user_id
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
经过大量的调查后，事实证明， phpmyadmin 版本（5.1.1）与
此链接以升级 php 版本（8.0.13）不兼容phpmyadmin到最新（5.2.0）该错误没有再次出现，我能够成功地运行我的查询。
在XAMPP服务器中更新phpmyadmin
After a lot of investigtation, it turned out that the phpMyAdmin version (5.1.1) was not compatible with the PHP version (8.0.13)
Following this link to upgrade the phpMyAdmin to latest (5.2.0) the error did not appear again and I was able to run my query successfully.
Updating phpmyadmin in xampp server