Fetch data in array format in php & mysql

Question

Fetch the data in array format like :

$value = array ("ABC","XYZ","OPQ");

$query = "SELECT * FROM  designation_master";
$result = mysqli_query($mysqli, $query);
while ($row = mysqli_fetch_array($result)) {
    $designation= $row["designation"]; 
}

Need Result:

$value = array ("ABC","XYZ","OPQ");

I assume since you loop, it should be $designation[] = $row["designation"]; to add the values to the array and not overwrite on each iteration. — Andreas
– Andreas, Commented May 2, 2019 at 12:00
but how to echo in this same format [$value = array ("ABC","XYZ","OPQ");] — Rakesh
– Rakesh, Commented May 2, 2019 at 12:01
You want to echo an array as a string? In what purpose? There are better ways to output arrays. What is the user supposed to use the data as? — Andreas
– Andreas, Commented May 2, 2019 at 12:03
And what's your question? Why not write some code that returns the expected structure? — Nico Haase
– Nico Haase, Commented May 2, 2019 at 12:04
This is a rabbit hole. Think your question through and ask it as clearly as you can. What do you have and what is the end result. Not what you want part way. The end result. — Andreas
– Andreas, Commented May 2, 2019 at 12:07

Qirel · Accepted Answer · 2019-05-02 12:04:40Z

1

Fetch the designation column, and push it into an array with the syntax $array[] = $value.

$designation = [];
$query = "SELECT designation FROM  designation_master";
$result = mysqli_query($mysqli, $query);
while ($row = mysqli_fetch_array($result)) {
    $designation[] = $row["designation"]; 
}
print_r($designation);

answered May 2, 2019 at 12:04

Qirel

26.6k7 gold badges54 silver badges71 bronze badges

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

3 Comments

Rakesh Over a year ago

Thank you @Qirel getting result in following format : Array ( [0] => ABC [1] => XYZ [2] => OPQ) but I want result in same format array ("ABC","XYZ","OPQ");

Qirel Over a year ago

That is the same. When you print it, you show the value of the keys as well, but it is in fact the same. To prove it, see this test: 3v4l.org/GOQSR

Rakesh Over a year ago

Got it, Thank you @Qirel

tiebob · Accepted Answer · 2019-05-02 12:08:52Z

0

if the "ABC","XYZ","OPQ" are the same field [designation], you can convert $designation to array.

$query = "SELECT * FROM  designation_master";
$result = mysqli_query($mysqli, $query);
$designation = array();
while ($row = mysqli_fetch_array($result))
{  
    $designation[] = $row["designation"]; 
}

answered May 2, 2019 at 12:08

tiebob

916 bronze badges

4 Comments

Rakesh Over a year ago

I am trying to print array like print_r($designation); but not getting exact same result

tiebob Over a year ago

array(0=>"ABC", 1=> "XYZ",2=> "OPQ") is same array ("ABC","XYZ","OPQ"). the index is bulit.

Rakesh Over a year ago

how to remove indexing from array and add double quote into it. ?

tiebob Over a year ago

PHP Array always have index, but you can assign custom index name. you don't need quote it, if it is number index, you can access the value with integer or string, like $designation[1] or $designation["1"]. And if you want custom key name, you can set it as the following syntax: $designation['key1"] = "value1";

Collectives™ on Stack Overflow

Fetch data in array format in php & mysql

2 Answers 2

3 Comments

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Related