Keyword sitemap from mysql

I added at the plattform area a sample of another website, please read also that.

I use several scripts all with a similar type of keyword database where I save the keywords visitors search for.


ID ; searchstring ; linkpart ; time searched ; Linkpart ; timestamp

52 ; anselm grün ; Books ; 17 ; de ; 1126395303

Only different is that sometimes I use other linkparts or the searchstring directly urlencoded.

I like to offer searchengines a sitemap with all my keywords with a link to my the search results.

For that I need a script which create these pages.

The script must on call search and sort keywords and offer them in an ABC sitemap.

This means on tree A you show all keywordstrings starting first letter with A and so on.

Each letter tree with own pagination (mod_rewrite) and a number of x keywords per page.

A B C D ...XY Z 1-10 (1 page)

Pagination should be prepared to handle a lot of pages, may be I have 5000 keywords A and 50 / page, I have 100 pages, but 100 pagination links on one page are bad. So sytem should be a little bit creative (show 10 +-5 and last page or so) to offer SE a good range.

Each keyword should link to my searchresults with a mod_rewrite link. Because I have several pages I must be able to define this link structure in the script by taking database fields (/search/$field3/$keywordstring..)

Also because urlstring for url is not allways urlencoded, I must be able to urlencode and str_replace bad letters like /\;<>'".. and so on before building the link (should be easy).

Pages allways should appear in a default style, this means I include simple my header, footer and siteblocks and content are the keyword pages.

Because database may be very big I need caching. Attached is a simple caching script which you can use if you like, but you should cache also in ABC folders to split files.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

unix, php4 (active) and php5, mysql

Please ask before if you have questions !

Because someone offered 10 days:

Below a similar sample what I mean, sort my keyword strings by abc and numbers and show by sample 50 per page per letter with static pagination.

Rest of the sitemap page is normal php so I can include things or randomizer.

Each keywordstring will link to search results of that string in my page with a static mod_rewrite link.

ABC navigation to page 1 of each letter tree is on every page and I need no ondex, page 1 of A is my start page.

Thats the basic, the rest I wrote are smaller things to rework the keyword or change the link.


<[url removed, login to view]>

Skills: Engineering, MySQL, PHP, Software Architecture, Software Testing, User Interface / IA, Web Hosting, Website Management, Website Testing

See more: web pagination, tree starting with n, tree range, tree database structure, structure books, sample hire letter, range tree, range search tree, letter of hire sample, letter bad, hire letter sample, hire big letters, bit tree, bad letter, alibris, mysql top 10, mysql mean, database caching, database scripts with php and mysql, php software structure mysql

About the Employer:
( 97 reviews ) Marbella, Spain

Project ID: #3904646

2 freelancers are bidding on average $77 for this job


See private message.

$68 USD in 7 days
(73 Reviews)

See private message.

$85 USD in 7 days
(1 Review)