PC Tips & Tricks

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
 
function slugify($text)
{		
	$CI =& get_instance();
	$CI->load->model('my_model', 'Mod');
	$text = preg_replace('/\W+/', '-', $text);
	$text = strtolower(trim($text, '-'));
	$slug = $text."-1";
	//tests if there is any slug like "text"
	$res = $CI->Mod->getSlugs($text);
	if ($res->num_rows()==0)
	{
		//if not, make it first
		$slug = $text."-1";
	}
	else 
	{
		//else add 1 to number the slug ends with
		$lastItem = $res->row();
		$tmp = explode('-',$lastItem->short);
		$slug = $text . '-' . (int)($tmp[count($tmp)-1]+1);
	}
 
	return $slug;
}

<?php
function getSlugs($text)
	{
		$this->db->order_by('id DESC');
		$this->db->like('short',$text,'after');
		$this->db->limit('1');
		$res = $this->db->get('table_name');
		return $res;
	}
?>