fetch SQLdata without column name in php

Question

please tell me how to fetch data from MySql database in below format.

Now, i am getting data in below format

$sql="SELECT c.ad_id FROM `category_rel` c INNER JOIN tbl_category_master d ON c.category_id= d.fld_category_id WHERE d.fld_category_name IN ($category)";
$result1=$con->query($sql);
while ($row = mysqli_fetch_assoc($result1)) {
    $output[] = $row;
       }
$ids=json_encode(array($output));

Result:
[[{"ad_id":"2"},{"ad_id":"11"},{"ad_id":"28"},{"ad_id":"62"},{"ad_id":"64"}]]

But, I want in the below format:

["2","11","28","62"]

it should not come with the column name.

Jean-Luc Barat · Accepted Answer · 2016-05-07 09:42:51Z

2

Try $output[] = $row['ad_id']; instead of $output[] = $row;

[Edit] Also remove array() function :

$sql="SELECT c.ad_id FROM `category_rel` c INNER JOIN tbl_category_master d ON c.category_id= d.fld_category_id WHERE d.fld_category_name IN ($category)";
$result1=$con->query($sql);
while ($row = mysqli_fetch_assoc($result1)) {
    $output[] = $row['ad_id'];
       }
$ids=json_encode($output);

Regards.

edited May 7, 2016 at 9:42

answered May 7, 2016 at 9:16

Jean-Luc Barat

1,16511 silver badges19 bronze badges

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

4 Comments

Murad Hasan Over a year ago

She faced the data as assoc.

Jean-Luc Barat Over a year ago

I update the post as I don't see you use mysql_fetch_assoc, have you try ?

Priyanka Over a year ago

Sir, this is not implode. It show invalid argument. @Jean-Luc B.

Jean-Luc Barat Over a year ago

Can you explain ? Does ad_id can be null ? result empty ? In this case add $output = array(), before while loop, it's good practice to init your vars even if php is permissive.

Murad Hasan · Accepted Answer · 2016-05-07 09:21:25Z

0

If you want to do it from while loop then use it:

$sql="SELECT c.ad_id FROM `category_rel` c INNER JOIN tbl_category_master d ON c.category_id= d.fld_category_id WHERE d.fld_category_name IN ($category)";
while ($row = mysqli_fetch_assoc($result1)) {
    $output[] = $row['ad_id']; //may be this will help Not sure the structure
}
$ids = json_encode(array($output));

If you need it from the output array then just use this:

$json = '[[{"ad_id":"2"},{"ad_id":"11"},{"ad_id":"28"},{"ad_id":"62"},{"ad_id":"64"}]]';

$arr = json_decode($json, true);


$arr = array_column($arr[0], 'ad_id');

echo '<pre>';
print_r($arr);

Result:

Array
(
    [0] => 2
    [1] => 11
    [2] => 28
    [3] => 62
    [4] => 64
)

edited May 7, 2016 at 9:21

answered May 7, 2016 at 9:16

Murad Hasan

9,5932 gold badges23 silver badges43 bronze badges

2 Comments

Priyanka Over a year ago

Its works but not me ..I want in ['2', '11', '28', '62','64'] this format ... Because i need to use these values in next SQl Statement under IN clause.

Murad Hasan Over a year ago

so you can use the implode function. As you already accept other answer so best of luck.

Collectives™ on Stack Overflow

fetch SQLdata without column name in php

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related