View previous topic :: View next topic |
Author |
Message |
Tiho
Joined: 10 May 2004 Posts: 14 Location: VT
|
Posted: 18.06.2004 00:14 Post subject: Link hits |
|
|
Jel zna neko gdje nac skriptu koja broji "hits" na linkove? Ja sam trazio po puno scripts stranicama i nama bas neki izbor (sve se placaju). hvala !!! |
|
|
Back to top |
|
|
Phiber
Joined: 18 Apr 2004 Posts: 319 Location: Čakovec, Kroejša
|
Posted: 18.06.2004 00:44 Post subject: |
|
|
ako imas mogucnost php-a i mysql-a, evo ti skripta pisana on-the-fly:
u bazu stavi ovo:
Code: |
CREATE TABLE `linkovi` (
`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`klikova` INT( 10 ) NOT NULL ,
`link` VARCHAR( 200 ) NOT NULL ,
UNIQUE (
`id`
)
);
|
u index.php stavi ovo:
Code: |
<?php
$host="localhost";
$username="username";
$password="password";
$baza="baza";
mysql_connect($host,$username,$password);
mysql_selectdb($baza);
function broj_klikova($id)
{
$kveri=mysql_query("select klikova from linkovi where id='$id'");
list($klikova)=mysql_fetch_row($kveri);
echo $klikova;
}
?>
|
i sad pises linkove ovako:
Code: |
ovo vam je <a href="redirect.php?id=1" target="_blank">link br. jedan(<?php broj_klikova(1); ?> klikova)</a>
|
u index.php na kraj dodas:
Code: |
<?php
mysql_close();
?> |
u redirect.php stavis:
Code: |
<?php
$host="localhost";
$username="username";
$password="password";
$baza="baza";
mysql_connect($host,$username,$password);
mysql_selectdb($baza);
$id=$_GET['id'];
$kveri=mysql_query("select link,klikova from linkovi where id='$id'");
list($link,$klikova)=mysql_fetch_row($kveri);
$klikova++;
mysql_query("update linkovi set klikova='$klikova' where id='$id'");
mysql_close();
header("Location: $link");
?>
|
promjeni svaki $host, $username i $password.
linkove stavljas u bazu preko recimo phpmyadmina. (www.phpmyadmin.org)
brojni editi zbog realnih juzernejmova sa lokalnog servera. (kopi pejst
Last edited by Phiber on 18.06.2004 01:31; edited 4 times in total |
_________________ - Xatrix Security news portal -- redizajn napravljen, al radim css
- - TIP / Rapid IT : web design & hosting -- za ovog ne, taj je u ladici |
|
Back to top |
|
|
blackduke mi3.crew
Joined: 08 Sep 2003 Posts: 2681 Location: Zagreb
|
|
Back to top |
|
|
Phiber
Joined: 18 Apr 2004 Posts: 319 Location: Čakovec, Kroejša
|
Posted: 18.06.2004 00:51 Post subject: |
|
|
evo. skripta radi.
a za TEXT baze.... grrrrrrrrrrrrrrr mrzim TEXT baze. ak nemas pristup bazi, a oces sajt furat u php-u, ubi se. |
_________________ - Xatrix Security news portal -- redizajn napravljen, al radim css
- - TIP / Rapid IT : web design & hosting -- za ovog ne, taj je u ladici |
|
Back to top |
|
|
silence
Joined: 24 Apr 2004 Posts: 890 Location: .....ni na nebu, ni na zemlji.....
|
Posted: 18.06.2004 07:19 Post subject: |
|
|
nemojte me ubit za ovaj komentar, ali meni je 100 puta draža mysql_fetch_assoc (),
pogotovo kad objašnjavam nekom ko zna manje od mene (malo je takvih )
ooops..i još jedna sitnica...
Code: |
$id=$_GET['id'];
$kveri=mysql_query("select link,klikova from linkovi where id='$id'");
list($link,$klikova)=mysql_fetch_row($kveri);
$klikova++;
mysql_query("update linkovi set klikova='$klikova' where id='$id'");
|
ovo je increment?...može i ovako :
Code: |
mysql_query ("UPDATE linkovi SET `klikova`=klikova+1 WHERE id='".$_GET['id'].")';
|
ajd kad sam već spomenuo mysql_fetch_assoc () da objasnim....
imaš : list ($link, $kilikova) = mysql_fetch_row ($kveri);
osobno rađe prebacim sve u jednu varijablu, recimo $podaci putem mysql_fetch_assoc()
$podaci = mysql_fetch_assoc( $kveri);
$podaci['link']
$podaci['klikova']
ne znam, nekako mi je prirodnije ovako |
_________________ This End-User License is an agreement between Microsoft Corporation (hereafter referred to as "Microsoft") and you, the end-user (hereafter referred to as "our bitch"). |
|
Back to top |
|
|
Phiber
Joined: 18 Apr 2004 Posts: 319 Location: Čakovec, Kroejša
|
|
Back to top |
|
|
Tiho
Joined: 10 May 2004 Posts: 14 Location: VT
|
Posted: 18.06.2004 17:35 Post subject: Hvala |
|
|
Hvala!! |
|
|
Back to top |
|
|
|