mysql kısmı
CREATE TABLE banners (
sirano int(11) NOT NULL auto_increment,
url varchar(50) default NULL,
banner varchar(50) default NULL,
PRIMARY KEY (sirano)
) TYPE=MyISAM;
INSERT INTO banners VALUES (1,'http://fedora.redhat.com','http://destan.sdu.edu.tr/resimler/redhat.jpg');
INSERT INTO banners VALUES (2,'http://www.debian.org','http://destan.sdu.edu.tr/resimler/debian.jpg');
INSERT INTO banners VALUES (3,'http://destan.sdu.edu.tr','http://destan.sdu.edu.tr/resimler/ismail.gif');
INSERT INTO banners VALUES (4,'http://www.suse.de','http://destan.sdu.edu.tr/resimler/suse.png');
php kısmı
<HTML>
<HEAD>
<meta http-equiv="Content-Type" Content="text/html; charset=UTF-8">
<meta http-equiv="Content-Language" Content="tr">
<title>Desto Rastgele Banner</title>
</HEAD>
</HTML>
<?php
/*****************************************************************************
* Kod : Destan YILANCI *
* eposta : destan@sdu.edu.tr *
* Konu : PHP ve MYSQL ile rastgele banner gösterimi *
* Calisir hali : http://destan.sdu.edu.tr/banner.php *
*****************************************************************************/
mysql_connect("localhost", "kullaniciadi", "vesifreniz");
mysql_select_db("destan"); // veri tabaninizin adi neyse onu yazin
$sorgu = mysql_query("select * from banners order by rand() Limit 0,2"); // Limit 0 dan baslar 2 adet veri ceker
if(!mysql_num_rows($sorgu))
{
echo "Banner Hatası";
}
else
{
while($res = mysql_fetch_array($sorgu))
{
$url = $res['url'];
$banner = $res['banner'];
echo "<a href=\"$url\"
target=\"_self\"><img src=\"$banner\" alt=\"\" border=\"0\"></a>";
}
}
?> 