Add additional value to array built from variables in PHP

Question

I have the following code in PHP:

$stmt2 = $dbh->prepare("select GROUP_CONCAT( cohort_id SEPARATOR ',') as cohort_id from ( select distinct cohort_id from table_cohorts) as m"); 
$stmt2->execute(); 
$row2 = $stmt2->fetch();
$cohorts_allowed = explode(",",$row2["cohort_id"]);
$value = array ('amount', $cohorts_allowed );

$cohorts_allowed gives me something like "database_percent, national_percent". It is generated from all the possible cohort_ids in my database.

What I need to do is get all of these and add in the additional value 'amount' (which is not in my database) into the array.

How can I do this. You can see I tried to do this on the last line of my code above, but obviously that doesn't work.

Adrian Cid Almaguer · Accepted Answer · 2015-03-05 02:44:00Z

1

$cohorts_allowed = explode(",",$row2["cohort_id"]);
$cohorts_allowed['amount'] = 'amount' ;

or

$cohorts_allowed = explode(",",$row2["cohort_id"]);
$cohorts_allowed[] = 'amount' ;

How this works:

<pre>
<?php

$row2["cohort_id"] = "database_percent, national_percent";
$cohorts_allowed = explode(",",$row2["cohort_id"]);

print_r($cohorts_allowed);

/* output
Array
(
    [0] => database_percent
    [1] =>  national_percent

)
* The last index is 1
*/

$cohorts_allowed[] = 'amount' ;

print_r($cohorts_allowed);

/* output
Array
(
    [0] => database_percent
    [1] =>  national_percent
    [2] => amount
)
* The last index is 2 (after 1) and have the value amount.
* 
*/

?>
</pre>

You can read in:

http://php.net/manual/en/language.types.array.php

edited Mar 5, 2015 at 2:44

answered Mar 4, 2015 at 21:40

Adrian Cid Almaguer

7,79113 gold badges44 silver badges66 bronze badges

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

2 Comments

Adrian Cid Almaguer Over a year ago

@jonmrich I edit with a example, don't forget check the answer as correct ;-)

jonmrich Over a year ago

Thanks for the additional insight.

Collectives™ on Stack Overflow

Add additional value to array built from variables in PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related