Good Night,<\/p>\n
Here I will show you how to create your own url shortener. <\/p>\n
First of all you need to create a table like this:<\/p>\n
\n CREATE TABLE IF NOT EXISTS `urls` (
\n `uid` int(11) NOT NULL auto_increment,
\n `url` text default NULL,
\n `unique_chars` varchar(25) BINARY NOT NULL,
\n PRIMARY KEY (`uid`),
\n UNIQUE KEY `unique_chars` (`unique_chars`)
\n ); <\/p><\/blockquote>\nThis code was taken from Abhise in this post “Create your own tinyurl with php and mySQL<\/a>” that was my bigest reference, from it I took some functions and update other ones to be more efficient. For an example I changed the field to BINARY so it be CASE SENSITIVE (aaaa different from AAAA)<\/em><\/p>\n
The Abhise says to create many files, I particularly, created one file with all functions where I add all the functions and just called the functions in the files. <\/p>\n
<\/p>\n
We need a fucntion to connect\/disconnect to mysql <\/p>\n
\nerror_reporting(E_ALL);
\n$link;
\n$config;
\nfunction connect_db_lurl() {
\n\tglobal $link;
\n\tglobal $config;
\n\t$hostname = “localhost”;
\n\t$username = “USUARIO”;
\n\t$password = “SENHA”;
\n\t$dbname = “DATABASE”;
\n\t$link = mysql_connect($hostname, $username, $password); \/\/ Conecta ao mysql.
\n\tmysql_select_db($dbname) or die(“Unknown database!”); \/\/ Seleciona o Banco de dados.
\n\t$config[“domain”] = “http:\/\/seudominio.com”; \/\/ Define a configura\u00e7\u00e3o da URL inicial
\n}<\/p>\nfunction close_db_lurl() {
\n\tmysql_close(); \/\/ Fecha a conex\u00e3o com o banco de dados
\n}\n<\/p><\/blockquote>\nAfter this I created a function to redirect to the URL.<\/p>\n
function redirect($url) {
\n\theader(“Location:”.$url); \/\/ Redireciona para a url.
\n}<\/p><\/blockquote>\nThan I used the function from Abhise to generate the char sequence. (I add some chars to elevate the number of combinations<\/p>\n
function generate_chars() {
\n\t$num_chars = 6; \/\/ Tamanho que voc\u00ea deseja as strings
\n\t$i = 0;
\n\t$my_keys = “123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ”; \/\/ Caracteres que valem para forma\u00e7\u00e3o de endere\u00e7o
\n\t$keys_length = strlen($my_keys);
\n\t$url = “”;
\n\twhile($i<$num_chars) { \/\/ Gera sequencia aleatoria\n\t\t$rand_num = mt_rand(1, $keys_length-1); \n\t \t$url .= $my_keys[$rand_num]; \n\t\t$i++; \n\t} \n\treturn $url; \n} <\/p><\/blockquote>\nCreated a function to verify if the key is unique.<\/p>\n
function isUnique($chars) {
\n\tglobal $link;
\n\t$q = “SELECT * FROM `urls` WHERE `unique_chars`='”.$chars.”‘”;
\n\t$r = mysql_query($q, $link); \/\/ Verifica se a chave \u00e9 unica.
\n\tif( mysql_num_rows($r)>0 ) {
\n\t\treturn false;
\n\t} else {
\n\t\treturn true;
\n\t}
\n} <\/p><\/blockquote>\nAnd other to verify if the URL is in DB<\/p>\n
function isThere($url) {
\n\tglobal $link;
\n\t$q = “SELECT * FROM `urls` WHERE `url`='”.$url.”‘”;
\n\t$r = mysql_query($q); \/\/ Verifica se j\u00e1 existe a url
\n\tif(mysql_num_rows($r)>0) {
\n\t\treturn true;
\n\t} else {
\n\t\treturn false;
\n\t}
\n}<\/p><\/blockquote>\nFunction to create<\/p>\n
function create() {
\n\tglobal $link;
\n\tglobal $config;
\n\t$chars = generate_chars(); \/\/ Gera sequencia de caracteres.<\/p>\n\twhile(!isUnique($chars)){ \/\/ Verifica se \u00e9 unico, se n\u00e3o for gera denovo.
\n\t $chars = generate_chars();
\n\t}<\/p>\n\t$url = $_GET[“u”]; \/\/ Pega o endere\u00e7o que est\u00e1 em ?u=endere\u00e7o
\n\t$url = trim($url); \/\/ Retira espa\u00e7os em branco do inicio e do fim
\n\t$url = mysql_real_escape_string($url);<\/p>\n\tif(!isThere($url)) { \/\/ Caso n\u00e3o exista o endere\u00e7o no banco.
\n\t\t$q = “INSERT INTO `urls` (url, unique_chars) VALUES (‘”.$url.”‘, ‘”.$chars.”‘)”;
\n\t\t$r = mysql_query($q, $link); \/\/ Insere o endere\u00e7o
\n\t\tif(mysql_affected_rows()) {
\n\t\t\t$q = “SELECT * FROM `urls` WHERE `url`='”.$url.”‘”;
\n\t\t\t$r = mysql_query($q);
\n\t\t\t$row = mysql_fetch_row($r);
\n\t\t\techo $config[“domain”].”\/”.$row[2]; \/\/ Imprime endere\u00e7o para acesso da nova url
\n\t\t} else {
\n\t\t\t echo “Desculpe, problemas com o banco de dados.”;
\n\t\t}
\n\t} else { \/\/ Caso j\u00e1 exista
\n\t\t$q = “SELECT * FROM `urls` WHERE `url` = ‘”.$url.”‘”;
\n\t\t$r = mysql_query($q); \/\/ Seleciona endere\u00e7o para URL
\n\t\t$row = mysql_fetch_row($r);
\n\t\techo $config[“domain”].”\/”.$row[2]; \/\/ Imprime endere\u00e7o para acesso da url.
\n \t}
\n}<\/p><\/blockquote>\nLooking to the code I thought to create a function to get the url.<\/p>\n
function take_lurl($lurl) {
\n\tglobal $link;
\n\t$q = “SELECT url FROM `urls` WHERE `unique_chars` = ‘”.$lurl.”‘”;
\n\t$r = mysql_query($q, $link); \/\/ Pega endere\u00e7o original para tal string.
\n\tif(mysql_num_rows($r)>0) {
\n\t\t $info = mysql_fetch_array($r);
\n\t\t $url = $info[“url”];
\n\t} else {
\n\t\techo “Sorry, link not found!”;
\n\t}
\n\treturn $url;
\n}<\/p><\/blockquote>\nCreated the file “functions-little-url.php” with these functions.<\/p>\n
index.php:<\/p>\n
<\/p><\/blockquote>\n
create.php:<\/p>\n
<\/p><\/blockquote>\n
We need to add some lines do .htaccess and enable mod_rewrite.<\/p>\n
\nRewriteEngine On
\nRewriteRule ^([1-9a-zA-Z]*)$ index.php\\?u=$1 [L]
\n<\/IfModule><\/p><\/blockquote>\nI did this in my system that uses wordpress (that already uses mod_rewrite) so it work a little bit different. This is my .htaccess<\/p>\n
\nRewriteEngine On
\nRewriteBase \/<\/p>\nRewriteCond %{REQUEST_FILENAME} !-f # Verifica se a p\u00e1gina acessada n\u00e3o \u00e9 um arquivo real
\nRewriteCond %{REQUEST_FILENAME} !-d# Verifica se a p\u00e1gina acessada n\u00e3o \u00e9 um diret\u00f3rio
\nRewriteRule ^([A-Za-z0-9]{6})$ \/lurl\/index.php?u=$1 [L] # Caso coincida com a express\u00e3o regular redirecione para \/lurl\/index.php?u=$1 onde \/lurl\/ \u00e9 o diret\u00f3rio que est\u00e1 os meus arquivos de tiny-url e [L] indica que \u00e9 a ultima instru\u00e7\u00e3o a ser executada. <\/p>\n# Caso n\u00e3o feche com a parte em cima continua nas regras “padr\u00f5es” do WordPress
\nRewriteCond %{REQUEST_FILENAME} !-f # Verifica se a p\u00e1gina acessada n\u00e3o \u00e9 um arquivo real
\nRewriteCond %{REQUEST_FILENAME} !-d# Verifica se a p\u00e1gina acessada n\u00e3o \u00e9 um diret\u00f3rio
\nRewriteRule . \/index.php [L]
\n<\/IfModule><\/p><\/blockquote>\n(my URL shortener is inside \/lurl\/ directory but the redirect was done in matbra.com\/XXXXXXX so it redirects to \/lurl\/<\/p>\n
To create URLs acess create.php?u=ADDRESS<\/p>\n
URL-Shortener<\/a><\/p>\n
If you have any problem feel free to contact me. <\/p>\n
Best Regards,
\nMatheus Bratfisch<\/p>\nReferences:
\n—- “Tiny Url”:
\nwww.php.net<\/a>
\nWynia.org<\/a>
\nhtmlCenter<\/a>
\n—- “Mod Rewrite”:
\n Apache Mod Rewrite<\/a>
\n<\/p>","protected":false},"excerpt":{"rendered":"Good Night, Here I will show you how to create your own url shortener. First of all you need to create a table like this:<\/p>\n