在php函数中返回一个数组

Question

I have following code to retrieve information of user:

function getUserProfile($id) {              
            $sql_query_profile="SELECT * FROM users WHERE id=$id";
            $user_profile=@mysqli_query($dbconfig,$sql_query_profile);
            $user_details_profile=@mysqli_fetch_array($user_profile,MYSQLI_ASSOC);
            return $user_details_profile;
        }

when I call this function, it returns null value.

$user= getUserProfile($_POST['txt_id']);
    var_dump ($user);

can anybody suggest the better idea please?

Answer 1

you are trying to access $dbconfig in function which is global variable. To access global variables use global keyword in function or pass config variable to function itself.

function getUserProfile($id) {  
            global $dbconfig;            
            $sql_query_profile="SELECT * FROM users WHERE id=$id";
            $user_profile=@mysqli_query($dbconfig,$sql_query_profile);
            $user_details_profile=@mysqli_fetch_array($user_profile,MYSQLI_ASSOC);
            return $user_details_profile;
        }

don't use '@' handle as @Epodax suggest, Do not use @ handle your errors instead of suppressing them, debugging is impossible when using @ and we will be unable to help you until you correct this.