Showing product name instead of product id in the URL.

Then according to this, i have to make product name primary key in my table of database.
can't i just say that i search from the database with integer id but show name in the url?

You can change your database query.

Assuming you select it by ID right now.

PHP Code:

$product = $this->db
    ->where('id', 1)
    ->limit(1)
    ->get('product'); 


You then specify what field you want to select by

PHP Code:

$product = $this->db
    ->where('name', 'Honor-10')
    ->limit(1)
    ->get('product'); 


You don't have to change your DB primary key, it still can be ID, but you should index the name field.