How can I create custom SEO-friendly URLs in OpenCart?

by

It turns out this can be done with a relatively simple change to a single file. No .htaccess rewrite rules, simply patch the catalog/controller/common/seo_url.php file and add your pretty URLs to an existing database table.

The patch to seo_url.php:

Index: catalog/controller/common/seo_url.php
===================================================================
--- catalog/controller/common/seo_url.php   (old)
+++ catalog/controller/common/seo_url.php   (new)
@@ -48,7 +42,12 @@
                $this->request->get['route'] = 'product/manufacturer/product';
            } elseif (isset($this->request->get['information_id'])) {
                $this->request->get['route'] = 'information/information';
-           }
+           } else {
+                $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE keyword = '" . $this->db->escape($this->request->get['_route_']) . "'");
+                if ($query->num_rows) {
+                    $this->request->get['route'] = $query->row['query'];
+                }
+           }

            if (isset($this->request->get['route'])) {
                return $this->forward($this->request->get['route']);
@@ -88,7 +87,15 @@
                        }

                        unset($data[$key]);
-                   }
+                   } else {
+                        $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE `query` = '" . $this->db->escape($data['route']) . "'");
+
+                        if ($query->num_rows) {
+                            $url .= "https://stackoverflow.com/" . $query->row['keyword'];
+
+                            unset($data[$key]);
+                        }
+                   }
                }
            }

There are two edits required. The first extends the index() function to look in the url_alias table for any keyword matching $this->request->get['_route_'].

The second extends the rewrite() function to look in the url_alias table for all routes, not just those for products, manufacturers, and information pages.

Adding entries to the database:

INSERT INTO `url_alias` (`url_alias_id`, `query`, `keyword`) VALUES
(NULL, 'checkout/cart', 'cart');

That’s it. http://example.com/cart should return the same thing that http://example.com/index.php?route=checkout/cart does, and OpenCart should recognize $this->url->link('checkout/cart'); and return a link to the pretty URL http://example.com/cart

More Related Contents:

  1. How can I create custom SEO-friendly URLs in OpenCart?
  2. Remove index.php?route=common/home from OpenCart
  3. .htaccess 301 redirect of single page
  4. Open Cart – Passing Custom Variable
  5. Htaccess blog slug Rewrite does not work
  6. Create subdomains on the fly with .htaccess (PHP)
  7. Redirect all to index.php using htaccess
  8. How to do URL re-writing in PHP?
  9. How Can I Remove “public/index.php” in the URL Generated Laravel?
  10. HTTP authentication logout via PHP
  11. Seo Friendly URL results in CSS IMG and JS not working
  12. Htaccess: add/remove trailing slash from URL
  13. URL rewriting : css, js, and images not loading
  14. .htaccess rewrite GET variables
  15. Yii2 htaccess – How to hide frontend/web and backend/web COMPLETELY
  16. CodeIgniter htaccess and URL rewrite issues
  17. Deny direct access to all .php files except index.php
  18. .htaccess issues: No input file specified
  19. .htaccess for cakephp
  20. PHP built in server and .htaccess mod rewrites
  21. Rerouting all php requests through index.php
  22. Change WordPress Admin URL
  23. Changing the root folder via .htaccess
  24. Using PHP/Apache to restrict access to static files (html, css, img, etc)
  25. laravel trailing Slashes redirect to localhost
  26. how to redirect domain according to country IP address
  27. how to hide the actual download folder location
  28. Permission denied: /var/www/abc/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable?
  29. How can I disable mod_security in .htaccess file?
  30. Request exceeded the limit of 10 internal redirects

Leave a Comment

How can I create custom SEO-friendly URLs in OpenCart?

by

It turns out this can be done with a relatively simple change to a single file. No .htaccess rewrite rules, simply patch the catalog/controller/common/seo_url.php file and add your pretty URLs to an existing database table.

The patch to seo_url.php:

Index: catalog/controller/common/seo_url.php
===================================================================
--- catalog/controller/common/seo_url.php   (old)
+++ catalog/controller/common/seo_url.php   (new)
@@ -48,7 +42,12 @@
                $this->request->get['route'] = 'product/manufacturer/product';
            } elseif (isset($this->request->get['information_id'])) {
                $this->request->get['route'] = 'information/information';
-           }
+           } else {
+                $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE keyword = '" . $this->db->escape($this->request->get['_route_']) . "'");
+                if ($query->num_rows) {
+                    $this->request->get['route'] = $query->row['query'];
+                }
+           }

            if (isset($this->request->get['route'])) {
                return $this->forward($this->request->get['route']);
@@ -88,7 +87,15 @@
                        }

                        unset($data[$key]);
-                   }
+                   } else {
+                        $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE `query` = '" . $this->db->escape($data['route']) . "'");
+
+                        if ($query->num_rows) {
+                            $url .= "https://stackoverflow.com/" . $query->row['keyword'];
+
+                            unset($data[$key]);
+                        }
+                   }
                }
            }

There are two edits required. The first extends the index() function to look in the url_alias table for any keyword matching $this->request->get['_route_'].

The second extends the rewrite() function to look in the url_alias table for all routes, not just those for products, manufacturers, and information pages.

Adding entries to the database:

INSERT INTO `url_alias` (`url_alias_id`, `query`, `keyword`) VALUES
(NULL, 'checkout/cart', 'cart');

That’s it. http://example.com/cart should return the same thing that http://example.com/index.php?route=checkout/cart does, and OpenCart should recognize $this->url->link('checkout/cart'); and return a link to the pretty URL http://example.com/cart

More Related Contents:

  1. How can I create custom SEO-friendly URLs in OpenCart?
  2. Remove index.php?route=common/home from OpenCart
  3. .htaccess 301 redirect of single page
  4. Open Cart – Passing Custom Variable
  5. Htaccess blog slug Rewrite does not work
  6. Create subdomains on the fly with .htaccess (PHP)
  7. Redirect all to index.php using htaccess
  8. How to do URL re-writing in PHP?
  9. How Can I Remove “public/index.php” in the URL Generated Laravel?
  10. HTTP authentication logout via PHP
  11. Seo Friendly URL results in CSS IMG and JS not working
  12. Htaccess: add/remove trailing slash from URL
  13. URL rewriting : css, js, and images not loading
  14. .htaccess rewrite GET variables
  15. Yii2 htaccess – How to hide frontend/web and backend/web COMPLETELY
  16. CodeIgniter htaccess and URL rewrite issues
  17. Deny direct access to all .php files except index.php
  18. .htaccess issues: No input file specified
  19. .htaccess for cakephp
  20. PHP built in server and .htaccess mod rewrites
  21. Rerouting all php requests through index.php
  22. Change WordPress Admin URL
  23. Changing the root folder via .htaccess
  24. Using PHP/Apache to restrict access to static files (html, css, img, etc)
  25. laravel trailing Slashes redirect to localhost
  26. how to redirect domain according to country IP address
  27. how to hide the actual download folder location
  28. Pretty URLs without mod_rewrite, without .htaccess
  29. .htaccess Redirect non-WWW to WWW preserving URI string
  30. .htaccess – Redirect subdomain to folder

Leave a Comment