Good Night,
This is a new version of URL-Shortener that don't create random IDs to websites, it uses the auto-increment field and replace it to other base.
Matheus Bratfisch
"Cogito ergo sum"
Good Night,
This is a new version of URL-Shortener that don't create random IDs to websites, it uses the auto-increment field and replace it to other base.
Hello I decided to implement a Chart vision of the access to a address of the last 30 days. THe system that I choosed is…
Continue reading Chart to your URL Shortener with Statistics.
Hello, I will just show how to quickly install Apache 2, PHP5, MYSQL and PHPmyAdmin in Ubuntu. Install apache2 with: $ sudo apt-get install apache2…
Hello A few weeks ago I showed you how to create your own URL-Shortener. I decide to improve it, creating a simple system to control…
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:
CREATE TABLE IF NOT EXISTS `urls` (
`uid` int(11) NOT NULL auto_increment,
`url` text default NULL,
`unique_chars` varchar(25) BINARY NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `unique_chars` (`unique_chars`)
);
This code was taken from Abhise in this post "Create your own tinyurl with php and mySQL" 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)
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.