Store data from while to array in PHP

Question

I have a static array like this.

$row = array($aRow['colum_name_1'],$aRow['colum_name_2'],$aRow['colum_name_3']);

I want store my data using while loop in php for dynamic column in array

This is my code:

while ($aRow = $rResult->fetch_assoc()) 
        {
$data = "";
$data_cus_dt1 = mysqli_query($con,"select column_name from custom_table_column");
            while($my_cus_dt=mysqli_fetch_object($data_cus_dt1))
            {
                $mydata = $my_cus_dt->column_name; 
                $data  .= $aRow[$mydata].",";
            }   
   $row = array($data);
}

I want to result dynamic column, like static array.

$row = array($aRow['colum_name_1'],$aRow['colum_name_2'],$aRow['colum_name_3']);

Rajdeep Paul · Accepted Answer · 2017-01-17 18:46:35Z

1

There's no point using $data variable in your code, that too as a string. You can directly use the $row array(initially empty) in the inner while() loop to get the resultant array.

$row = array();
while ($aRow = $rResult->fetch_assoc()){
    $data_cus_dt1 = mysqli_query($con,"select column_name from custom_table_column");
    while($my_cus_dt=mysqli_fetch_object($data_cus_dt1)){
        $row[] = $aRow[$my_cus_dt->column_name]; 
    }   
}

answered Jan 17, 2017 at 18:46

Rajdeep Paul

16.9k3 gold badges21 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Store data from while to array in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related