dongqing483174 2017-03-14 06:19
浏览 45
已采纳

警告:mysqli :: __ construct():MYSQLI PHP [重复]

I am not really familiar with mysqli that much, and I have to upgrade my script to mysqli, please could you help me sort it?

I have this

function getConnected($host,$db_user,$db_password,$db) {

       $mysqli = new mysqli($host, $db_user, $$db_password, $db);

       if($mysqli->connect_error) 
         die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());

       return $mysqli;
    }
    $mysqli = getConnected("localhost", "user_name_data456", "password123456", "user_database456");

and my query

        mysqli_query($mysqli,$sql);
        mysqli_query($mysqli,$sql2);
        mysqli_query($mysqli,$sql3);
        mysqli_query($mysqli,$sql4);
        mysqli_query($mysqli,$sql5);

The queries sql1 - 5 are working fine, it just has some insert things, I know doing more queries on mysql or mysqli isn't recommended, but I am just too tired.

Please help me sort it out. :/

</div>
  • 写回答

1条回答 默认 最新

  • doutu1939 2017-03-14 06:21
    关注

    Change this line

    $mysqli = new mysqli($host, $db_user, $$db_password, $db);
    

    to

    $mysqli = new mysqli($host, $db_user, $db_password, $db);
    

    removed extra $ from db_password variable

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥50 成都蓉城足球俱乐部小程序抢票
  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)
  • ¥15 电力市场出清matlab yalmip kkt 双层优化问题
  • ¥30 ros小车路径规划实现不了,如何解决?(操作系统-ubuntu)
  • ¥20 matlab yalmip kkt 双层优化问题
  • ¥15 如何在3D高斯飞溅的渲染的场景中获得一个可控的旋转物体
  • ¥88 实在没有想法,需要个思路
  • ¥15 MATLAB报错输入参数太多
  • ¥15 python中合并修改日期相同的CSV文件并按照修改日期的名字命名文件