PHP Classes

PHP URL Shortener Class: Shorten and expand URLs stored in MySQL database

Recommend this page to a friend!
  Info   View files Documentation   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2017-03-14 (3 months ago) RSS 2.0 feedNot enough user ratingsTotal: 223 All time: 7,759 This week: 698Up
Version License PHP version Categories
shrtnr 1.0.1GNU General Publi...5HTTP, PHP 5
Description Author

This class can shorten and expand URLs stored in MySQL database.

It can take a URL and create a shorter version that is stored in a MySQL database using MySQLi.

The class can also expand existing short URLs looking up on the links database table.

It can also can track the number of clicks shortened URLs when these are expanded and the user browser is redirected to the expanded URL.

The class file itself is the a script that will perform the link shortening or expansion. It relies on .htaccess configuration to handle the shortened URL requests.

  Performance   Level  
Name: Alexandre Sinício <contact>
Classes: 4 packages by
Country: Brazil Brazil
Age: 32
All time rank: 3045227 in Brazil Brazil
Week rank: 343 Up21 in Brazil Brazil Up



Simple PHP URL shortener that uses two single files to achieve all functionality.

The shrtnr project provides a very simple way for people to build their own URL shorteners using just two files (plus a .htaccess to provide REST functionality). The idea is to get long and complex URLs and turn them into small addresses that can be easily distributed. For example, you can turn into something like

<h2>Shortened links types</h2> Shrtnr allows you to use automatically generated sequential/random URL for each link that is shortened or to create your own customized links.

<h2>No interface</h2> Shrtnr does not have any graphical interface. It uses simples API calls to insert, remove and access links.

<h2>MySQL database</h2> Shrtnr uses a MySQL database to store the links. You should have access to one in order to make this work.

<h2>Functionalities</h2> Shrtnr allows some configurations: <ul> <li>Optional password protection for inserting links.</li> <li>Optional password protection for removing links.</li> <li>Shrtnr automatically forbids two equal custom URLs.</li> <li>Configurable length and allowed characters for new automatically shortened links.</li> <li>Links may be user-defined, sequential or completely random.</li> <li>Global "toggle switch" for completely disallowing link removal.</li> <li>Configurable "error page" if user tries to access an invalid link.</li> </ul>

<h2>Installation</h2> <ul> <li>Consider shrtnr should be deployed to "".</li> <li>Change the "config.php" file to match your settings. All settings are explained within the file.</li> <li>Copy the two ".php" files to your root domain folder.</li> <li>Copy the .htaccess to your server according to our example, or change yours to match our example.</li> IF YOU HAVE MORE STUFF IN THE FOLDER WHERE YOU ARE COPYING THE .htaccess FILE, BE CAREFUL! <li>Access "" and shrtnr will create the tables needed on the database. You should have the database already created, though.</li> </ul>

<h2>API calls</h2> To include a new link with automatic shortened link generation, just use the following URL:<br> <code></code>

To include a new link with your custom shortened URL, just use the following URL:<br> <code></code>

To remove an existing link from the database, just use the following URL:<br> <code></code>

To list all entries in JSON format, just use the following URL:<br> <code></code>

To list all entries in a formatted HTML table, just use the following URL:<br> <code></code>

Shrtnr will always respond with a JSON string, with exception of the method "listLinksHTML", which will return pure HTML. The first field will always be "status", and should be 0 (error) or 1 (success). If an error occurs, shrtnr will output a second field "error" telling you why things went wrong. If you insert a link successfully, shtrnr returns a field "shrtnURL" with the shortened URL (either the automatically generated URL or your custom one).

<h2>Password protection</h2> Shrtnr allows you to protect the creation, deletion and listing of links. When this option is toggled on, a dynamic hash should be included in every request. The hash is made of a salt (which is provided in the "config.php" file) and some information of the request itself. The calculation is made this way:<br>

<code>hash = md5(salt + url + link + customURL + timestamp)</code>

The parameters "url", "link", "customURL" and "timestamp" may be empty depending on your request type. No problem. With the hash in hands, just append a "pwd=hashyoucalculated" parameter in your call. For example (the hash below is valid for salt '123456', if you are wondering):<br> <code></code>

Specifically on the "listLinks" and "listLinksHTML" methods, you should inform an additional timestamp=yyyymmddhhiiss with your current time. Shrtnr will check if your timestamp is within a 10 minute window of the server's own time to validate the request.

<h2>GET or POST</h2> Shrtnr works with GET or POST calls for inserting and removing links, your choice. Just configure it in the "config.php" file. Of course, if you choose to use POST, there's no need to include all that ugly data in the URL, just pass the arguments over POST.

<h2>Styling</h2> Just put a shrtnr.css file on the same folder and style-away!

<h2>Feel free to change</h2> If you like shrtnr but thinks it could be better, or want to change it, no problem. Fork the project, branch it away! If possible, leave a note. If it is something cool, I'd like to know and use it too!

<hr> <h1>LAST UPDATES</h1> <h3>v1.02a</h3> <ul> <li>Bugfix - shrtnr.css file was not being included due to .htaccess misconfiguration;</li> <li>Bugfix - listing links in HTML mode generated table with missing header for "single use" option;</li> <li>Update - config.php has new default values and revised documentation.</li> </ul> <h3>v1.02</h3> <ul> <li>Possibility to create random shortened links, instead of sequential ones.</li> </ul> <h3>v1.01</h3> <ul> <li>Redirect type (permanent or temporary) is now configurable;</li> <li>Possibility to create single-use links.</ll> </ul>

  Files folder image Files  
File Role Description
Accessible without login Plain text file .htaccess Data Sample .htaccess to provide basic REST functionality.
Accessible without login Plain text file config.php Aux. Configuration file.
Plain text file index.php Class The shrtnr class/service itself.
Accessible without login Plain text file Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:7,759
This week:698Up