Completed

Set up people-friendly redirects from pages in database (htaccess)

Bid information/instructions:

* Bids posted within 5 minutes of posting the project will be ignored. No automated bids.

* Bids will be evaluated after 6-24 hours and a contractor will be selected.

* Knowledge of PHP, Apache, redirects and .htaccess required.

* In your bid show that you have relevant experience.

* No copy/paste templates. Don't send a list of non-related projects/skills.

* Excellent command of written and spoken English is important.

* You will be given SSH access to a demo install to work on the server direct, no control panel, cPanel, ftp.

Project details:

I have a custom CMS which stores articles/pages in a MySQL table along with a people-friendly alias/URL. It will look something like:

MariaDB > select id, title, alias,home from articles where id in (2,14,21,109,112);

+-----+------------------------+------------------------+------+

| id | title | alias | home |

+-----+------------------------+------------------------+------+

| 2 | Local Search Placement | local-search-placement | NULL |

| 14 | About | about | NULL |

| 21 | Todo or not Todo | todo-or-not-todo | NULL |

| 109 | Home | | 1 |

| 112 | Account Help | acct-help | NULL |

+-----+------------------------+------------------------+------+

5 rows in set (0.00 sec)

For the Home page I leave the alias blank (currently) and set home=1. To keep search engines happy I want to have [login to view URL] and [login to view URL] redirect to https://www.site.com. I have a working redirect for http to https.

Here is the .htaccess curently in use:

------------------------------------

<IfModule mod_rewrite.c>

# In the beginning ...

RewriteEngine on

RewriteBase /demo/

# if subfolder, otherwise: RewriteBase /

Options +FollowSymlinks

# Redirect http to https

RewriteCond %{SERVER_PORT} 80

RewriteRule ^(.*)$ [login to view URL]$1 [R,L]

# to redirect [login to view URL] to /

RewriteCond %{THE_REQUEST} ^.*/index\.php # FAIL IF IN SUBFOLDER

RewriteRule ^(.*)[login to view URL]$ /$1 [R=301,L]

# Not found redirect

ErrorDocument 404 /demo

# if subfolder, otherwise: ErrorDocument 404 /

# Redirects index to / and [login to view URL] to /

RewriteRule ^index$ /demo # if subfolder, otherwise: RewriteRule ^index$ /

#RewriteRule ^index\.php$ /demo # FAILS for [login to view URL] if in subfolder

# [login to view URL]

RewriteCond %{REQUEST_FILENAME} !-f

RewriteRule ^(\d+(?:/.+?)?)/?$ [login to view URL]$1 [L]

# Redirect to make first string available as article_alias and queryable

RewriteRule ^index\.php$ - [L]

# Redirects deleted blog entries

RewriteRule some-file /blog [R=301,L]

# To grab the alias and make it easy to do a query and get page content

RewriteRule ^([0-9a-z-]+)?$ [login to view URL]$1

------------------------------------

The last line is the key. It allows me to extract the alias from the URL and run a query in my [login to view URL] file to obtain page data. Besides the [login to view URL] redirect to / not quite working, although this article_alias line works to obtain mysql content from the table it is prevents posts from working correctly. If I have a page like:

[login to view URL]?whoareyou=TheWHO

the action=post gets lost. Doing a print_r($_REQUEST) or print_r($_POST) does not return the options, no:

Array

(

[action] => request

[whoareyou] => TheWHO

)

The project requirement is to set up an alternate .htaccess solution that works better and work with me to make any necessary changes to the [login to view URL] script so that options work. Make it less hacky.

Skills: PHP, MySQL, Linux, Apache, HTML

See more: php create static pages database, yellow pages database extractor, dynamic aspx pages database, scraping yellow pages database, generate wordpress pages database, set seo friendly site joomla, extracting data html pages database, open office database templates bid, wages developing web pages database, yell pages database extractor, canada white pages database, asp catalog pages database, extract data html pages database, design google friendly opt pages, access database design bid average, australian residential white pages database list, redirect database htaccess, paging pages database results including thumbnails php mysql, vbs processed pages database file, static pages database generator

About the Employer:
( 9 reviews ) Erie, United States

Project ID: #21495343

Awarded to:

$75 USD in 4 days
(18 Reviews)
5.8

15 freelancers are bidding on average $79 for this job

tlchung

I can setup the correct .htaccess and [login to view URL] coding for the redirection for you. I am a skilled php developer with over 10 years experience, solid experience in php, .htaccess. let discuss more via private message.

$50 USD in 3 days
(511 Reviews)
7.4
kyleevert

Dear Client! I am very happy to see your project detail. I think it is just my project. :) As you can see in my profile, (my review: https://www.freelancer.com/u/kyleevert?w=f) I have much experience with your job. I t More

$40 USD in 1 day
(25 Reviews)
6.1
$30 USD in 7 days
(48 Reviews)
6.0
bindmission

Hello Hope you are doing well. I have 7 years of exeprience in Linux and system administration. I can handle this project. Regards VishnuLal*

$50 USD in 1 day
(159 Reviews)
6.3
BestService222

Dear Sir. Thanks for the opportunity to place bid on this project. I have read your description in carefully and so I think this project is perfect fit to me. I am a professional web developer with 7 years good experie More

$40 USD in 7 days
(19 Reviews)
5.2
unix515

1.I checked your project(not in 5 minutes) 2. I can wait the answer(6-24 hours evaluate) 3.I have knowledge about PHP , Apache , redirects , and .htaccess.. [login to view URL]://[login to view URL] 5.I don't copy/paste templates i More

$150 USD in 3 days
(9 Reviews)
4.1
goldenths

Hello greetings, I am a full stack developer with 10+ years of experience and have a deep understanding about URL rewriting rules. So I can surely help you to solve your problem. Ready to start your task now. Thank More

$40 USD in 7 days
(14 Reviews)
3.9
naveedskypotenti

Hello, this looks like everything we could help you with. I specialize in: PHP, Apache, redirects, .htaccess, PHP & PHP frameworks such as Laravel, CI, Yii and CakePHP, API development, HTML5, CSS, JavaScript, Boots More

$50 USD in 2 days
(2 Reviews)
3.3
PageOllice

Hello, I am interested in your project and would like to invite you for further discussion. Waiting for your positive reply! Regards, Page M. O.

$50 USD in 7 days
(3 Reviews)
3.3
umairkaramat24

Hello There. How are you doing? I have read the description, I have great experience doing similar jobs related to these skills Apache, HTML, Linux, MySQL, PHP. Please start the chat so we can have detailed discussion. More

$45 USD in 13 days
(4 Reviews)
2.9
limingdev0507

Hi, Thanks for your posting. I have read description of this project and I am interested in it. The placeholder price is negotiatable. I am a full-stack websites and web applications engineer. My skills include : * P More

$40 USD in 7 days
(1 Review)
3.0
YevhenDobryan

Dear Client! You are looking for web programming expert for your project. I understand your requirement so that I am very confident in your project from my expertise skills and vast experiences. I have strong skills in More

$50 USD in 1 day
(1 Review)
1.4
jameshood0401

Are you crazy? What the hell are you talking about? The budget! Do you think it is reasonable? No one can do that within your budget. Furthermore, the project has got a PROBLEM needs to be considered. Anyhow that is no More

$200 USD in 3 days
(1 Review)
0.6
sanjoymajiwebdev

With low cost I can do it. Hello sir. I m new in freelancer I am full stack developer I have experience more than 5 years in website [login to view URL] seo also. I can do everything that's you need For more information More

$277 USD in 1 day
(1 Review)
0.7