Keyword Tool using Google Suggest API, Youtube, Bing and other suggest APIs

Languages/Frameworks used: Php, MySql, [login to view URL] This tool will be very similar to [login to view URL] in that it searches for keywords using the Google Suggest API (or another API) and shows them to the user. However, there will be multiple additional features that will be supported. [login to view URL] is a really good reference point for all UI functionality that is not specifically mentioned. The user can input the following 1. Choose between Google, Youtube, Bing, Yahoo, AppStore, Wikipedia, Amazon and Ebay (by selecting the appropriate tab at the top) 2. List of seed keywords (can be limited in number based on performance - for e.g. 50) 3. Choose Multiple Locations 4. Choose Multiple Languages 5. List of Negative Keywords (can be limited in number based on performance) User enters the data and clicks Search When the user enters the list of keywords, the tool starts populating a datatable with the data. As keywords are picked from google suggest and entered into this table, another script will also get keywords volume and cost per click data for each keyword. You will get the volume/cpc data directly from the MySql database (this database is already populated for you). The datatable will have 5 columns list below. (a) search term - this is the seed keyword that was used to get the keyword (b) keyword - this is the keyword returned from Google suggest API - parts of the keyword which are not the same as the search term should be in bold (c) Search volume - keyword searches per month (from MySql table) (d) Cost per click - in USD (from MySql table) There will be multiple tabs list above the datatable. Clicking on a tab will change the data shown inside the datatable. The following are the tabs. (a) Suggestions - this is the default view of all keywords shown (b) Questions - only those keywords which have specific "question based keywords" inside them should be shown here (I will provide list of these keywords) (c) Buyer Intent - same as questions, but for "buyer intent" (I will provide list) (d) Product Info - same as questions, but for "product info" (I will provide list) (e) Prepositions - same as questions, but for "prepositions" (I will provide list) (f) With Volume - only show keywords that have a search volume (i.e. volume > 0) Next to each tab should be a number indicating how many keywords are shown for that tab Datatables Configuration - The default number of rows shown would be 50 and the allowed range would be (10, 25, 50, 100, 500, 1000, 5000) - [login to view URL] Tools plugin should be integrated as well so that user can copy, print and export the data. - The pagination should be shown at the top and at the bottom of the table - At the top of the table should also be a filter box as provided by datatables.net. - The user should be able to select individual rows and copy/export them Theme to use -[login to view URL] I like this theme and can purchase it and send to you. I am also open to any other suggestions you have for themes as long as it is responsive. If you decide to go with this theme, I would like the text inside the datatable to be much larger. I'd also like the sidebar and the top black bar to be removed since they are not required.  Project Schedule I am open to executing the project in multiple phases, if it makes sense to do. For e.g. phase one could be just Google Suggest without any of the tabs (questions, buyer intent etc). In subsequent phases we could add more APIs and the rest of the tabs. As phases are completed milestones can be released.  Information from you When you submit a bid, please answer the following questions 1. Have you worked with the Suggest API before? 2. Have you worked with the Datatables before? 3. What php framework (if any) would you use and why? 4. What javascript framework (if any) would you use and why? 5. What issues do you see with this project?