Simple PHP/MySQL category structure

I need a simple category structure, based on two database tables.

First table is the categories, second table is the items them self.

Table: Categories




Table: files






Your job is to make a PHP / HTML page with a menu for categories on the left hand side, and the listing on the right. (See attached image)

When selecting a category item on the left hand menu, the page reloads with a PHP GET variable. (ie: [url removed, login to view]). Thus revealing the corresponding items from the items table, with category_id tagged as 4.

It must be possible to implement/include this code on an already existing webpage, through <? php include(''); ...

See attached image for details on the look of the HTML page.

It's not nessecary to use a lot of time on the LOOKS of the HTML page, since I will redesign most of it. Just make it plain and simple.

Please let me know if you have any questions.

Best regards


1. The menu on the left should be designed as TREEVIEW. It should expand and contract when clicking on it.

.Category 1
...Subcategory 1
.Category 2

The structure should be inside a <ul></ul> and each category in a seperate <li> </li>

If you want, you can use jQuery.

2. Search functionality support. Important.

I also need a function or script that releals what category an item belongs to.

For example. If I query this function/script with a file with ID 5593, it will tell me that this file is a part of "Category 4 - Sub Category 1 - SubSubcategory 4" (if it is)

It can f.ex be queried like this: findcategory.php?fileID=5593


And report back this way:

Successfull = File 5593 is in "<a href="index?category=1">Category 4</a> - <a href="index?category=2">Sub Category 1</a> - <a href="index?category=3">SubSubcategory 4</a>"

These are links reported. User can click on link, and be sent to the index.php page with correct category set. Thus revealing all items in that category.

Got it?

Evner: PHP

Se mere: mysql categories, php mysql category subcategory, structure php, questions. best, questions best, please let me know if you have any questions, php description, no structure, Mysql questions, look php id, c# category, category php id, best webpage, best categories, mysql categories items, php mysql categories items, mysql category, category structure mysql, mysql categories structure, php mysql category structure, mysql category structure, php mysql categories sub, mysql user items structure, create category structure using mysql php, structuring categories mysql

Om arbejdsgiveren:
( 12 bedømmelser ) 1169, Norway

Projekt ID: #308243

Tildelt til:


Dear Buyer, The task appears quite clear. We can do it in no time, and in a manner that can be customized easily for the UI. Thanks!

$30 USD på 1 dag
(16 bedømmelser)

3 freelancere byder i gennemsnit $37 på dette job


This can be done straight :)

$50 USD på 1 dag
(1 bedømmelse)

Dear Buyer. I can do this task easily.

$30 USD på 1 dag
(0 bedømmelser)

I've done something similar to this in the past. Will PM a link to you.

$30 USD på 1 dag
(0 bedømmelser)