Function returns boolean not string

Question

What I want is to return MYSQL query in a array however my code returns a bool(true).
Here is the code from code.php

require('model.php');

$id = $_POST['id'];
$password = $_POST['password'];

$user = new user();

$row = $user->check_user($id, $password);
var_dump($row);

Here is the code from model.php

class config {

    public $dbhost = "localhost";
    public $dbuser = "root";
    public $dbpass = "";
    public $dbused = "dbname";

    function dbconn() {

        $conn = mysqli_connect($this->dbhost,$this->dbuser,$this->dbpass,$this->dbused);

        if(mysqli_connect_errno()) {

            printf("Connection failed: " . mysqli_connect_error());
            exit();

        }

        return $conn;

    }

}

class user {

    function check_user($id, $pass) {

        $config = new config();

        $conn = $config->dbconn();

        $query = $conn->prepare("SELECT id, password, status FROM e_users WHERE id = ? AND password = ?");

            $query->bind_param('is', $id, $pass);

            try {

                $query->execute();

                return $query->fetch();

            } catch(PDOException $e) {

                die($e->getMessage());

            }

    }

}

I think the problem is in the $query->fetch(); because I tried return 'test'; and it works fine. Even return an array works fine.

Can anyone help me?

return $query->fetch(); will simply return true if the fetch operation was successful and false if it wasn't. It doesn't return the data you requested. — The Blue Dog
– The Blue Dog, Commented Aug 15, 2014 at 15:35
return $query->fetch_assoc(); as per the answer posted by @peter_the_oak below. — The Blue Dog
– The Blue Dog, Commented Aug 15, 2014 at 15:51

peter_the_oak · Accepted Answer · 2014-08-15 22:39:51Z

1

As The Blue Dog pointed out, fetch() returns a status flag, not the row itself. But fetch_assoc() will return a row.

Have a look here:

http://php.net/manual/en/mysqli-stmt.fetch.php

If you work with fetch, you need to bind the variables:

$stmt->bind_result($mySelectedValue_1, $mySelectedValue_2);

Here are examples with fetch_assoc():

http://php.net/manual/de/mysqli.quickstart.prepared-statements.php

So this should work fine:

$row = $res->fetch_assoc();

edited Aug 15, 2014 at 22:39

answered Aug 15, 2014 at 15:42

peter_the_oak

3,7405 gold badges28 silver badges41 bronze badges

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

2 Comments

Wow Over a year ago

peter_the_oak and @The Blue Dog thanks for the info guys, it is now working like what i wanted.If i could i would you all a big hug :))

peter_the_oak Over a year ago

Glad to help. So it's a distributed, or virtual hug ;-)

Collectives™ on Stack Overflow

Function returns boolean not string

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related