+- Sinisterly (https://sinister.li)
+-- Forum: Design (https://sinister.li/Forum-Design)
+--- Forum: Web Design (https://sinister.li/Forum-Web-Design)
+--- Thread: Want to make your own url shortener website? (/Thread-Want-to-make-your-own-url-shortener-website)
Want to make your own url shortener website? - amando96 - 09-04-2011
Ever wanted to make your own URL shortening website? here's your chance:
http://www.mediafire.com/?7i16hfd1i1dd3ay
Make a database with this script:
Code:
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Máquina: localhost
-- Data de Criação: 04-Set-2011 às 00:09
-- Versão do servidor: 5.5.8
-- versão do PHP: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de Dados: `link_url`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `shorts`
--
CREATE TABLE IF NOT EXISTS `shorts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(1000) NOT NULL,
`hits` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
--
--Test drive: http://clickmyadfly.com/n/
Example: http://clickmyadfly.com/n/s/?s=40
Hope you like this, it was 100% made by me, and I'll probably add some other things like url hits or something...