1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[WTH] PHP MYSQL Code for Tree /Org Chart Query

Discussion in 'Hire a Freelancer' started by baokydev, Jul 28, 2014.

  1. baokydev

    baokydev BANNED BANNED

    Joined:
    Mar 11, 2014
    Messages:
    401
    Likes Received:
    150
    Job is close. payment done to istart :)
     
    • Thanks Thanks x 1
    Last edited: Jul 28, 2014
  2. edge241

    edge241 Registered Member

    Joined:
    Oct 31, 2013
    Messages:
    85
    Likes Received:
    11
    Nvm, didn't read it properly
     
    Last edited: Jul 28, 2014
  3. istart

    istart Junior Member

    Joined:
    Oct 10, 2011
    Messages:
    116
    Likes Received:
    26
    Occupation:
    Web developer - apps and db.
    Location:
    Canada
    Post a few rows from your DB and I'll take a look for you.
     
  4. baokydev

    baokydev BANNED BANNED

    Joined:
    Mar 11, 2014
    Messages:
    401
    Likes Received:
    150
    [TH="colspan: 3"][/TH] [TH="class: draggable column_heading pointer marker"]UserName[/TH] [TH="class: draggable column_heading pointer marker"]Placement[/TH] [TH="class: draggable column_heading pointer marker"]Position[/TH] [TR="class: odd"] [/TR] [TR="class: even"] [/TR] [TR="class: odd"] [/TR] [TR="class: even"] [/TR] [TR="class: odd"] [/TR] [TR="class: even"] [/TR] [TR="class: odd"] [/TR] [TR="class: even"] [/TR] [TR="class: odd"] [/TR] [TR="class: even"] [/TR]
    Jimmy leftJLO Jimmy leftShinobi JLO lefttrialuser4 JLO rightdonald_duck trialuser4 leftminnie_mouse donald_duck leftmickeymouse donald_duck rightdr_octopus mickeymouse leftdr_cucumber dr_octopus leftmr_brown111 dr_octopus right

    My question is, with such database record, how do I output it out


    The html could should look like this if it start from JLO

    Js Fiddle >

    Also need to assume that the top of tree could be any username and I only need output it branches.


    My coding is in PHP and mysql, so its probably a while loop with some logic to draw out the record.

    I will be more than willing to pay $15 or so for this code via paypal.
     
    Last edited: Jul 28, 2014
  5. baokydev

    baokydev BANNED BANNED

    Joined:
    Mar 11, 2014
    Messages:
    401
    Likes Received:
    150
    updated my question on the last reply. please check.

    Offer remain at $15 for anyone who can do this out by php and mysql to output like my database records.

    and it should work for n amount of branch.
     
  6. VoidITSolutions

    VoidITSolutions BANNED BANNED

    Joined:
    Apr 5, 2013
    Messages:
    164
    Likes Received:
    44
    Shoot me your Skype if you have one. I'm pretty tied up right now but I'll message you and see if you still need help when I get some free time.
     
  7. istart

    istart Junior Member

    Joined:
    Oct 10, 2011
    Messages:
    116
    Likes Received:
    26
    Occupation:
    Web developer - apps and db.
    Location:
    Canada
    Here you go, just did a recursive function to handle this:

     
    Last edited: Jul 28, 2014
  8. baokydev

    baokydev BANNED BANNED

    Joined:
    Mar 11, 2014
    Messages:
    401
    Likes Received:
    150
    Give me your paypal detail for this payment ( I testing now ) and skype detail by pm, I got 2nd part to this code which need to be done.

    I testing your code now.
     
  9. istart

    istart Junior Member

    Joined:
    Oct 10, 2011
    Messages:
    116
    Likes Received:
    26
    Occupation:
    Web developer - apps and db.
    Location:
    Canada
    No prob, sending it now! Let me know how the test goes.