php - Appending SQL to existing associative array -

-

learning php , creating associative arrays.

trying create associative array describes activity. activity example 354 , 355.

this current code:

$query = $db->prepare('select item_id kh_program_item_info '. $where);     $query->execute();     if($query->rowcount() > 0){         while($john = $query->fetch(pdo::fetch_obj)){             $key1 = $john->item_id;             $report-> $key1= array();         }           foreach ($report $key=>$johnval) {              $where = 'item_id = ' . $key;                    $query = $db->prepare('select activity_desc, date_format(activity_date,"%d/%m/%y") activitydate kh_program_items '. $where);             $query->execute();             $results = $query->fetch(pdo::fetch_obj);             $report->$key = $results;               echo '<pre>';             echo print_r($report);             echo '</pre>';                     }      } else {         echo '<p>there no activities</p>';     }

this yield results. 

stdclass object (     [354] => stdclass object         (             [activity_desc] => <p>send activity</p>             [activitydate] => 08/11/2016         )      [355] => stdclass object         (             [activity_desc] => <p>send activity 2</p>             [activitydate] => 11/11/2016         )  )

i trying add more information 354 , 355.
have revisited code , here new code:

$query = $db->prepare('select item_id kh_program_item_info '. $where);     $query->execute();     if($query->rowcount() > 0){         while($john = $query->fetch(pdo::fetch_obj)){             $key1 = $john->item_id;             $report-> $key1= array();         }           foreach ($report $key=>$johnval) {              $where = 'item_id = ' . $key;                    $query = $db->prepare('select activity_desc, date_format(activity_date,"%d/%m/%y") activitydate kh_program_items '. $where);             $query->execute();             $results = $query->fetch(pdo::fetch_obj);             $report->$key = $results;              $query = $db->prepare('select info_value kh_program_item_info '. $where .' , info_type="program_category"');             $query->execute();             $info_value = $query->fetch(pdo::fetch_obj);              $where = 'category_id = ' . $info_value->info_value;             $query = $db->prepare('select category_name kh_program_categories '. $where);             $query->execute();             $actcategories = $query->fetch(pdo::fetch_obj);               $report->$key = $actcategories;                       echo '<pre>';             echo print_r($report);             echo '</pre>';                   }      } else {         echo '<p>there no activities</p>';     }

this overwrite have created , yield following results:

stdclass object (     [354] => stdclass object         (             [category_name] => parent input         )      [355] => stdclass object         (             [category_name] => children's menu         )  )

the problem $myactivity->$key = $actcategories;.

how append end without overwriting information?

i need yield result

stdclass object     (         [354] => stdclass object             (                 [activity_desc] => <p>send activity</p>                 [activitydate] => 08/11/2016                 [category_name] => parent input             )          [355] => stdclass object             (                 [activity_desc] => <p>send activity 2</p>                 [activitydate] => 11/11/2016                 [category_name] => children's menu             )      )

thanks in advance.

you'll need build array first , then, send object.

i.e. : 

    foreach ($report $key=>$johnval) {          $where = 'item_id = ' . $key;                $query = $db->prepare('select activity_desc, date_format(activity_date,"%d/%m/%y") activitydate kh_program_items '. $where);         $query->execute();         // build first array         $result_first_query = $query->fetch(pdo::fetch_obj);          $query = $db->prepare('select info_value kh_program_item_info '. $where .' , info_type="program_category"');         $query->execute();         $info_value = $query->fetch(pdo::fetch_obj);          $where = 'category_id = ' . $info_value->info_value;         $query = $db->prepare('select category_name kh_program_categories '. $where);         $query->execute();         // build second array         $result_second_query = $query->fetch(pdo::fetch_obj);           // put them in $report->$key         $report->$key = $result_first_query + $result_second_query;                   echo '<pre>';         print_r($report);         echo '</pre>';               }

hope helps.


Comments

Post a Comment

Popular posts from this blog

jsf - "PropertyNotWritableException: Illegal Syntax for Set Operation" error when setting value in bean -

-
this question has answer here: how send form input values , invoke method in jsf bean 1 answer i error when trying send values jsf page bean. i want set values fields in bean, create airplane instance , add database. error telling me use illegal syntax setter part of bean. why error? didnt find on site helped me problem. here jsf part: <h4>add plane</h4> <c:if test="#{not empty listairplanebb.error}"> <div class="alert alert-danger"> <span class="glyphicon glyphicon-remove"></span> <h:outputtext value="#{listairplanebb.error}" /> </div> </c:if> <h:form> <table class="table"> <thead> ...
Read more

arrays - Algorithm to find ideal starting spot in a circle -

-
so problem have been debating such: your given array of integers representing circle. then, have pick spot in circle start. place start, compare value @ array number of steps took there , if steps less or equal number, include in final set. find place start have elements in set. ex, a=[0, 1, 2] if start @ index=0, then: a[0]=0 < =0 0 included a[1]=1 < =1 1 included a[2]=2 < =2 2 included final set: {0,1,2} if start @ index=1, then: a[1]=1 > 0 1 not included a[2]=2 > 1 2 not included here loop around a[0]=0 > 2 0 included final set: {0} if start @ index=2, then: a[2]=2 > 0 2 not included, here loop around a[0]=0 < = 1 0 included a[1]=1 < = 2 1 included final set: {0,1} so in trivial case, starting position index=0 best position results in final set elements. brute force method of finding obvious, trying find more efficient method. attempts far have been examine trying find max intersect of viable starting ranges calculated each element in arr...
Read more

php - Autoloader issue not returning Class -

-
problem? bootloader (autoloader) not seem working properly, or i'm missing something. here simplified code. the code below returns class "skeleton" not exist. on index.php file. index.php <?php include 'bootloader.php'; use skeleton\html\loginheader; $tool = new skeleton/html/loginheader(); bootloader.php <?php function boot($classname) { $filename = ''; $namespace = ''; // sets include path "src" directory $includepath = dirname(__file__).directory_separator.'src'; if (false !== ($lastnspos = strripos($classname, '\\'))) { $namespace = substr($classname, 0, $lastnspos); $classname = substr($classname, $lastnspos + 1); $filename = str_replace('\\', directory_separator, $namespace) . directory_separator; } $filename .= str_replace('_', directory_separator, $classname) . '.php'...
Read more