Which technique usually professional CI use for SEO?

[eluser]webbymonk[/eluser]
Some of site using + sign for separating space in URL


I am wondering which one is better for SEO the + or -?
Anyone have done research on it?

[eluser]Gerson[/eluser]
Isn't it possible to combine url_title() with the query string to get the right entry from the DB without the need to have a 'seo_name' column in the table?

Something like:
$query = $this->db->get_where('page', array(url_title('title') => $url_title), 1);

(This one I wrote doesn't work. But I'm also trying to figure out a better way to do the same thing).

[eluser]marysue33[/eluser]
[quote author="Gerson" date="1235169687"]Isn't it possible to combine url_title() with the query string to get the right entry from the DB without the need to have a 'seo_name' column in the table?

Something like:
$query = $this->db->get_where('page', array(url_title('title') => $url_title), 1);

(This one I wrote doesn't work. But I'm also trying to figure out a better way to do the same thing).[/quote]


correct

it will achieve something like onemilliontomy.webs.com


[url="http://onemilliontomy.webs.com"][/url][url="http://onemilliontomy.webs.com"][/url]
[url="http://onemilliontomy.webs.com"][/url][url="http://onemilliontomy.webs.com"][/url]
[url="http://onemilliontomy.webs.com"][/url][url="http://onemilliontomy.webs.com"][/url]
[url="http://onemilliontomy.webs.com"][/url][url="http://onemilliontomy.webs.com"][/url]
[url="http://onemilliontomy.webs.com"][/url][url="http://onemilliontomy.webs.com"][/url]
[url="http://onemilliontomy.webs.com"][/url][url="http://onemilliontomy.webs.com"][/url]
[url="http://onemilliontomy.webs.com"][/url][url="http://onemilliontomy.webs.com"][/url]
[url="http://onemilliontomy.webs.com"][/url][url="http://onemilliontomy.webs.com"][/url]

[eluser]Unknown[/eluser]
I've used a different means to implement SEO friendly URLS.

Instead of ...
http://www.site.com/cat/Event-and-Entertainment

I use ...
http://www.site.com/cat/Event-and-Entert.../E8RD9221/

The last bit 'E8RD9221' is a 5 char hash combined with the id from my table. This enables me to quickly retrieve the entry from the database using an integer index and hash query (ex. WHERE id=221 AND hash='E8RD9').

This is mainly with performance in mind. The above query is much faster than doing an equals conditional on a VARCHAR field.

$.02

[eluser]JulianM[/eluser]
Hi @snazzyC, I liked your approach and I used to use both in the past, well, not exactly like you but using an additional segment in order to identify the ID quickly in the database. Otherwise, with large data set it would take some time to get the title text in the DB table.

Now, my question is. Do you get any additional benefit about using that HASH, or the idea was to hide the original record ID? (for security purposes)

[eluser]John_Betong_002[/eluser]
 
As far as SEO is concerned then I use the following code to inform Routers of the preferred URL...
 
./application/views/_header.php (common header included in every view)

Code:

<?php
  ...
  $canonical    = isset($canonical) ? $canonical : base_url() .$this->uri->uri_string();
  $canonical    = str_replace('www.','',$canonical);
  $canonical    = reduce_double_slashes(base_url() .$canonical);
  ...
?>
<link rel='canonical' href='<?php echo $canonical;?>' />