mysqli database functions set up

Question

I've been trying to write a function to draw a usernames name from the database fetch he result then return it back to the parent page but nothing I have tried works and I don't even know where to go from here. my old code that I used mysql on works perfect and was easy to put together but this mysqli and all its double parameters and stuff I cant figure it out. so basically I am asking for anyone who knows how to set one of these up.

(SELECT name FROM users WHERE username = '" .$_SESSION['username']. "')

I want to mysqli_real_escape the value if possible so if anyone knows how to set up a function to return a value back to its parent page I would much appreciate it.

user4035 · Accepted Answer · 2014-01-13 09:36:26Z

1

It's very similar to using mysql_* functions:

function get_user_name()
{
    global $conn;

    $sql = "SELECT name FROM users WHERE username = ?";
    if ($stmt = $conn->prepare($sql)) {

        $stmt->bind_param("s", $_SESSION['username']);
        $stmt->execute();
        $result = $stmt->get_result();
        $data = mysqli_fetch_assoc($result);

        return $data['name'];
    }   
}

answered Jan 13, 2014 at 9:36

user4035

24k11 gold badges69 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysqli database functions set up

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related