首页 > 代码库 > 解决mysql的错误 CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1300 Invalid utf8 character string: '\xBF\xA5'

解决mysql的错误 CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1300 Invalid utf8 character string: '\xBF\xA5'

2024-10-22 15:10:39   211人阅读

 

报错：

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1300 Invalid utf8 character string: ‘\xBF\xA5‘

解决方法：

$currentPrice = $currentPrice  * 1;  

=> $currentPrice 原本是字符串的 数字，导致插入数据库失败。

=》所以只要改成  数字 即可。

=》字符串的 数字 ，乘以 1 就会变成 数字类型。 


但是有报告了一个Php的错误：

Internal Server Error

Division by zero

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

 先打开错误信息验证：
 
ini_set(‘display_errors‘,‘on‘);
error_reporting(E_ALL);



 

解决mysql的错误 CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1300 Invalid utf8 character string: '\xBF\xA5'


联系
我们