//Eguna definitu
$gaurkodata=date("Y-m-d");
$noiz=date("Y-m-d".", "."H:i");
//Datu basean sartuko gara eta goian definitutako datuak sartuko ditugu
$Host = "localhost";
$User = "myerreferentzia";
$Password = "iztne";
$DBName = "erreferentzia";
$Taularenizena = "argazkiak";
$Link = mysql_connect ($Host, $User, $Password);
//Jarraia datu basean sartuko gera
$EHost = "localhost";
$EUser = "ksarasol";
$EPassword = "davant";
$EDBName = "edjarraia";
$ETaularenizena = "inkestak";
$ELink = mysql_connect ($EHost, $EUser, $EPassword);
//Bestelakoak datu basean sartuko gara
$BHost = "localhost";
$BUser = "mybestela";
$BPassword = "aletse";
$BDBName = "bestelakoak";
$BTaularenizena = "hauteskundeak";
$BLink = mysql_connect ($BHost, $BUser, $BPassword);
//Hilabeteak definitu
$hila[1]="urtarrilak";
$hila[2]="otsailak";
$hila[3]="martxoak";
$hila[4]="apirilak";
$hila[5]="maiatzak";
$hila[6]="ekainak";
$hila[7]="uztailak";
$hila[8]="abuztuak";
$hila[9]="irailak";
$hila[10]="urriak";
$hila[11]="azaroak";
$hila[12]="abenduak";
//Astegunak definitu
$astegun[1]="Astelehena";
$astegun[2]="Asteartea";
$astegun[3]="Asteazkena";
$astegun[4]="Osteguna";
$astegun[5]="Ostirala";
$astegun[6]="Larunbata";
$astegun[7]="Igandea";
//Azken argazkia aterako ditugu
$Argazkia="SELECT * FROM $Taularenizena WHERE idd=30 ORDER BY id DESC LIMIT 1";
$Argazkia_ikus=mysql_db_query($DBName, $Argazkia, $Link);
//Gainerako argazkiak zerrendatuko ditugu
$Besteak="SELECT * FROm argazkiak WHERE idd=30 ORDER BY id DESC";
$Besteak_ikus=mysql_db_query($DBName, $Besteak, $Link);
$besteak_zenbat=mysql_num_rows($Besteak_ikus);
?>
Berria.eus - Frantziako Tourra
 |
|
//Datu basera konektatzeko datuak definitzen ditugu
$THost = "localhost";
$TUser = "mybestela";
$TPassword = "aletse";
$TDBName = "bestelakoak";
$TTaularenizena = "txirrindularitzaweb";
$TLink = mysql_connect ($THost, $TUser, $TPassword);
$esanetapa="SELECT * FROM txirrindularitzaweb WHERE froga='Tourra04' ORDER BY data ASC";
//echo $esanetapa;
$ik_esanetapa=mysql_db_query($TDBName,$esanetapa,$TLink);
$zenbat_esanetapa=mysql_num_rows($ik_esanetapa);
//echo $zenbat_esanetapa;
if ($zenbat_esanetapa!=0){
echo "";
}
?>
|
|
|
|
 |
|
|
 |
//Gainerako argazkien zerrenda erakusteko taula $i=0;
echo "";
$zenbagarren=0;
$i=0;
while ($Besteak_erakus=mysql_fetch_array($Besteak_ikus)){
$zenbagarren++;
$i++;
if ($zenbagarren>3){
$zenbagarren=1;
}
//Argazkiaren taula hemen hasten da
echo "";
echo "";
echo "";
echo " | ";
echo " ";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo " | ";
echo " ";
echo " | ";
echo " ";
echo " | ";
echo " ";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo " ";
echo " | ";
if (($zenbagarren==1) && ($i==$besteak_zenbat)){
echo " | ";
echo " | ";
echo " | ";
}
if (($zenbagarren==2) && ($i==$besteak_zenbat)){
echo " | ";
echo " | ";
echo " | ";
}
if (($zenbagarren!=3) && ($i!=$besteak_zenbat)){
echo " | ";
echo " | ";
echo " | ";
}
//Argazkiaren taula hemen bukatzen da
if (($zenbagarren==3) && ($i!=$besteak_zenbat)){
echo " ";
echo "";
echo " | ";
echo " ";
echo "";
}
}
echo " ";
?>
|
|
 |
|
|
|
 |
|
|
©
Berria.info 2004 |
|