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

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

报告相同问题?

悬赏问题

  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号
  • ¥15 基于单片机的靶位控制系统
  • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度
  • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测