I am currently making a file manager system I store all the folders names and files in the database (MySQL)I am trying to add folders in the database and then add sub folders to them,I wanted it to show all the folders to show in there correct position, Here is a eg:
Folder1
Folder1-Sub1
Folder1-Sub1-Sub1
Folder1-Sub1-Sub2
Folder1-Sub1-ect...
Folder1-Sub2
Folder1-Sub3
Folder1-ect...
Folder2
Folder2-Sub1
Folder2-sub2
ect...
Şu anda mysql tablo böyle karşıladığı dışarı var
id folder_name sub_folder_id file_name file_folder_id
1 Folder1 -1 -1 -1
2 Folder1-Sub1 1 -1 -1
3 Folder1-Sub1-Sub1 2 -1 -1
4 Folder1-Sub1-Sub2 2 -1 -1
5 Folder1-Sub2 1 -1 -1
6 Folder1-Sub3 1 -1 -1
7 Folder2 -1 -1 -1
8 Folder2-Sub1 7 -1 -1
9 Folder2-Sub2 7 -1 -1
İşte ben bugüne kadar aşağıdaki kodu
$GetFolders = mysql_query("SELECT * FROM user_filesfolders");
$file_tree = "";
while($ShowFolders = mysql_fetch_array($GetFolders))
{
if($ShowFolders['folder_name']==-1){
//Dont Add Becuse it not a folder
}else{
$file_tree .= '
<tr>
<td height="30" colspan="4"><strong>
<input type="checkbox" name="checkbox[]" class="folder_checkbox" id="-1" />
<span class="tree_drop" id="-1">
<img src="images/Folder.png" width="15" height="21" /> <span id="status">+</span> '.$ShowFolders['folder_name'].'</strong>
</span>
</td>
</tr> ';
//I need to keep adding floders to folder from mysql
$file_tree .= '
<tr>
<td height="30" colspan="4"><strong>
<input type="checkbox" name="checkbox[]" class="folder_checkbox" id="-1" />
<span class="tree_drop" id="-1">
<img src="images/Folder.png" width="15" height="21" /> <span id="status">+</span> '.$ShowFolders['folder_name'].'</strong>
</span>
</td>
</tr> ';
}
}
}
Birisi lütfen bana yardım veya doğru yolu beni aşağı yol açabilir