PHP写入数据mysql总是失败

Question

GET用php写入mysql数据

<?php
header('Content-type:text/html;charset=utf-8');
$openid = $_GET['openid'];
$name = $_GET['name'];
$yuanyin = $_GET['yuanyin'];
$fkid = 'D'. date('Ymd').substr(implode(NULL, array_map('ord', str_split(substr(uniqid(), 7, 13), 1))), 0, 11);
$shijian = $_GET['shijian'];
$zhuan = $_GET['chepai'];
$chepai=strtoupper($zhuan);
$jname = $_GET['jname'];
$shouji = $_GET['shouji'];
$wendu = $_GET['wendu'];
$hesuan = $_GET['hesuan'];
$bidui = $_GET['bidui'];
//连接数据库
$con = new mysqli("localhost","jinchu_co","xXmWAf44","jinchu_co");

//定义sql语句
$sql = "INSERT INTO aa_fangke(openid,name,yuanyin,fkid,shijian,chepai,jname,shouji,wendu,hesuan,bidui) VALUES('$openid','$name','$yuanyin','$fkid','$shijian','$chepai','$jname','$shouji','$wendu','$hesuan','$bidui')";

$res = mysqli_query($con,$sql);
if($res){
    $arr['status'] = 1;
    $arr['info'] = '提交成功';
}else{
    $arr['status'] = 0;
    $arr['info'] = '提交失败';
}
echo json_encode($arr);
die;

怎么写入都是失败，就是不知道什么原因。

Answer 1

不知道你这个问题是否已经解决, 如果还没有解决的话:

• 建议你看下这篇博客👉 ：PHP连接MYSQL8失败的解决方法

如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 写成博客, 将相关链接放在评论区, 以帮助更多的人 ^-^