php - 无法执行 sql 查询(mysql、php)

Question

与数据库的连接有效，但 sql 查询失败(我尝试了很多变体但没有成功)。如有帮助，将不胜感激。这是我的代码:

$con = mysqli_connect("127.0.0.1:3306","root","*****","bsr");
            if(! $con )
                {
                  die('Could not connect: ' . mysql_error());
                }
            $query = "INSERT INTO eden (username,password) VALUES ('aaa', 'ddd')";
            $retval = mysqli_query($con,$query);
            if(! $retval )
                {
                  die('Could not enter data: ' . mysql_error());
                }

结果:“无法输入数据:”

Answer 1

试试这个:

$query = "INSERT INTO eden (username,password) VALUES ('aaa', 'ddd')";
$retval = $con -> query($query);

if(! $retval ){
    die('Could not enter data: ' . mysql_error());
}