What I am looking for is a programmer who excels in PHP, AJAX, MySQL and API calls/Data mining to perform the following three simple tasks. No styling is required, just a few clean basic PHP pages with information on.
The successful applicant must have excellent English and keep lines of communication open as often as possible, and should they complete this successfully, there's much more work in the future.
Here's what is needed:
STEP ONE: Create a script that extracts a COMPLETE list of eBay categories from [login to view URL] and inserts them to a MySQL database. I believe this page (at the time of writing) illustrates what I ultimately need. [login to view URL]
This should be a simple API call or you can carry it out in your own chosen method, as long as the I end up with a database populated of ALL eBay categories and no duplicates. This includes eBay's motor categories. The table is structured as the following SQL INSERT example:
INSERT INTO categories (category_id, parent_id, category_label, issubcat) VALUES (20081, 0, 'Antiques', 'Yes');
category_id -- the eBay category ID
parent_id -- the parent category ID if there is one
category_label -- the category name
issubcat -- denotes whether there's any sub categories
STEP TWO: Create a PHP page that lists the top level (root) categories initially, that is expandable when you click on the category IDs (in the square brackets). Essentially it's a simple expandable navigation tree with breadcrumbs at the top, displayed as follows:
Antiques [ 20081 ] edit
Art [ 550 ] edit
Baby [ 2984 ] edit
Books [ 267 ] edit
Business & Industrial [ 12576 ] edit
Cameras & Photo [ 625 ] edit
Cell Phones & PDAs [ 15032 ] edit
*and so on...
For example, should you click on the category ID [ 20081 ] (above) it should expand and look as follows with a new breadcrumb (clickable) displayed at the top:
Home -&gt; Antiques
Antiquities [ 37903 ] edit
Architectural & Garden [ 4707 ] edit
Asian Antiques [ 20082 ] edit
Books & Manuscripts [ 2195 ] edit
Decorative Arts [ 20086 ] edit
Ethnographic [ 2207 ] edit
*and so on...
And should you then click on the [ 37903 ] link, the following will show.
Home -&gt; Antiques -&gt; Antiquities
The Americas [ 37908 ] edit
Byzantine [ 162922 ] edit
Celtic [ 162923 ] edit
Egyptian [ 37905 ] edit
Far Eastern [ 162916 ] edit
STEP THREE: Make each category editable. By clicking on the 'edit' link next to each category, a new page must appear allowing you to edit or delete the information in the database for that record. It also needs a confirmation request to ensure you really want to save the changes or delete the record.
NOTES: FTP details will be provided to winning bidder along with MySQL database details. All uploaded work should be carried out on project owner's servers. Good luck and I look forward to working with one of you.
11 freelancers are bidding on average $187 for this job
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
Hello, I'll provide you categories and list as per your requirement. I can start right away. I show you demo on my server. Feel free to discuss me anytime. Hopefully you see 50% work today or complete. Thanks Raj
Hello Sir, I have experience in php, mysql, ebay api. I can do this project. Do you also require as admin panel to edit delete categories, so that only you can edit/delete after login. This is also included in bid.