Create a new column in an array of data fetched from mysql table in php

Question

$sqlfees = "SELECT feeid,occurence FROM feedetails WHERE applicablefor='$class'"; 
//fetching data
$fees_query = mysqli_query($db_conx, $sqlfees); 
//executing query
$count = mysqli_num_rows($fees_query);
if($count > 0) {
    while($fetch = mysqli_fetch_array($fees_query)) {
        $feesarr[] = $fetch; //creating array
}

I want to add a new column to $feesarr named 'dates' along with feeid and occurence with some values

do you want to add dates( not present in table "feedetails") in $feesarr? — Ayyanar G
– Ayyanar G, Commented Apr 3, 2015 at 10:29
yes i want to add it as an index with some values like 11/02/2015, 12/02/2015 — mahethekiller
– mahethekiller, Commented Apr 3, 2015 at 10:32
so that i can do this foreach($feesarr as $row) { echo $row["occurence"]; echo $row["feeid"]; echo $row["dates"]; } — mahethekiller
– mahethekiller, Commented Apr 3, 2015 at 10:32
echo $row["dates"]; will output values that i will insert seprately specific to each row — mahethekiller
– mahethekiller, Commented Apr 3, 2015 at 10:35

Shravan Sharma · Accepted Answer · 2015-04-03 13:10:21Z

1

Try something like this

     $sqlfees = "SELECT feeid,occurence FROM feedetails WHERE applicablefor='$class'"; 
     //fetching data
     $fees_query = mysqli_query($db_conx, $sqlfees); 
     //executing query
     $count = mysqli_num_rows($fees_query);
     if($count > 0) {
    while($fetch = mysqli_fetch_array($fees_query)) {
      $new_arr['date'] = $fetch['id'].'/'.other field what you want;
      $feesarr[] = array_merge($fetch, $new_arr); //creating array
    }

answered Apr 3, 2015 at 13:10

Shravan Sharma

9898 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Create a new column in an array of data fetched from mysql table in php

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related