douhuang75397 2018-01-31 15:49 采纳率: 0%
浏览 73
已采纳

我的任务是关于与xampp服务器的PHP连接,它没有连接并给我erroe [关闭]

Kindly show me the error in my code i am trying to connect the sign in form with database using php but i am getting these errors:

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\MyProject\php\signin.php on line 9

Notice: Trying to get property of non-object in C:\xampp\htdocs\MyProject\php\signin.php on line 11

Fatal error: Uncaught Error: Call to a member function query() on boolean in C:\xampp\htdocs\MyProject\php\signin.php:17 Stack trace: #0 {main} thrown in C:\xampp\htdocs\MyProject\php\signin.php on line 17

<?php

$servername = "localhost";
$username = "root";
$password="";
$dbname = "myproject";

// Create connection
$conn = mysqli_connect($servername,$username,$password,$dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "INSERT INTO sign_in (username,password)";

if ($conn->query($sql) === TRUE) {
    echo "New record inserted successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}


$conn->close();

?>
  • 写回答

3条回答 默认 最新

  • dougou1943 2018-01-31 16:02
    关注

    You are getting this ERROR because of your is mixed up with mysqli_* functions and PDO code.

    Methods of both PDO connection and mysqli_* are different.

    Here is your error. ******Here is your error*****

    $sql = "INSERT INTO sign_in (username,password)";
    
    if ($conn->query($sql) === TRUE) { //ERROR line
        echo "New record inserted successfully";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
    

    You have use function mysqli_query() instead of accessing member function of $conn, just take below correct example.

    // Perform queries 
    mysqli_query($conn,"SELECT * FROM Persons");
    mysqli_query($conn,"INSERT INTO Persons (FirstName,LastName,Age) VALUES ('Glenn','Quagmire',33)");
    
    mysqli_close($conn);
    

    Hope you get the point and will help you..

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 MATLAB怎么通过柱坐标变换画开口是圆形的旋转抛物面?
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿