PHP Fetch all rows from MySQL

Question

I'm trying to fetch all rows for parentId for my form. However my below code isn't able to fetches just 1 record, into my array:

public function getChildByParent($parentId)
{
    $stmt = $this->conn->prepare("SELECT childId, nick, relation FROM childId WHERE parentId = ?");
    $stmt->bind_param("s", $parentId);
    $stmt->execute();
    $stmt->bind_result($childId, $nick, $relation);
    $stmt->fetch();
    $user = array();
    $user['childId'] = $childId;
    $user['nick'] = $nick;
    $user['relation'] = $relation;
    return $user;
}

I understand that I need to tweek around $stmt->fetch() and $user = array() to fetch_all. Can you help me work around this code?

Appreciate your efforts.

Karlo Kokkak · Accepted Answer · 2018-05-07 09:50:06Z

1

Using $stmt->get_result() to setup $result->fetch_all() to get all records in one call.

Try:

public function getChildByParent($parentId)
{
    $stmt = $this->conn->prepare("SELECT childId, nick, relation FROM childId WHERE parentId = ?");
    $stmt->bind_param("i", $parentId);
    $stmt->execute();
    $result = $stmt->get_result();
    $user = $result->fetch_all(MYSQLI_ASSOC);
    $stmt->close();
    return $user;
}

edited May 7, 2018 at 9:50

answered May 7, 2018 at 5:44

Karlo Kokkak

3,7344 gold badges21 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

PHP Fetch all rows from MySQL

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