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 the number of access
First of all you need to add some tables to your data base:
[code lang=”sql”]CREATE TABLE access (
aid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
urls_uid INTEGER UNSIGNED NOT NULL,
information_iid INTEGER UNSIGNED NOT NULL,
date DATE NULL,
PRIMARY KEY(aid),
INDEX access_FKIndex1(information_iid),
INDEX access_FKIndex2(urls_uid)
);
CREATE TABLE information (
iid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
ip VARCHAR(255) NULL,
PRIMARY KEY(iid)
);[/code]
After this you should do a modification in your function-little-url.php in the function take_url($url):
[code lang=”php”]function take_lurl($lurl) {
global $link;
$q = “SELECT * FROM `urls` WHERE `unique_chars` = ‘”.$lurl.”‘”;
$r = mysql_query($q, $link); // Realiza consulta.
if(mysql_num_rows($r)>0) {
$info = mysql_fetch_array($r);
$url = $info[“url”]; // Pega endereço real
$uid = $info[“uid”]; // Pega ID do endereço
$ip = $_SERVER[‘REMOTE_ADDR’]; // Pega IP do usuário
$qr = “select iid from `information` where ip = ‘”.$ip.”‘” ;
$rr = mysql_query($qr, $link); // Procura se este IP já está no banco de dados
if(mysql_num_rows($rr)>0) { // Caso esteja insere somente um acesso novo proveniente deste IP
$iid = mysql_result($rr,0,”iid”);
mysql_query(“INSERT INTO `access` (urls_uid,information_iid,date) values (“.$uid.”, “.$iid.”, now())”, $link);
} else { // Caso não esteja, cria um registro com este IP e após cria um acesso.
$qr = mysql_query(“INSERT INTO `information` (ip) values (‘”.$ip.”‘)”, $link);
$iid = mysql_insert_id($qr);
mysql_query(“INSERT INTO `access` (urls_uid,information_iid,date) values (“.$uid.”, “.$iid.”, now())”, $link);
}
} else {
echo “Sorry, link not found!”;
}
return $url;
}[/code]
In this System there is a table with IPs that already accessed some 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.
How to create a URL-Shortener with Statistics
Matheus
[…] Como criar seu próprio tiny url Estatísticas no seu Tiny URL […]
**mitolyn official**
Mitolyn is a carefully developed, plant-based formula created to help support metabolic efficiency and encourage healthy, lasting weight management.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you. https://www.binance.info/ur/register?ref=SZSSS70P
canadian pharmacies top best
canada pharmaceuticals online
canadian discount online pharmacy
foreign online pharmacy
canada prescriptions
medications without prescription
list of canadian pharmacies
reputable online canadian pharmacy
Vavada to znane kasyno online, które działa również w Polsce. Strona przyciąga graczy szeroką ofertą gier, przejrzystymi warunkami i obsługą w PLN (zł). Bonus powitalny oraz intuicyjna obsługa sprawiają, że platforma zdobyła popularność wśród polskich użytkowników.
https://888starz.net.co/
888Starz Colombia es una plataforma de casino online y casa de apuestas que cuenta con mas de 9.500 juegos disponibles, entre los que se incluyen maquinas tragamonedas, ruletas y mesas con croupier real junto a una variada seleccion de disciplinas deportivas que cubre desde la Liga BetPlay hasta la Champions League y esports.
Kasyno vavada systematycznie buduje swoją pozycję wśród polskim graczom, oferując kompletną lokalizację w języku polskim. Vavada casino zapewnia metody płatności dostosowane do lokalnego rynku, a vavada pl umożliwia łatwy dostęp dla graczy z Polski. Oficjalną stronę vavada kasyno odwiedzają głównie doświadczonych graczy, którzy doceniają atrakcyjne bonusy i program lojalnościowy.
https://luckia.net.co/
Luckia Casino, tras mas de 20 anos en el sector desde su fundacion en 2002, se ha consolidado como un operador de casino virtual y apuestas en deportes de referencia para el mercado hispanohablante, con Colombia incluida en 2026.
Slottica Casino zbudowaliśmy z myślą o graczach z Polski, którzy szukają jednego miejsca do wszystkiego – od automatów i kasyna na żywo po zakłady sportowe i e-sport. U nas znajdziesz ponad 20 000 gier od ponad 250 dostawców, w tym największe nazwiska branży, design działający równie dobrze na desktopie i telefonach, codzienne loterie, kwartalny konkurs Season’s Battle z nagrodami rzeczowymi (telewizory Samsung, MacBook Air, gadżety) oraz bogaty program turniejowy. Slottica Kasyno to też rozbudowany system bonusów – pakiet powitalny, cashback, prezenty urodzinowe, bonusy za polecenie znajomych i premie za pobranie aplikacji – a do tego wsparcie po polsku dostępne całą dobę przez czat. Dla nas liczy się to, żebyś mógł grać tak, jak lubisz: bez ograniczeń godzin, bez ukrytych warunków, z pełną kontrolą nad limitami i kontem.
Adult content site offers a range of videos for adult entertainment.
Select reliable platforms for a safe experience.
Feel free to visit my page: buy xanax without prescrition
Wow! This platform is truly addictive! The library of shemale porn videos is insane – loads of stunning trans girls in premium scenes.
The loading is fast and flawless and new videos are added all the time.
If you’re want to watch shemale porn videos featuring hot performers and real action, this is hands down the best spot.
Totally recommended!
Waar porno te kijken door betrouwbare adult platforms BUY VIAGRA ONLINE te verkennen.
Ontdek betrouwbare porno hubs voor een private ervaring.
Fantastic! This platform is absolutely top-notch!
The collection of tranny porn videos is unbelievable –
loads of stunning trans girls in crystal-clear scenes.
The playback is butter-smooth and new videos are added frequently.
If you’re want to watch shemale sex videos porn videos featuring seductive performers and raw action, this is without a doubt the perfect spot.
Totally recommended!
Top adult platforms provide premium content for mature audiences.
Explore secure hubs for quality and privacy.
my webpage buy viagra online
Top porn sites deliver high-quality explicit content safely.
Opt for trusted sources for a discreet experience.
Also visit my webpage … buy viagra Online
Content for adults can be accessed through secure and reputable websites.
Explore trusted platforms for quality content.
Visit my blog … buy viagra
Expliciete video’s kunnen worden gestreamd op betrouwbare
platforms voor privacy. Ontdek veilige websites voor kwaliteitsweergave.
my web blog: BUY VIAGRA ONLINE
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Wow! This platform is absolutely addictive! The library of tranny porn videos is massive – loads of sexy trans girls in high-quality
scenes. The playback is super smooth and new videos are added frequently.
If you’re searching for a place to watch shemale xxx porn videos featuring hot performers
and real action, this is without a doubt the ultimate spot.
Strongly recommended!
Amazing! This platform is absolutely addictive! The library of tranny porn videos is insane – so many stunning trans girls in crystal-clear scenes.
The playback is butter-smooth and new content are added every day.
If you’re looking to watch shemale blowjob porn videos featuring seductive performers and real action, this
is hands down the perfect spot. Totally recommended!
Beste pornosites bieden hoogwaardige inhoud voor volwassen entertainment.
Kies voor betrouwbare hubs voor een veilige en plezierige ervaring.
Review my website: buy viagra
Hey there, You have performed a fantastic job. I’ll certainly digg it and in my view suggest to my friends. I’m confident they will be benefited from this website.
Nieuwe pornosites brengen innovatieve inhoud voor
volwassen entertainment. Ontdek betrouwbare frisse sites voor een moderne ervaring.
My web page BUY VIAGRA ONLINE
Premier xxx platforms offer high-quality content
for adult entertainment. Choose trusted platforms for a safe and
enjoyable experience.
Also visit my web blog online viagra pharmacy
At this time it appears like WordPress is the best blogging platform out there right now. (from what I’ve read) Is that what you’re using on your blog?
Greate article. Keep writing such kind of information on your page. Im really impressed by it.
The other day, while I was at work, my sister stole my iphone and tested to see if it can survive a 30 foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views. I know this is entirely off topic but I had to share it with someone!
Greate article. Keep writing such kind of info on your site. Im really impressed by it.
At this time it looks like Movable Type is the top blogging platform available right now. (from what I’ve read) Is that what you are using on your blog?
Can I simply say what a relief to find a person that genuinely knows what they are talking about online. You certainly realize how to bring an issue to light and make it important. More and more people need to look at this and understand this side of your story. It’s surprising you aren’t more popular given that you most certainly have the gift.
Excellent article. Keep writing such kind of information on your blog. Im really impressed by your blog.
Right now it seems like BlogEngine is the top blogging platform available right now. (from what I’ve read) Is that what you are using on your blog?