Display Array Values from SQL Table Rows

Question

categoryID
   10
   20
   30

For example. Above is my categoryID column with values of 10, 20, and 30 PHP MySQL. What I want to do is to echo those values using an array. Like -> 10 20 30. Below is my code. In my code. I just stored all row data from categoryID into my $array variable. My concern is. How do I echo all the values?

Thank you for the help!

<?php
include ("dbconnect.php");

$sql = "SELECT categoryID FROM post";
$result = mysqli_query($con, $sql);

$array = array();

while($row = mysqli_fetch_assoc($result)) {
   $array[] = $row;
}

?>

Rakesh Jakhar · Accepted Answer · 2019-03-09 05:31:59Z

1

Use $array variable as below:-

$array[] = $row['categoryID'];

and to print the array try:-

print_r($array);

and to print them as 10 20 30 try the following:-

echo implode(' ',$array);

answered Mar 9, 2019 at 5:31

Rakesh Jakhar

6,4082 gold badges13 silver badges20 bronze badges

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

Comments

Nancy Moore · Accepted Answer · 2019-03-09 07:32:59Z

0

The best way is to use json_encode() function

echo json_encode($array);

so try this

<?php
include ("dbconnect.php");

$sql = "SELECT categoryID FROM post";
$result = mysqli_query($con, $sql);

$array = array();

while($row = mysqli_fetch_assoc($result)) {
   $array[] = $row;
}


    echo json_encode($array);
    exit;

?>

answered Mar 9, 2019 at 7:32

Nancy Moore

2,4964 gold badges28 silver badges50 bronze badges

Collectives™ on Stack Overflow

Display Array Values from SQL Table Rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related