Ir ao conteúdo

Gráficos para seu Tiny URL.

Publicado por Matheus (X-warrior) Bratfisch em julho 4, 2009

Boa tarde,

Ontem adicionei controle de estatísticas no Tiny URL, criei 2 tabelas para isso. Porém para consultar você precisava acessar o banco de dados manualmente. Resolvi fazer algo mais decente e criar uns gráficos de acessos dos últimos 30 dias. Pensei em utilizar a Chart API do Google mas ai me lembrei dos gráficos que eram gerados pelo WordPress Stats, dando uma olhada nele descobri o Open Flash Chart. Achei ele mais bonito e com as mesmas funcionalidades do Chart do Google. Então decidi implementar o gráfico com ele.

As novas funções implementadas foram:
getAccess($id) – Tem por função retornar um Array associativo com os números de acessos por data e o total de acessos.
formatData($data) – Recebe os acessos do getAccess e transforma em um array numérico. (Formato necessário para o chart ser gerado)
criarLabels() – Cria os labels para exibição na parte inferior do gráfico.

Para acessar as informações ainda não fiz uma página com a listagem dos domínios, você deve acessar manualmente o endereço http://www.seusite.com/diretorio/chart.php?id=ID onde ID é o UID da tabela URLS. Assim você obterá um gráfico de acessos ao domínio do UID nos últimos 30 dias.

Exemplo de exibição:


Tiny URL, com estatísticas e exibição em gráfico

Como criar seu próprio tiny url
Estatísticas no seu Tiny URL

Espero que seja util para você,
Matheus

PS2: Para seu Tiny URL funcionar, você deve adicionar algumas regras de Rewriting. Você pode ver elas em Criar um sistema próprio de Tiny-URL

Publicado emMySQLphp

127 Comentários

  17. Betano Casino Auszahlungszeit Betano Casino Auszahlungszeit

    Im HitnSpin Casino kann man deutschen Spielern einen umfangreichen Sportwettenbereich
    mit über 35 Sportarten anbieten. Das Portfolio umfasst Slots, Crash-Spiele,
    Tischspiele, Sofortgewinnspiele, Live-Casino und Sportwetten. Im Casino hatte man Sorge um
    über 3.000 Spiele, darunter Slots, Tischspiele und Live-Casino.

    Das HitnSpin Casino bietet seinen Nutzern eine riesige Auswahl an Spielen, die
    von zahlreichen renommierten Entwicklern stammen.Natürlich umfasst
    diese Auswahl alle möglichen Typen von Casino Spielen. Auf der höchsten Stufe Hitman erhalten Sie 12% Cashback mit dem gleichen Höchstbetrag.Alle Boni unterliegen 5x Umsatzbedingungen, die vor der Auszahlung beachtet werden müssen. Genau wie beim wöchentlichen Bonus, richtet
    sich die Höhe des Cashbacks auch nach Ihrer Stufe im Treueprogramm.Auf der zweiten Stufe (Warrior) erhalten Sie einen 3% Cashback und bis zu einem Maximum von 2.000 Euro.

    Neuen Spielern wird im Online Casino von Hit’n’Spin ein dreistufiger Neukundenbonus angeboten. Wie Sie sehen, lohnt es
    sich immer wieder aufs Neue, bei Playcasino.com vorbeizuschauen, um sich
    exklusive Casino Boni zu sichern. Zum einen konnten wir dabei eine SSL-Verschlüsselung vorfinden sowie
    die Antiviren-Software von McAfee Secure.

    References:
    https://online-spielhallen.de/leon-casino-erfahrungen-ein-umfassender-uberblick-fur-spieler/

    # dezembro 21, 2025
  24. ultimate guide Las Vegas casinos ultimate guide Las Vegas casinos

    Check-out time is at 11am, unless you have reserved a package that includes a later check-out time. Relax as our dedicated staff ensure a seamless dining experience in the comfort of your room. Awarded to only a handful of an elite group of hotels around the world every year, this year’s award marks the fifth consecutive year for Crown Towers Melbourne and the second consecutive year for Crown Towers Perth.
    Escape to a world of excitement during your next stay and enjoy one of the many experiences on offer, including theatre shows, live music, gaming, live sports, an indulgent spa treatment or a visit to one of our many restaurants or bars on site. Experience the pinnacle of premium dining at Crown Perth’s top hotel restaurants, such as Epicurean, Nobu, Silks, Modo Mio, Atrium Buffet, and Rockpool Bar & Grill. Crown Perth offers a diverse range of casino titles, with around 2,500 of the latest pokies machines and 350 table games registered. From an exceptional 24-hour butler service and lavish amenities to exclusive dining experiences from our renowned restaurants, the Villas are a perfect choice for guests wanting the ultimate luxurious stay at Crown Towers. Late check-outs are not available Friday, Saturday, Sunday, during school holidays, special events or when the hotels are running at high occupancy.

    References:
    https://blackcoin.co/imperial-poker/

    # dezembro 27, 2025
  25. best payout online casino Australia best payout online casino Australia

    Discover the premier casino and resort complex
    in Perth — home to gaming, fine dining, theatre shows, luxury hotels, and spa retreats all in one destination. Escape to a world of excitement during your next
    stay and enjoy one of the many experiences on offer, including theatre shows, live music, gaming, live sports,
    an indulgent spa treatment or a visit to one of our many restaurants or bars
    on site. Just show your Crown Rewards Card when you pay or play and you can start earning points, which
    you can redeem for Crown experiences like dining,
    gaming, hotels stays and much more.
    You can also visit the Keno Lounge, which is a dedicated seating area for Keno
    players and located next to Carbon Sports Bar.

    There are games every few minutes so play your lucky numbers today.
    You will be prompted to provide a credit card as guarantee, no charges will apply.
    Children aged 12 and under are invited to enjoy
    the indoor excitement of The Kids Hub at the pool.

    References:
    https://blackcoin.co/jeetcity-casino-a-comprehensive-review/

    # dezembro 27, 2025

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *