URL Rewrite with parameter and php query

Question

Directories: eventfinder is project folder

Localhost
-- project1
-- project2
-- eventfinder
--- .htaccess

User comes to the page http://localhost/eventfinder/ and types 'randomevent123' after /eventfinder/

then php query happens with ?event=randomevent123

$event = $_GET['event'];

$stmt = $conn->prepare("SELECT * FROM events WHERE name = :name");
$stmt->bindParam(":name", $event);
$stmt->execute();

and returns data from database

I am trying to rewrite my url but I don't understand what is the problem...

http://localhost/eventfinder/index.php?event=randomevent123

to

http://localhost/eventfinder/randomevent123

With .htaccess

RewriteEngine On
RewriteRule ^([^/]*)$ /index.php?event=$1 [L]

But query won't work.

RewriteRule ^eventfinder/([^/]+)/?$ /index.php?event=$1 [L] you're not taking into account /eventfinder/ at the moment. — CD001
– CD001, Commented Jun 6, 2017 at 12:55
RewriteEngine On RewriteRule ^eventfinder/([^/]*)$ /eventfinder/index.php?event=$1 [L] — Masivuye Cokile
– Masivuye Cokile, Commented Jun 6, 2017 at 13:02
^ Oh yeah, I missed the /eventfinder/ in the resulting path as well :\ ... unless /eventfinder is an actual directory and that's where the .htaccess file resides? — CD001
– CD001, Commented Jun 6, 2017 at 13:04

hjpotter92 · Accepted Answer · 2017-06-06 13:20:27Z

2

Give the following a try:

Confirm that mod_rewrite is loaded
Check that AllowOverride allows htaccess parsing

The following rule (inside eventfinder directory):

RewriteEngine On
RewriteBase /eventfinder/

RewriteCond %{THE_REQUEST} ^GET\ /eventfinder/index\.php\?event=([^\s&]+) [NC]
RewriteRule ^index\.php$ %1 [R,L,QSD]

RewriteRule ^(?!index\.php([^/]+))$ index.php?event=$1 [L]

answered Jun 6, 2017 at 13:20

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Troutfisher Over a year ago

I changed these settings from httpd.conf and restarted apache, still not working. LoadModule rewrite_module libexec/apache2/mod_rewrite.so I changed <Directory /> AllowOverride All Require all granted </Directory> Apache version 2.4.25

hjpotter92 Over a year ago

@Troutfisher The AllowOverride needs to be activated for the directory of your DOCUMENT_ROOT. I certainly hope that it is not /.

CD001 · Accepted Answer · 2017-06-06 13:30:36Z

0

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^([^/]+)/?$ /eventfinder/index.php?event=$1 [L]

You can us !-f and !-d checks on the requested filename to ensure that the URL that's being typed is not a file and not a directory before doing the rewrite itself - it prevents a recursive loop on index.php

answered Jun 6, 2017 at 13:30

CD001

8,5123 gold badges26 silver badges29 bronze badges

Collectives™ on Stack Overflow

URL Rewrite with parameter and php query

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related