doupingzhi9674
2016-04-20 15:12
浏览 113
已采纳

致命错误:在整数上调用成员函数prepare()

I'm working on a website; apache asks me to upgrade to the new method of PDO.

I have my function which will collect all the information of user X, indicated by the variable $_SESSION['username'].

My problem is: I get the error title. However I want to collect String and INT values.

My Function: functions.php

function getDetails($username) {
    $db = require("dbConn.php");
    $sql = $db->prepare("SELECT * FROM `es42_members` WHERE HandleName='$username'");
    $sql->execute();
    $row = $sql->fetchAll();

    return $row;
}

My index file: index.php

$details = getDetails($_SESSION['username']);

while ($row = $details->fetch_assoc())  {
    $id = $row['UserID'];
    $email = $row['Email']; // This return String
    $isAdmin = $row['isAdmin']; //This return 0 - 1. But in the table is registered by String (Varchar).
}

echo "Your email is: $email";
if($isAdmin == "1"){ echo "You are a admin!" }

UPDATE My new code is as follows:

Function: @Marcus

function getDetails($username) {
    require("dbConn.php");
    $sql = $db->prepare("SELECT * FROM `es42_members` WHERE HandleName='$username'");
    $sql->execute();
    $row = $sql->fetchAll();

    return $row;
}

dbConn.php [Original]

<?php 

$db = new PDO('mysql:host=localhost;dbname=ProfileTest', "root", "1234");
$db = null;

?>

dbConn.php [Edited and working]

<?php 

$db = new PDO('mysql:host=localhost;dbname=ProfileTest', "root", "1234");

?>
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

2条回答 默认 最新

  • dt2002 2016-04-20 15:21
    最佳回答

    This is happening because $db isn't actually holding the PDO connection object. You've assigned the dbConn.php script itself (returns 1 on successful inclusion) to $db, which is why you're receiving the integer error in question.

    Your dbConn.php file should look something like the following (please add dbConn.php to your original post for verification):

    // dbConn.php
    $db = new PDO($dsn, $user, $password); // PDO has been instantiated and $db is holding the object
    

    Then in your functions.php script:

    function getDetails($username) {
        require("dbConn.php"); // require me, don't assign me to a variable
        $sql = $db->prepare("SELECT * FROM `es42_members` WHERE HandleName='$username'");
        $sql->execute();
        $row = $sql->fetchAll();
    
        return $row;
    }
    

    You'd simply require dbConn.php and NOT assign it to any variable.

    评论
    解决 无用
    打赏 举报
查看更多回答(1条)

相关推荐 更多相似问题