Find Jobs
Hire Freelancers

Keyword sitemap from mysql

$30-100 USD

Cancelled
Posted over 18 years ago

$30-100 USD

Paid on delivery
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. database: 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. Frank <[login to view URL]>
Project ID: 3904646

About the project

2 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $77 USD for this job
User Avatar
See private message.
$68 USD in 7 days
5.0 (73 reviews)
6.3
6.3
User Avatar
See private message.
$85 USD in 7 days
0.0 (1 review)
0.0
0.0

About the client

Flag of SPAIN
Marbella, Spain
4.9
97
Payment method verified
Member since Apr 25, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.