how to create your own URL-Shortener<\/a>. I decide to improve it, creating a simple system to control the number of access<\/p>\nFirst of all you need to add some tables to your data base: <\/p>\n
[code lang=”sql”]CREATE TABLE access (
\n aid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\n urls_uid INTEGER UNSIGNED NOT NULL,
\n information_iid INTEGER UNSIGNED NOT NULL,
\n date DATE NULL,
\n PRIMARY KEY(aid),
\n INDEX access_FKIndex1(information_iid),
\n INDEX access_FKIndex2(urls_uid)
\n);<\/p>\n
CREATE TABLE information (
\n iid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\n ip VARCHAR(255) NULL,
\n PRIMARY KEY(iid)
\n);[\/code]<\/p>\n
After this you should do a modification in your function-little-url.php in the function take_url($url):<\/p>\n
[code lang=”php”]function take_lurl($lurl) {
\n\tglobal $link;
\n\t$q = “SELECT * FROM `urls` WHERE `unique_chars` = ‘”.$lurl.”‘”;
\n\t$r = mysql_query($q, $link); \/\/ Realiza consulta.
\n\tif(mysql_num_rows($r)>0) {
\n\t\t $info = mysql_fetch_array($r);
\n\t\t $url = $info[“url”]; \/\/ Pega endere\u00e7o real
\n\t\t $uid = $info[“uid”]; \/\/ Pega ID do endere\u00e7o
\n\t\t $ip = $_SERVER[‘REMOTE_ADDR’]; \/\/ Pega IP do usu\u00e1rio
\n\t\t $qr = “select iid from `information` where ip = ‘”.$ip.”‘” ;
\n\t\t $rr = mysql_query($qr, $link); \/\/ Procura se este IP j\u00e1 est\u00e1 no banco de dados
\n\t\t if(mysql_num_rows($rr)>0) { \/\/ Caso esteja insere somente um acesso novo proveniente deste IP
\n\t\t\t$iid = mysql_result($rr,0,”iid”);
\n\t\t\tmysql_query(“INSERT INTO `access` (urls_uid,information_iid,date) values (“.$uid.”, “.$iid.”, now())”, $link);
\n\t\t } else { \/\/ Caso n\u00e3o esteja, cria um registro com este IP e ap\u00f3s cria um acesso.
\n\t\t\t$qr = mysql_query(“INSERT INTO `information` (ip) values (‘”.$ip.”‘)”, $link);
\n\t\t\t$iid = mysql_insert_id($qr);
\n\t\t\tmysql_query(“INSERT INTO `access` (urls_uid,information_iid,date) values (“.$uid.”, “.$iid.”, now())”, $link);
\n\t\t }
\n\t} else {
\n\t\techo “Sorry, link not found!”;
\n\t}
\n\treturn $url;
\n}[\/code]<\/p>\n
In this System there is a table with IPs that already accessed\tsome URL, when a URL is accessed it verify the IP, if it is on the table just create an access to this IP in the new address. Otherwise, add the IP and create the access to the address.<\/p>\n
How to create a URL-Shortener with Statistics<\/a><\/p>\nMatheus<\/p>\n
<\/p>","protected":false},"excerpt":{"rendered":"
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…<\/p>\n
Continue readingStatistics on your URL Shortener.<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[78,69],"tags":[11,9,80,325,323,13,79],"class_list":["post-336","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php","tag-como-fazer","tag-howto","tag-little-url","tag-mysql","tag-php","tag-programacao","tag-tinyurl","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/psjGE-5q","_links":{"self":[{"href":"https:\/\/wordpress.matbra.com\/en\/wp-json\/wp\/v2\/posts\/336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.matbra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.matbra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.matbra.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.matbra.com\/en\/wp-json\/wp\/v2\/comments?post=336"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.matbra.com\/en\/wp-json\/wp\/v2\/posts\/336\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.matbra.com\/en\/wp-json\/wp\/v2\/media?parent=336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.matbra.com\/en\/wp-json\/wp\/v2\/categories?post=336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.matbra.com\/en\/wp-json\/wp\/v2\/tags?post=336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}