I have a site for which I need content to start search engine optimization before launching it. I've got about 10.000 items with names, provinces, cities, phones, URLS. So, my idea is creating content for this info that I already have, which will help me improve my rankings, add content to site, and start optimization before launch.
We already have some xhtml files and css so that you base on that for the design of this page.
So, what would I need? This is what I would need:
An xhtml page where we'll show items for each of the provinces, there are about 50 provinces. Each of these pages will be a db query to a different province. But we need to create just 1 xhtml page based on the design that you did where we'll show:
- h1 header with keyword
- sub header for other keywords
- small description
- a table with list of items in that province with these columns:
- Name of item
- City
- Province
- Phone
- Mobile
Each time a person clicks on the row, not just the name, it would link to site if URL is available
- Page navigation. We’ll show 100 items at a time.
- Top "search" area where we can filter by
- Province (dropdown with all provinces). You can see list of provinces in the access database.
- City: search box to filter city
- Columns should allow ordering ascending/descending on Name, City and Province by clicking on the header's icons (up/down)
- We'd have an area that stands out at the upper right, where we tell users that we'll be launching site very soon, and ask them to subscribe to our mailing list, as we did on the home page.
-When we click on a city name, we'll show all items in that city, with URLs as I describe below but with each of the keywords. We might refine this later. We'd have a page or sitemap where we might have each of the provinces like this:
Keyword1 in [province1]
Keyword1 in [province2]
Keyword2 in [province1]
And then, when we click on it we'd see a list of all cities in that province with links to the page where it shows items for each city. It's all the same page always, but showing data for a city or a province, with one keyword or another. By doing so, we would get a lot of content on the site for different keywords, cities and provinces, in 6-8 languages, you’d provide the admin panel and language files and we’d translate them into different languages, but we need multi language: 6-8 languages
Content pages editable: Metatags, titles, descriptions, all tags for a page. Each page should have these tags editable so that I can have the Search engine optimizer guy to edit them. Page's content, header, sub header and content should also be editable for each of the pages.
- MOD_REWRITE: we'd need to have 5-8 URLs like this, with keywords in each different language:
[login to view URL]
[login to view URL]
Each of these URLS, when entered on the internet browser, would query the database and show content for that province, with header, sub header and metatags for those provinces and in the language selected.
MOD_REWRITE would work for each of the group of keywords for each of the provinces and cities; we’d take it from a database.
We'd need to track how many times people clicked on each of the urls, so we'd need to add a new field to the database, which is the number of times that a user clicked on any given item. We'll use this data to contact clients later, so that they know already that they are getting clicks from us.
As I mentioned, I have this database, I have the css/xhtml to base the design of this couple of templates and structure.
Please, let me know if you can do this for me. I would need it the sooner the better so that I can start Seo as soon as possible.
I would need these pages designed in XHTML based on the design that I already have.
Looking forward to hearing from your bids and how you’d manage all this to have it automatically query my database and show results on the template. I'll provide you with a link to my site and css/xhtml files if you match what I'm looking for.
Don't post robot-like messages that you're the best and you'll offer 100% [login to view URL], be specific in your messages and tell me how you'd do this for me, how long it would take you to have it up and running, and how much. I'd like to have it ready this week.
We at Varshyl Tech - an ITES company provide Internet Marketing services with primary focus on Website Design and Development, Graphic designs, Flash Animations, Logo Designing, 3D Max, Web Copywriting and Web marketing consulting to Clients
We have a dedicated team of Graphic Designer and Web Developer especially for designing and developing professional website. We develop website that are optimized and follow W3C standards.
Thanks
Varshyl Tech
Hello, My name is Justin Turner and I can help you implement your database query for your seo. I am very experienced in php and mysql, and I can do this in one day. I currently attend the University of Texas majoring in Computer Science: Online Information Systems. I would like to get started on the project asap, perhaps ending the bid early. Thank you,
Justin Turner
HI I AM SARBJEET SINGH RUNNING GHS TECHNOLOGIES AND I AM INTRESTED IN THIS PROJECT IF U ARE INTRESTED IN MY BID THEN PLZZ CONTZCT US AND WE WILL FORWARD U OUR DETAILS
THANKS
Hi, we are a software development house based in new delhi, we have about 40+ employees and over 250+ clients,we are very much willing and able to execute this,
thanks,
sidharth