Use title in URL

I'm not a professional, certainly are better solutions, but after much research I found the solution below, valid for CI3:

The model:

function get_name()
{
$string = $this->uri->segment(3);
$array=explode("8801",$string);
$id = ($array[1] / 9);
$this->db->where('id', $id);
$query = $this->db->get('names');
return $query->result();
}


Below, I'm associating names/albums:

function get_albuns()
{
$string = $this->uri->segment(3);
$array=explode("8801",$string);
$idx = ($array[1] / 9);
$sql = ("SELECT A.*, PA.* FROM albuns A, players_albuns PA
WHERE PA.player_id=$idx AND PA.album_id = A.id ORDER BY ano, posodr, album_id ASC");
$query = $this->db->query($sql);
return $query->result();
}

The view:

foreach ($name as $row);
$playerid = $row->id;
$name = $row->name;
$linkname = (9 * $playerid);

$str = convert_accented_characters( $name);
$urln = $url_title = url_title($str, '-', TRUE);

As my website is only local, I have great freedom in testing solutions, but of course, within my limitations, which are not few.Below, some results:

echo "<a href='/allmedia/names/$url_title-wd8801$linkname'>$name</a>";

http://localhost/allmedia/names/ella-fit...wd88011395


echo "<a href='/music/album/$record-wd8803$linkrec'>$title</a>";

http://localhost/music/album/ella-fitzge...d880312705