<?php

    function addUrl($url, $short)
    {
        $t = mktime(date("H"), date("i"), date("s"), date("m"), date("d"), date("Y"));
        $resAddUrl = mysql_query("INSERT INTO `urls` (`url`,`short`,`created`,`lastupdated`) VALUES"
            ."                                ('". mysql_real_escape_string($url) ."','". mysql_real_escape_string($short) ."','". mysql_real_escape_string($t) ."','". mysql_real_escape_string(0) ."')") or die("Ошибка в добавлении");
    }
	
	function showUrl($c=1) 
    
    {
        $resViewUrls = mysql_query("SELECT * FROM `urls` ORDER BY `created` DESC,`id` DESC LIMIT ".$c) or die("Ошибка вывода");
        while($rwu = mysql_fetch_assoc($resViewUrls))
        {
            $sn = SITE_URL ."/". $rwu['short'];
            return $sn;
        }
    }
	
    function searchUrl($url)
    {
        $ress = mysql_query("SELECT * FROM `urls` WHERE `url`='". mysql_real_escape_string($url) ."'") or die ("Ошибка базы данных 1<br>".mysql_error());
        
        if(mysql_num_rows($ress) > 0)
        {
            $surl = mysql_fetch_assoc($ress);
            $short = SITE_URL ."/". $surl['short'];
            return $short;
        }
        return false;
    }
	
    function searchShort($short)
    {
        $resss = mysql_query("SELECT * FROM `urls` WHERE `short`='". mysql_real_escape_string($short) ."'") or die ("Ошибка базы данных 2<br>".mysql_error());
        
        if(mysql_num_rows($resss) > 0)
        {
            $ssho = strtolower($short);
            $sshort = strrev($ssho);
            return $sshort;
        }
        return false;
        
    }
	
	    function getNameUrl($len = 4)
    {
        $nUrl = chr(mt_rand(65, 90));
        for($i = 1; $i < $len; $i++)
        {
            
            switch (mt_rand(0, 2))
            {
                
                case  2 : 
                $nUrl .= chr(mt_rand(65, 90));
                break;
                
                case  1 : 
                $nUrl .= chr(mt_rand(97, 122));
                break;
                
                case  0 : 
                $nUrl .= chr(mt_rand(48, 57));
                break;
            }
        }
        return $nUrl;
    }

INSERT INTO `urls` (`url`,`short`,`created`,`lastupdated`) VALUES ('http://123.ru','BiIB','1423045734','0')

Тестовая страница
prepare($query); $stmt->bind_param("ss", $url, $short); $url = 'http://php.net/manual/ru/mysqli.prepare.php'; $short = 'hjh8979'; $stmt->execute(); printf("%d строк вставлено.\n", $stmt->affected_rows); $url = 'http://php.net/manual/ru/mysqli-stmt.bind-param.php'; $short = 'k786sdf'; $stmt->execute(); printf("%d строк вставлено.\n", $stmt->affected_rows); $stmt->close(); $mysqli->close(); ?>

 or die("</br>Ошибка в добавлении");

or die(mysql_error());