Codeigniter return mysql query result to single array

Question

I have code like this

$mene   = date('Y-m-d h:i:s', strtotime('+1 days'));
$now    = date('Y-m-d h:i:s');
$qnow   = $this->db->query("SELECT pilihan,COUNT(pilihan) as total FROM votes WHERE date_create BETWEEN '$now' AND '$mene' GROUP BY pilihan");

$someArray = [];
foreach($qnow->result_array() as $row){
    array_push($someArray, [
    $row['pilihan']   => $row['total']
    ]);
}

$someJSON = json_encode($someArray);
echo $someJSON;

And this for result

[
  {
    "1": "213"
  },
  {
    "2": "444"
  }
]

How to make this result to single array, so result will be

[
  {
    "1": "213",
    "2": "444"
  }
]

Please help to resolve that, Thank you.

WARNING: This code has some SQL injection bugs because user data is not escaped before being used in the query. Read up on how to use query bindings with placeholder values so that data can be properly encoded before being used in the query. Even if the values used here seem harmless, they could be replaced at a later time with those that aren't, creating a hidden, exploitable hole. — tadman
– tadman, Commented Nov 10, 2017 at 17:13
@tadman - I don't see any unescaped user input in his query. — shaggy
– shaggy, Commented Nov 10, 2017 at 22:18
@shaggy $now is interpolated, and although in this contrived example it's not user data, all it takes is switching that with $now = $_GET['date'] and you're in deep trouble. Sometimes these variables are defined in distant parts of the system and passed in so it's never obvious what is or isn't safe. That's why using placeholder values for everything, regardless of origin, is important. — tadman
– tadman, Commented Nov 13, 2017 at 0:19
@tadman - yes and if you switch echo $someJSON; to echo $config['db']['password']; you get in trouble too. So there are no SQL injection bugs. There might be, if he change the code. — shaggy
– shaggy, Commented Nov 13, 2017 at 9:17

Yahya Hussein · Accepted Answer · 2017-11-10 20:39:30Z

1

Inside foreach loop try replacing the below code:

array_push($someArray, [$row['pilihan']   => $row['total']]);

to:

$someArray[$row['pilihan']] = $row['total'];

edited Nov 10, 2017 at 20:39

Yahya Hussein

9,16717 gold badges73 silver badges119 bronze badges

answered Nov 10, 2017 at 17:11

Alam Darji

2753 silver badges13 bronze badges

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

1 Comment

Z Mitnick Over a year ago

How to work with multiple data? like this $someArray[$row['pilihan']] = $row['total'],[$row['ex1']] = $row['ex2'];

Collectives™ on Stack Overflow

Codeigniter return mysql query result to single array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related