Wrong in a small function [ Php 7_0_0]

Question

function getDisplayName($username) {
    $query = "SELECT `dispname` FROM `accounts` WHERE `username`='slavidodo'";
    $result = mysqli_query($conn, $query);

    $row = mysqli_fetch_assoc($result);
    return $row["dispname"];
}

I tested the codes without using a function and worked fine ( idk why don't work when using function).

Regars Ahmed.

I found the solution. to global $conn. – Slavi Dec 23 '15 at 18:51 — Slavi, Dec 23 '15 at 18:51

score 1 · Answer 1 · answered Dec 23 '15 at 18:51

Because your connection $conn is not available in your function scope. Either use global or pass the connection $conn to your function parameter.

Method(1):

function getDisplayName($username) {
    global $conn;
    $query = "SELECT `dispname` FROM `accounts` WHERE `username`='slavidodo'";
    $result = mysqli_query($conn, $query);

    $row = mysqli_fetch_assoc($result);
    return $row["dispname"];
}

Method(2):

function getDisplayName($username, $conn) {
    $query = "SELECT `dispname` FROM `accounts` WHERE `username`='slavidodo'";
    $result = mysqli_query($conn, $query);

    $row = mysqli_fetch_assoc($result);
    return $row["dispname"];
}

@NanaPartykar Dhanyawad. :) – Rajdeep Paul Dec 23 '15 at 18:52 — Rajdeep Paul, Dec 23 '15 at 18:52

Wrong in a small function [ Php 7_0_0]

1 Answers1