HowTo: Create your own Bit.ly or Tinyurl.com Website from Scratch .

Shortening a long address into a short one is now becoming very famous and especially in sites like twitter and blogs. I was always think that i need to deal something that is useful for people and finally decide to show you guys how to create a tiny url site like Bit.ly or Tinyurl.com

First the requirements:

If you are doing on your local machine:

You require the following
1. Apache
2. PHP
3. MySQL

or you can go for complete automation system like WAMP for Windows, MAMP for MAC and LAMP for Linux operating system.

In this whole tutorial i will be using WAMP.

If you are doing on a remote host, it should support:

1. PHP
2. MySQL
3. .HTACCESS

Coding Up:

I will not go in depth about installing the above servers but there are already lot of tutorials on this and still if you want to contribute a tutorial you can be a guest author.

I don’t want to make this post boring so i will go simple and easier for any users. I hope you are a bit familiar with PHP and mySQL and even if you are not you can download and run it but still it becomes like a copy and paste.

Phases that we develop:

1. Allowing User to add a long URL
2. Allowing user to add his own alias name
3. Validating the availability of Alias name
4. Storing the long URL into MySQL
5. Count system
6. Playing with .htaccess
7. Retrieving the long URL

Phases you can expand:
1. Log In System where register users can manage the URL’s added by them
2. Create a graph system using counts and date to let the user know visits to a particular URL

The 1st phase:

Here first let us create a MySQL database. I hope you guys know how to create a mysql data.

I will be creating the database name as “gotiny_base”  and let us Create a table called “url_tables”

These are all the fields a table must have.
Alias – Varchar[20]
URL – text
count – Integer
date – Timestamp

Here is the MySQL Code:

Now the HTML code “index.html”:

Now we have finished the front end it time to work on our main system. This system will store the original URL and create an alias name.

The PHP Part:
1st the cofiguration page “config.php”:

1.$Database_Username = "username";

2.$Database_Password = "password";

3.$Database_Name = "gotiny_base";

4.$Database_Host = "localhost";

5.$DBConn = mysql_connect($Database_Host, $Database_Username, $Database_Password) or die("Unable to connect to our database server. Check your settings.");

6.$DB_DB = mysql_select_db($Database_Name, $DBConn) or die("Could not connect to database ($Database_Name). Perhaps you don't have the right permissions on this DB. Check your settings");

In the above code we use it for connecting to the database please give you database information like mysql username, password and host. We can import this into our action page.

Now we have created our config page to connecting our website to our MySQL its time to create an action page which actually performs action in storing the original url, throwing errors, creating a random alias name.

I hope you all got a clear picture in mentioned above. We exclusive covered the CSS and Front End part, now we need to create actions and validations page to shorten the link successfully.
For validating and showing results we will be using Mootools (a AJAX framework) i will not be explaining in detail on mootools right now.

Here is the actions.php file:

1.//To post values from index.html

2.$url=$_POST['originalurl'];

3.$alias=$_POST['alias'];

4.$count=0;

e are initially making count as 0 becomes this is being created for the first time.
Assigning orginalurl and alias to $url and $alias respectively.

Now we need to validate the URL as well as ALIAS.
Should Validate:
1. URL must be a URL and not just a TEXT
2. If alias field is blank then it must randomly create some characters.
3. If alias field has some value but its less than 3 characters then an error must be thrown.
4. Alias name shouldn’t contain any special characters.
4. If alias name is already being used by someone then again an error must be thrown.

So here is the code for that i will be using mootools so that i can display the result at the same page.

01.if(validate_url($url)==FALSE)

02.{

03.$result[] = 'Please enter only URL which start with http:// we wont allow you to tiny SHIT';

04.}

05.if($alias=='')

06.{

07.$alias=chr(rand(97,122)).chr(rand(97,122)).chr(rand(97,122));

08.}

09.if(strlen($alias)<3)

10.{

11.$result[] = 'Alias name must be greater than 3 chracters';

12.}

13.if(alpha_numeric($alias)==FALSE)

14.{

15.$result[] = 'No Special Characters must be used.';

16.}

17.if(alias_check($alias)==FALSE)

18.{

19.$result[] = 'Alias Name is already being used be someone, please specify another alias name';

20.}

In the above code we are using few functions (functin.php) like validate_url, alpha_numeric, alias_check and these functions are in function.php

01.unction alpha_numeric($alias)

02. {

03. return ( ! preg_match("/^([-a-z0-9])+$/i", $alias)) ? FALSE : TRUE;

04. }

05. function validate_url($url)

06. {

07. return (!preg_match("/http|ftp:\/\/(.*)\.(.*)/i", $url)) ? FALSE : TRUE;

08. }

09.function alias_check($alias)

10. {

11.include('config.php');

12.$sql="SELECT alias FROM url_tables WHERE alias='".$alias."'";

13.$result=mysql_query($sql);

14.$row=mysql_fetch_array($result);

15.if( mysql_num_rows($result) == 0 )

16.{

17. return(TRUE);

18.}

19.else{

20. return(FALSE);

21.}

22.

23. }

The $sql is used for checking the presence of alias name.

Now we completed the validation part. If everything goes well then we have to insert to our database.

Here is the code for that:

1.$query1 = mysql_query("INSERT INTO url_tables (alias,url,count) VALUES ('$alias','$url','$count')");

The mootools function that is being added on index.html is here:

1.<script src="mootools.js" type="text/javascript"><!--mce:0--></script>

2.<script type="text/javascript"><!--mce:1--></script>

Finally we completed 90% of our code. Its time for retrieving original URL from alias URL and also increment the count to show that the alias name was used.

We call this as original.php, in the page we grab the alias name check in out database and if found we pull the original URL else give an error showing that it is an invalid alias name.

01.$Not_Found = "reminder.html"; // The page to redirect to if no redirect link is found in the database.

02.$get_alias = $_SERVER['QUERY_STRING'];

03.$sql = mysql_query("SELECT url FROM url_tables WHERE alias='$get_alias'");

04. $site_arr = mysql_fetch_array($sql);

05. $site_redirect = $site_arr['url'];

06. if(!$site_arr){ header("Location: $Not_Found"); }

07. if($site_arr){

08. mysql_query("UPDATE url_tables SET ount = count + 1 WHERE alias='$get_alias'");

09. header("Location: $site_redirect");

10. }

$Not_Found is used to display a page if the alias name is invalid. And the remaining part is to query using Alias name as the ID and jump to the original URL. We also increment count = count + 1

Now making the magic of URL. Actually the above code works like this: http://gotiny.co.cc/original.php?example but we have to change it to http://gotiny.co.cc/example this is done by creating a .htaccess file
Here is the code:

RewriteEngine On
RewriteRule ^([a-zA-Z0-9_-]+)$ original.php?$1
RewriteRule ^([a-zA-Z0-9_-]+)/$ original.php?$1
ErrorDocument 404 /errror404.htm

At last we completed a bit.ly kind of site.

Popularity: 9% [?]

(1 votes, average: 5.00 out of 5)

 Loading ...

HostGator.com Black Friday 75% off ANY HOSTING/PACKAGE!!!!!

HOSTGATOR 75% DISCOUNT OFFER ON ANY HOSTING/PACKAGE!!!!! FOR TODAY ONLY

JUST PAY $29.85 (with discount) for 1 year Baby Plan (unlimited domain & unlimited hosting Space) of Hostgator for today only !!!! GRAB IT NOW .

Follow the step to get it offer :-

1. Click Here to Use the HOSTGATOR Coupon Code to visit the offer site.

2. Select your hosting package

3. In “Order Wizard” Page, Select your desired domain option , then click on “NEXT”

4. In Next Page , Check everything then replace “AUTUMN” coupon with “75OFF” (without quote) coupon in Coupon text box ( last text box in this page) then click on “Calculate Totals” (IT MUST BE DONE BEFORE CHECKOUT).

5. Check everything and pay ( I have attached a screenshot below that you will get if you choose 1 year Baby Hosting Plan.)

To Your Success

Sheriff

Popularity: 5% [?]

(1 votes, average: 5.00 out of 5)

 Loading ...

Have valid Paypal Account – Get $1 for Free [Earn upto $100 before offer ends ]

Current Mood: Happy

Hurry!

100% Guaranteed Money! Don’t Miss this offer before Ends. Today only i made $23

Paypal is running a contest called Paypal wishlist

If you are on facebook add this application You will get $1 once you are in.

==> http://sheriffonline.com/Recommends/Get1DollarFree

Just see the application page on how to earn $100

Please feel free to contact me for any assistance.

Hope this helps you

Always in Your Success
Sheriff

Popularity: 4% [?]

(1 votes, average: 5.00 out of 5)

 Loading ...

‘Exit Profit Generator Version 2.0′ With Master Resell Rights!

Exit Profit Generator Version 2.0

Reduce Your Exit Trafic For Profits

“Finally, an easy way to squeeze more profit out of your exit traffic!”

Exit Profit Generator is a small php script you can use to generate mini ‘exit traffic marketers’ for as many websites you want.  As soon as the  EPG gets a sense someone is about to leave your site it jumps into action, funnelling the traffic where you want it to go before its gone forever.

You can generate an infinite number of these “mini marketers” and put them on any web page you want.  All you have to do is add one line of JavaScript code to the web page.  So easy to do, even a caveman can do it!

Once you have your HTML ready for your popup, it will only take about 30 seconds!  And not to worry, full directions are provided.

NEW FEATURES JUST ADDED FOR VERSION 2.0:
You can now preview the overlay images and simply choose the one you want with the click of a radio button!
You now have a “Test” button to see what your popup will look like before you add it to your website!
You can now choose how many times your popup shows up per visit: always, 1 time, 2 times, etc!

“If You Can Click, Copy, and Paste, You Can Use “Exit Profit Generator!”

Here are just some of the ways you will benefit when you start using ‘Exit Profit Generator’ today!

• Build Your Opt-In List – Mention whatever free gifts you give away to get more people to opt in to your list.
• Promoting Affiliate Programs – Make sure everyone knows about the latest affiliate program you’re promoting just as they try to leave your site.
• Special Offers – Offer a discount or additional bonus to encourage those who were on the fence to order your products, your conversions will jump thru the roof!
• Pre-built Salesmen – Give your affiliates EPG code they can add to their websites to promote your products.  They’re happy because they increase their commissions, and when they make more money, you do too.
• Exit Surveys – Ask your visitors why they are leaving and you’ll get all the information you need to improve your offer and increase your profits!
• Building Anticipation – Get people buzzing about an upcoming promotion of yours.  Give them a little taster of what they can expect to see soon.
• Audio / Video Messages – Load audio or video messages to remind your prospects of your products main benefit or what they stand to lose by not taking action immediately.

Price :I received this package as Giveaway Rights So which costs $.0.00 with Master Resell Rights.

Download Exit Profit Generator With Master Resell Rights

Please Post Your Comments if you really like this product. I was suffering from chicken gunea for past 10 days, so that i was unable to come online to post here, i eill recover my body condition soon. i will be coming with more giveaway products and new products soon..

To Your Success

Sheriff

Popularity: 5% [?]

(No Ratings Yet)

 Loading ...

Have you ever seen physical PLR products?

Current Mood: Happy

Dear Fellow Marketers,

I have little doubt that you are familiar with Jeremy Burns’ PLR
sales if you have been online long.

I just bought his latest package which to my surprise was 10
“Physical Products” all with PLR.

I always love PLR products because there is so much you can do
to make them your own, but this is really taking PLR to a new
level.

These products came with full websites and great squeeze page
videos, there is nothing left out.

http://sheriffonline.com/Recommends/vgoldmine

The cool thing about these PLR products being physical is that
anyone can finally have their own high ticket products to sell
online.

The most important part though is the totally crazy fast action
bonus Jeremy has for the first 175 people. Here is giving away
PLR rights to his 17 disk Camtasia Cash Secrets course totally
free if you act fast.

http://sheriffonline.com/Recommends/vgoldmine

These sales sell out fast but with this fast action bonus you
may already be too late, check this out NOW.

Best regards,
Sheriff

P.S. Even if you miss the fast action bonus this is still one
heck of a deal, so don’t miss it
http://sheriffonline.com/Recommends/vgoldmine

Popularity: 1% [?]

(No Ratings Yet)

 Loading ...

Instant Website Traffic Promo Video – Earn $1 Per Referral

Current Mood: Cool

Hi Fellow Marketers!

If you can use more website visitors and online advertising, you’ll want to read this message…

Instant Website Traffic is a new site that will boost your web traffic and get your promotions in front of more visitors, guaranteed. How does it work? Simple. You make 1 small change in what you’re doing (takes about 30 seconds) and that’s it! You will see MORE web traffic and MORE ad views automatically.

And the best part is that the traffic you get CONVERTS! Too many so-called traffic tools focus on hits or visitors, but that’s useless UNLESS you get new signups and sales. And that’s where Instant Website Traffic shines…they show PROOF of the amazing conversion rates and you’ll need to see it to believe it!

Now if it sounds too good to be true, let me assure you:

- You do NOT have to trade time or manual effort for traffic

- You do NOT have to install anything on your computer

- You do NOT have to paste tedious HTML code on your webpages

- You do NOT need to know anything about programming

- You do NOT have to agree to getting slammed with ads yourself

- You WILL increase your traffic and advertising, guaranteed

- It WILL work for you regardless of what niche you’re in

- It IS 100% legal, 100% ethical, and 100% “above board”

- You WILL be reaching REAL prospects who want to buy your offers

- The traffic and advertising you gain will INCREASE the longer you use it

As you can see, this tool is REAL and it just plain works! Check it out:

http://instant-website-traffic.com/vip/2269

Good Luck
Sheriff

Popularity: 1% [?]

(No Ratings Yet)

 Loading ...