Storing db value into php array with while loop?

Question

I am wanting to search through AdvInfo table and store the primary keys if Unit = Child.

 $result = mysqli_query($conn, "SELECT * FROM AdvInfo WHERE Unit = Child");     
 while ($row = mysqli_fetch_array($result, SQLSRV_FETCH_ASSOC))
 {

$childhbc = array_merge($childhbc, $row[0]);
echo $childhbc[0];
 }

can you echoing your select query ?

VIVEK-MDU
– VIVEK-MDU

2013-08-16 19:05:59 +00:00
Commented Aug 16, 2013 at 19:05 — VIVEK-MDU
– VIVEK-MDU, Commented Aug 16, 2013 at 19:05
No. echoing $childhbc also returns nothing

Erkdance
– Erkdance

2013-08-16 19:21:13 +00:00
Commented Aug 16, 2013 at 19:21 — Erkdance
– Erkdance, Commented Aug 16, 2013 at 19:21

Community · Accepted Answer · 2023-11-17 19:42:58Z

1

The second argument to array_merge should be an array. But to quote the documentation:

mysqli_fetch_array [...] returns an array of strings that corresponds to the fetched row or NULL if there are no more rows in resultset.

In your code, $row is an array. $row[0] is a string.

while ($row = mysqli_fetch_array($result, SQLSRV_FETCH_ASSOC))
{
    $childhbc = array_merge($childhbc, $row);
    echo $childhbc[0];
}

edited Nov 17, 2023 at 19:42

CommunityBot

11 silver badge

answered Aug 16, 2013 at 20:11

Sylvain Leroux

52.3k8 gold badges114 silver badges136 bronze badges

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

Comments

Your Common Sense · Accepted Answer · 2013-08-16 20:35:26Z

1

Keep it simple, man

$childhbc = array();
$result = mysqli_query($conn, "SELECT * FROM AdvInfo WHERE Unit = Child");     
while ($row = mysqli_fetch_row($result))
{
    $childhbc[] = $row[0];
}

The less intricate words you use - the better your program works

edited Aug 16, 2013 at 20:35

answered Aug 16, 2013 at 20:21

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Collectives™ on Stack Overflow

Storing db value into php array with while loop?

2 Answers 2

Comments

Comments

Hot Network Questions