php - Build a multidimensional array using recursive function -

-

problem:

i trying build recursive tree using function , data mysql. however, results not expected.

php code:

function buildtree($root, $next = array())  {     // sanitize input     $root = (int) $root;      // query     $query = "select cid, item, parent betyg_category status = '1' , parent = '{$root}'";     $result = mysql_query($query) or die ('database error (' . mysql_errno() . ') ' . mysql_error());      // loop results     while ($row = mysql_fetch_assoc($result))      {       $next[$row['cid']] = array (                                 'cid' => $row['cid'],                                  'item' => $row['item'],                                  'parent' => $row['parent'],                                  'children' => buildtree($row['cid'], $next)                             );     }      // free mysql result resource     mysql_free_result($result);      // return new array     return $next; }  $testtree = buildtree(0);  echo "<xmp>".print_r($testtree, true)."</xmp>";

the table in database this:

enter image description here

i array this:

array (     [1] => array     (         [cid] => 1         [item] => litteratur         [parent] => 0         [children] => array             (                 [2] => integration av källorna                 [3] => belysning av egna resultat                 [4] => referenser             )      )      , forth.. )

that say, each parent => produce children, move on next parent, etc. thank in advance advice.

you not need recursion here. in fact, inefficent since end select n+1 issue. order result set parent:

$query = "select cid, item, parent betyg_category status = '1' order parent"; $result = mysql_query($query);  $tree = array(); while($row = mysql_fetch_assoc($result)) {     if($row['parent'] == 0) {         $row['children'] = array();         $tree[$row['cid']] = $row;     } else {         $tree[$row['parent']]['children'][] = $row;     } }

this produce following:

array (     [1] => array         (             [cid] => 1             [item] => litteratur             [parent] => 0             [children] => array                 (                     [0] => array                         (                             [cid] => 2                             [item] => integration av källorna                             [parent] => 1                         )                      [1] => array                         (                             [cid] => 3                             [item] => belysning                             [parent] => 1                         )                      [2] => array                         (                             [cid] => 4                             [item] => referenser                             [parent] => 1                         )                  )          )      [5] => array         (             [cid] => 5             [item] => validitet             [parent] => 0             [children] => array                 (                     [0] => array                         (                             [cid] => 6                             [item] => huvudsyfte                             [parent] => 5                         )                  )          )  )

if want name of each children, change, use $tree[$row['parent']]['children'][] = $row['item']; instead.


Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more