0

I need one help. I need to push single row table value into array using PHP and MySQL. I am explaining my table below.

db_tc

id  tc1  tc2  tc3   tc4   tc5  tc6  tc7  tc8  tc9  tc10

 1  aa    bb   cc    dd   ee   ff   gg    hh      jj

Here I need need to push all column value to single array and using same key name. I am explaining my code below.

$faqquery="select * from db_tc order by id desc limit 1";
$faqdata= $this->modl_obj->db_get_data($faqquery);
$ctr=count($faqdata);
$tcArr=array();
if($ctr >0){
    foreach ($faqdata as $v) {

    }
}

Here which column has blank data that will not push into array. My expected output should like below.

$tcArr=[{'tc':'aa'},{'tc':'bb'},{'tc':'cc'},{'tc':'dd'},{'tc':'ee'},{'tc':'ff'},{'tc':'gg'},{'tc':'hh'},{'tc':'jj'}]

Please help me to resolve this problem.

Improve this question
2
  • 1
    As a note, a schema like this with 10 columns for tc data violates the Zero, One or Infinity Rule of database normalization. A proper relational structure would be easier to deal with, you'd insert one record for each element of $tcArr. Commented Feb 15, 2017 at 7:14
  • I am little bit confused with your question ,Pleas explain properly what you need Array or Array of arrays or Array of objects. Commented Feb 15, 2017 at 7:22

3 Answers 3

Reset to default
1

As @tadman said, you should consider changing the schema for the table. But as an solution for your question instead (I will only write the foreach).

foreach($faqdata as $key => $value){
    if(strpos($key, "tc") !== FALSE){
        $tcArr[] = [preg_replace('/\d+/u', '', $key) => $value]; //preg_replace to remove the numbers that you do not wanted in your expected output.
    }
}

I haven't tested this code, and it may also varies a bit based on the MySQL output format you have, like object or array. Let me know and I will edit based on it.

EDIT: Even though I highly recommend you to change the schema of your table!

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

Comments

0

Try this:

$faqquery="select * from db_tc order by id desc limit 1";
$faqdata= $this->modl_obj->db_get_data($faqquery);
$ctr=count($faqdata);
$tcArr=array();
if($ctr >0){
    $row = $faqdata[0];
    foreach ($row as $k => $v) {
        if($v && $k != 'id') {
            $tcArr[] = ['tc' => $v];
        }
   }
}
Improve this answer

11 Comments

Its ['tc' => $v]; or ['tc' => $v['column_name']];. Please check.
It depends how your $faqdata array looks like. $v should be a value of field and $k should be column name - you can check if $k != 'id'
I have already given the table structure.my $faqdata array data look like [{'key':'value'}].
I know the table structure but $faqdata structure depends on how your db_get_data function works - If it is an array of rows (as mysql_fetch_array func.) as I have assumed than in my code, i get the first row ($row = $faqdata[0];) and iterate over it's fields where the key is column name and the value is the column value. If it works like mysql_fetch_row - you should ommit $row = $faqdata[0]; and iterate over faqdata fields not the $row.
No,expected output not coming.
|
0 
foreach ($faqdata as $key=>$value) {
     if (($key!='id') && ($value!='') {
     $outputarray[]="{'tc':'$value'}";
     } 
}
$output=implode(',',$outputarray);
$output='['.$output.']';
Improve this answer

1 Comment

Please check my post again.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.