PHP bind_result and fetch multiple rows (array)

Question

I'm fairly new to php and mysql. I'm trying to create a rest api from php, and because my server doesn't have mysqlndinstalled, I have to use bind_result and fetch.

$stmt = $this->conn->prepare("SELECT * from d WHERE d.id = ?");
$stmt->bind_param("i", 1);
if($stmt->execute()){
    $stmt->bind_result($a, $b, $c);
    $detail = array();  
    while($stmt->fetch()){      

        $detail["a"] = $a;
        $detail["b"] = $b;
        $detail["c"] = $c;
    }

    $stmt->close();
    return $response;
} else {
    return NULL;
}

Above code works but it can only return 1 line of information at a time.

For example if the statement return:

a    b    c
1   test  test
1   test1 test1

it only returns

a: 1
b: test1
c: test1

where its supposed to be:

{
    a: 1
    b: test
    c: test
},
{
    a: 1
    b: test1
    c: test1
}

You're replacing $detail on every iteration of the while loop. You need to append via $detail[]["a"] = $a and so on. — Dave Chen
– Dave Chen, Commented Oct 19, 2014 at 4:45
Are you on shared webhosting or your own box? Is there a way to install mysqlnd? — DarthCaniac
– DarthCaniac, Commented Oct 19, 2014 at 4:47

Kevin · Accepted Answer · 2014-10-19 04:53:17Z

1

You're overwritting them, you could do something like this instead:

$detail = array();  
while($stmt->fetch())
{           
    $temp = array():
    $temp["a"] = $a;
    $temp["b"] = $b;
    $temp["c"] = $c;
    $detail[] = $temp;
}

Or directly appending them with another dimension:

$detail = array();  
while($stmt->fetch()) {           
    $detail[] = array('a' => $a, 'b' => $b, 'c' => $c);
      //   ^ add another dimension
}

answered Oct 19, 2014 at 4:53

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

PHP bind_result and fetch multiple rows (array)

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