mysqli query result is displayed as"Array" in php. How to retrieve the individual values from it?

Question

Below is my code to retrieve the column names from the table "COLUMNS" of database "INFORMATION_SCHEMA".

$result = mysqli_query($con,"SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CustomersTable'") or die(mysqli_error($con));

$columns = $result;
foreach ($columns as $column){
  echo $column;
}

what I get echoed is ArrayArrayArrayArrayArrayArrayArrayArray. However, if I write

mysqli_fetch_assoc($result);

instead of

$columns = $result;

then I get only the first value of the array echoed.

How do I get all the values echoed as I expect it to be?

BenM · Accepted Answer · 2017-08-19 07:39:51Z

2

You need to use mysqli_fetch_assoc inside of a while() loop:

$result = mysqli_query($con,"SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CustomersTable'") or die(mysqli_error($con));

while( $row = mysqli_fetch_assoc($result))
{
    // $row now contains an array with the `COLUMN_NAME` inside.
}

answered Aug 19, 2017 at 7:39

BenM

53.3k26 gold badges116 silver badges172 bronze badges

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

Comments

Death-is-the-real-truth · Accepted Answer · 2017-08-19 07:45:55Z

1

Use while() loop along with mysqli_fetch_assoc:-

$result = mysqli_query($con,"SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CustomersTable'") or die(mysqli_error($con));

while($row = mysqli_fetch_assoc($result)){
  print_r($row);//array contains `COLUMN_NAME`.
  //based on printed value you can get how to do echo easily
}

edited Aug 19, 2017 at 7:45

answered Aug 19, 2017 at 7:38

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

1 Comment

Neo Over a year ago

Upvoted all answers, but accepting this one as it caught me first and explained sufficient for me. Thanks @Alive to Die.

Bhargav Chudasama · Accepted Answer · 2017-08-19 07:40:00Z

1

using loop you can access all values

 $result = mysqli_query($con,"SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CustomersTable'") or die(mysqli_error($con));

 while($row=mysqli_fetch_assoc($result){
        print_r($row);
 }

answered Aug 19, 2017 at 7:40

Bhargav Chudasama

7,2336 gold badges24 silver badges41 bronze badges

Comments

Milan Chheda · Accepted Answer · 2017-08-19 07:44:21Z

1

To get all the values echo'ed, you need to use while() loop with mysqli_fetch_assoc()

$result = mysqli_query($con,"SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CustomersTable'") or die(mysqli_error($con));
while($rows = mysqli_fetch_assoc($result)) {
    print_r($rows); // this contains all the necessary data that you are looking for...
}

Here is reference to mysqli_fetch_assoc()

edited Aug 19, 2017 at 7:44

answered Aug 19, 2017 at 7:38

Milan Chheda

8,2593 gold badges23 silver badges35 bronze badges

Collectives™ on Stack Overflow

mysqli query result is displayed as"Array" in php. How to retrieve the individual values from it?

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related