How to make PHP-MySQL Data Tree ?

Dear friends,

I need a PHP-MySQL based data tree where I can add data/level or delete.
Please read the .doc file for details (inside DataTree.zip file)

Please see the attached document and help me. You can also provide me links where I can find such like this tutorials or code.

Thanks in indvance.

 

hi, most people wont download that for the simple fact they don't know whats in it. Post your code, and be specific about what you need.
If you want an interface that can add/delete/overwrite /update data to an SQL database, that sounds like what you're talking about.

To do that, turn all your variables to PHP vars. and then handle it with SQL code. Standard php/sql stuff. So i can assume you don't know PHP or SQL or ?
If you know PHP/SQL then make yourself a standard interface with PHP that can display even simple HTML tables that 'foreach' all data to the tables and for every one have the data assigned its own PHP variable. Then next to that in the table have 2 buttons (or more) that say = "DELETE" "UPDATE" ..a standard HTML submit button with the value changed value="delete" value="update".

When youpush the button have the button activate the PHP/SQL handler file ..OR .. have the handler function on same page,it will update or delete that data variable ,reload the page with the new or deleted data gone. That's how you do that. However you want to display the data can be an HTML question for you to design. If you want to go to the next step and make it even flashier, skip the reloading page and put the whole table inside an AJAX Div table for instant reload without page reload. (To do that, have PHP handler file with the AJAX code displaying the table data , and once the PHP handler has executed the script to correctly update or delete the data, it will also trigger the DIV table to display the current data. Removing all page reload function for fast and easy 'nice nice' pages.

 

Actually I want a data tree using PHP-MySQL like the attached image.

I know PHP and MySQL. But I dont know how to make the MySQL tabe for for datatree and hou to display them using php.

Someone Please make a databse table with some sample data and a php page that will display the data.

 

couldn't you simulate that with a HTML table border=0 ?
and have the columns and rows set up where if the SQL data is a first tier put in row 1, second tier row 2 .. up to however many rows for tiers. It would give the equivalent. If you need a jpg image, just screen shot at it and save to jpg

 

Dear, actually I am new on DataTree and cant insert the technique in my head.
Would you please give me an example with mysql tabe if you have free time. I will be thankfull to you.

 

Im a dude,thats one of the sextuplets .
You say you know PHP and SQL, so output the results to DIV tables <div id="row1"> etc .

 

1) You don't design the database table for a tree, you design it for the data.

2) If you want to display the data in a tree, see http://dhtmlx.com/docs/products/dhtmlxTree/index.shtml It takes a little work to learn how to use it, but it gives you a nice tree pretty easily.

 

search on google there are lots of tree structure,,, you can also use dxhtml tree as mentioned in the Rukbat.

 

Test post..