php tree data structure help

[ilanganthilaka]

machanla mage me wage table ekak thiyanawa.

mata me tabel eke thiyana data tika me wage tree ekak widihata penna one php walin.

me wade karanna mama sahena try kala.
eth harigiyr na.

danna aya help ekak denna ​

 

[ilanganthilaka]

help me

 

[GAC]

question not clear..

whole tree filled with same data..

 

[ilanganthilaka]

question not clear..

whole tree filled with same data..

according to sample records of the given table
tree should display like this bro.

 

[ilanganthilaka]

question not clear..

whole tree filled with same data..

machan mata one user id eken search kalama
e user ta adala hierarchy eka pennanna parent id ekata adalawa.

 

[Ayeshlive]

Machan oya table eka efficient naha.
Me wage table ekak hadaganna:

user:
- uid (int, unsigned, autoincrement)
- unique_id
- name

user_hierarchy:
- uid (index, int, foreign key to {user}.uid)
- uid (uid of the child account)

 

[ilanganthilaka]

Machan oya table eka efficient naha.
Me wage table ekak hadaganna:

user:
- uid (int, unsigned, autoincrement)
- unique_id
- name

user_hierarchy:
- uid (index, int, foreign key to {user}.uid)
- uid (uid of the child account)

thanks machan
ita passe kohomada wade karaganne ban

 

[Suvin1122]

user subordinate table ekak damoth karaganna puluwan neda??
like: col_id | user_id | sub_id
sub_id foreign key REF user(user_id)
eken umba call karaddi php walin hierachy eka read karala hierachy eka balanna puluwan neda???
Just an idea I came with

 

[ilanganthilaka]

user subordinate table ekak damoth karaganna puluwan neda??
like: col_id | user_id | sub_id
sub_id foreign key REF user(user_id)
eken umba call karaddi php walin hierachy eka read karala hierachy eka balanna puluwan neda???
Just an idea I came with

thanks machan
eka nam therune na mata

 

[coolmanaram]

BUMP
thama mchn

 

[Suvin1122]

thanks machan
eka nam therune na mata

mekai seen eka..
umba tiygena inne parent id ekane.. eken hierachy eka ganna kota;
ex:: user1 ge kattiya,
mekata table ekama balala parent id == user1 wena ayawa ganna wenawane

so mama kiyanne wenama table ekak okata thiya ganna
ekata daanna user_id ekata adalawa

table -> user_id | sub_id

ram | shyama
ram | rohan
ram | romita
ram | ranjith
shyama | thyanjith
shyama | neha
shyama | rama

meken umbata ram ge hierachy eka gannawanam;

1.get user subs
2.for each user recursively call step 1

 

[ilanganthilaka]

mekai seen eka..
umba tiygena inne parent id ekane.. eken hierachy eka ganna kota;
ex:: user1 ge kattiya,
mekata table ekama balala parent id == user1 wena ayawa ganna wenawane

so mama kiyanne wenama table ekak okata thiya ganna
ekata daanna user_id ekata adalawa

table -> user_id | sub_id

ram | shyama
ram | rohan
ram | romita
ram | ranjith
shyama | thyanjith
shyama | neha
shyama | rama

meken umbata ram ge hierachy eka gannawanam;

1.get user subs
2.for each user recursively call step 1

ahhh thanks macho
mama try ekak dila kiyannamko

 

[surasena56]

ubata me wage chart ekak hariyai da??

https://google-developers.appspot.com/chart/interactive/docs/gallery/orgchart


PHP ekka use karanna puluwan

 

[Ayeshlive]

thanks machan
ita passe kohomada wade karaganne ban

left join ekakin hierarchy eka build karanna puluwan. naththam user ID eka dannawanam user_id eken user_hierarchy table eka lookup karanna puluwan.

 

[ilanganthilaka]

ubata me wage chart ekak hariyai da??

https://google-developers.appspot.com/chart/interactive/docs/gallery/orgchart


PHP ekka use karanna puluwan

thanks machan
kohomada ban mekata php database ekak link karanne