Multidimensional Array as Variables to save in dB

Question

I have a multidimensional array

output_querys =  array(2) { [0]=> array(5) { ["ID"]=> string(1) "2" ["Code"]=> string(6) "AWS001" ["BCode"]=> string(4) "B001" ["Des"]=> string(4) "loan" ["subCat"]=> string(3) "SWA" } [1]=> array(5) { ["ID"]=> string(1) "4" ["Code"]=> string(6) "AWS002" ["BCode"]=> string(4) "B002" ["Des"]=> string(3) "tax" ["subCat"]=> string(3) "PJA" } }

I want to get this to a variable and then save into dB.I have tried all the methods that has mentioned in related problems nothing worked. Errors I got 1.trying non-object 2.Illegal string offset

what I was trying to do is

foreach($output_querys as $output_query){
  $Pv_ID = $output_query->ID;
   $Pv_Code = $output_query->Code;
      $Pv_Description = $output_query->Des;
      
    
    $data_final = array(id => $Pv_ID, code => $Pv_Code, des => $Pv_Description);
                                                
      }
      db->insert(abc, $data_final);

what is the problem here??.even i tried with json encode and still shows the "Illegal string offset"

        $Pv_ID= json_decode($output_query['ID']);
                                       
        $Pv_Code = json_encode($output_query['Code'],true);
                                            
        $Pv_Description = json_encode($output_query['Des'],true);

Have you tried instead of using the -> (arrow), but to use $output_query['ID'] ? — Periklis Kakarakidis
– Periklis Kakarakidis, Commented Feb 7, 2022 at 11:48
when you access objects you use -> but when you want to access array do this $arr['key'] — Rao DYC
– Rao DYC, Commented Feb 7, 2022 at 11:50
@PeriklisKakarakidis I tried it but is shows illegel string off set to all — coder_000_
– coder_000_, Commented Feb 7, 2022 at 12:14
@coder_000_ ok, well can you please provide the error in your question? — Periklis Kakarakidis
– Periklis Kakarakidis, Commented Feb 7, 2022 at 12:19

Rao DYC · Accepted Answer · 2022-02-08 08:08:41Z

2

I tried your given array and code

    <?php
  $output_querys = array( 
    0 => array( 
            "ID" => "2", 
            "Code" => "AWS001", 
            "BCode" => "B001", 
            "Des" => "loan", 
            "subCat" => "SWA" 
    ),    
    1 => array( 
            "ID" => "4", 
            "Code" => "AWS002", 
            "BCode" => "B002", 
            "Des" => "tax", 
            "subCat" => "PJA" 
        )
);
  foreach($output_querys as $output){
    print_r($output['Code']); echo "\n";
    
  }
?>

It is working fine on my end. Here's the working example

I think you need to do this as well, if you want to insert 1 by 1 then move the insert in foreach loop

foreach($output_querys as $output_query){
  $Pv_ID = $output_query->ID;
   $Pv_Code = $output_query->Code;
      $Pv_Description = $output_query->Des;
      
    
    $data_final = array(id => $Pv_ID, code => $Pv_Code, des => $Pv_Description);
     db->insert(abc, $data_final);                                           
      }

edited Feb 8, 2022 at 8:08

answered Feb 7, 2022 at 12:38

Rao DYC

14611 bronze badges

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

1 Comment

coder_000_ Over a year ago

Thankyou.its working like this but when i get this to an array to save in dB Message: Illegal string offset 'id' warning is coming

Collectives™ on Stack Overflow

Multidimensional Array as Variables to save in dB

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