How to solve the garbled problem of php ajax post-PHP Problem-php.cn

How to solve the garbled problem of php ajax post

藏色散人

Release： 2023-03-06 15:36:01

Original

1561 people have browsed it

php The solution to the garbled ajax post: first open the corresponding PHP file; then set the contentType; then set the encoding format of the page; and finally convert the SQL server database encoding.

How to solve the garbled problem of php ajax post

Recommended: "PHP Video Tutorial"

ajax php POST method to send data (solve the backend Chinese garbled characters problem)

The front-end Ajax calls the interface, and the back-end receives the data and saves it in the database.

Note that contentType must be set like this.

if(isSuccess){
              
               var token = sessionStorage.token;
               $.ajax({
                   type:&#39;post&#39;,
                   url:&#39;../../api/container/&#39;+token+&#39;/addContainerDamageReport&#39;,
                   contentType:&#39;application/x-www-form-urlencoded;charset=utf-8&#39;,
                   data:{&#39;containerName&#39;:&#39;HJSY&#39;+containerName,&#39;username&#39;:username,&#39;description&#39;:descript,&#39;damageTime&#39;:damageTime
                        ,&#39;reportTime&#39;:reportTime,&#39;damageLevel&#39;:badLevel,&#39;damageType&#39;:badType},
                   cache:false,
                   dataType:&#39;json&#39;,
                   success:function(data){
                    $(&#39;#submit&#39;).attr(&#39;data-dismiss&#39;,"modal");
                        console.log(data)
                   }
               })
           }

Copy after login

The backend accepts:

The encoding format of the page is utf-8, and the SQL server database is gbk. Pay attention to the conversion, otherwise the insertion will be garbled.

if($action==&#39;addContainerDamageReport&#39;)
{
$ret["IsInsert"]=false;
if($conn!=false)
{
$containerName = isset($_POST[&#39;containerName&#39;])?$_POST[&#39;containerName&#39;]:"";
$username = isset($_POST[&#39;username&#39;])?$_POST[&#39;username&#39;]:"";
$description = isset($_POST[&#39;description&#39;])?iconv("utf-8","gbk",$_POST[&#39;description&#39;]):"";
$damageTime = isset($_POST[&#39;damageTime&#39;])?$_POST[&#39;damageTime&#39;]:"";
$reportTime = isset($_POST[&#39;reportTime&#39;])?$_POST[&#39;reportTime&#39;]:"";
$damageLevel = isset($_POST[&#39;damageLevel&#39;])?$_POST[&#39;damageLevel&#39;]:"";
$damageType = isset($_POST[&#39;damageType&#39;])?$_POST[&#39;damageType&#39;]:"";
$SqlString="INSERT INTO [Mopex].[dbo].[ContainerDamageReport]
([Id],[ContainerName],[DamageTime],[ReportTime]
,[DamageLevel],[CheckName],[DamageType],[Description]
,[ReportName],[Status],[CheckTime])
values(newId(),&#39;".$containerName."&#39;,&#39;".$damageTime."&#39;,&#39;".$reportTime."&#39;,
&#39;".$damageLevel."&#39;,&#39;admin&#39;,&#39;".$damageType."&#39;,&#39;".$description."&#39;,&#39;".$username."&#39;,
0,&#39;1900-01-01 00:00:00.0000000&#39;)";
OpenDB($conn,$databasename);
$rs_insert = DB_Query($conn,$SqlString);
if($rs_insert != false)
{
$ret["IsInsert"]=true;
$DataList[0]=array(&#39;containerName&#39;=>$containerName,&#39;username&#39;=>$username,
&#39;damageTime&#39;=>$damageTime,&#39;reportTime&#39;=>$reportTime,&#39;damageLevel&#39;=>$damageLevel,&#39;damageType&#39;=>$damageType,
&#39;description&#39;=>$description,&#39;status&#39;=>&#39;0&#39;);
}
DB_Close($conn);
}
}

Copy after login

The above is the detailed content of How to solve the garbled problem of php ajax post. For more information, please follow other related articles on the PHP Chinese website!