if (array_key_exists("bhasi",$_GET)) {
$bhasi=$_GET['bhasi'];
}
else {
$bhasi=0;
}
//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 = "testuak";
$Link = mysql_connect ($Host, $User, $Password);
//Argazkien taulara konektatzeko datuak
$AHost = "localhost";
$AUser = "myerreferentzia";
$APassword = "iztne";
$ADBName = "erreferentzia";
$ATaularenizena = "argazkiak";
$ALink = mysql_connect ($AHost, $AUser, $APassword);
//Bildumako argazkiak aterako ditugu
$Argazkiak="SELECT * FROM $ATaularenizena WHERE idd=30 ORDER BY id DESC";
$Argazkiak_ikus=mysql_db_query($ADBName, $Argazkiak, $ALink);
$argazkiak_zenbat=mysql_num_rows($Argazkiak_ikus);
//Bildumako argazkien randoma egingo dugu
srand ((double)microtime()*1000000);
$randoma=rand(1,$argazkiak_zenbat);
//Aleatorioki argazki bat erakutsiko dugu
$i=0;
while ($Argazkiak_erakus=mysql_fetch_array($Argazkiak_ikus)){
$i++;
if ($i==$randoma){
$argazid=$Argazkiak_erakus[id];
$argazidd=$Argazkiak_erakus[idd];
}
}
//Jarraia datu basean sartuko gera
$EHost = "localhost";
$EUser = "ksarasol";
$EPassword = "davant";
$EDBName = "edjarraia";
$ETaularenizena = "inkestak";
$ELink = mysql_connect ($EHost, $EUser, $EPassword);
//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";
//Berriak aterako ditugu
$Albistea="SELECT * FROM $Taularenizena WHERE mota='berria' AND idd=31 ORDER BY datates DESC, id DESC LIMIT 1";
$Albistea_ikus=mysql_db_query($DBName, $Albistea, $Link);
//Berri kopuru totala aterako dugu
$Berriak="SELECT * FROM $Taularenizena WHERE mota='berria' AND idd=31";
$Berriak_ikus=mysql_db_query($DBName, $Berriak, $Link);
$zenbat_berri=mysql_num_rows($Berriak_ikus);
//Pantallazo bakoitzeko zenbat erregistro erakutsiko ditugun definituko dugu
$zbt=20;
?>
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 "";
}
?>
|
|
|
//Erakutsiko ditugun balorerak definituko ditugu
if ($zenbat_berri!=''){
$nondik=$bhasi + 1;
}else{
$nondik=0;
}
$nora=$bhasi + $zbt;
if ($nora>$zenbat_berri){
$nora=$zenbat_berri;
}
?>
 |
|
if ($bhasi>1){
$bhasi1=$bhasi-$zbt;
echo " ";
echo "  | ";
echo " ";
echo " ";
echo "  | ";
echo " ";
echo " ";
echo "  | ";
echo " ";
echo " ";
echo " ";
echo " <<< Aurrekoak l";
echo " | ";
echo " ";
echo " ";
echo "  | ";
echo " ";
echo " ";
echo "  | ";
echo " ";
echo " ";
echo "  | ";
echo " ";
}
?>
//Hemen hasten da eguneko berrien zerrenda
echo "";
if ($bhasi<=1){
while($Albistea_erakus=mysql_fetch_array($Albistea_ikus)){
echo " ";
echo "  | ";
echo " ";
echo "";
echo "$Albistea_erakus[datates] | ";
echo " ";
echo "";
echo "";
if ($Albistea_erakus[aurretitularra]!=''){
echo "$Albistea_erakus[aurretitularra] ";
}
echo "$Albistea_erakus[titularra] | ";
echo " ";
echo "";
echo " | ";
echo " ";
echo "";
echo "$Albistea_erakus[azpititularra] | ";
echo " ";
echo "";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo " ";
}
}
$Besteak="SELECT * FROM $Taularenizena WHERE mota='berria' AND idd=31 ORDER BY datates DESC, id DESC LIMIT $bhasi,$zbt";
$Besteak_ikus=mysql_db_query($DBName, $Besteak, $Link);
$Besteak_zenbat=mysql_num_rows($Besteak_ikus);
$i=0;
if ($bhasi<=1){
//Lehenengo pantailazoan bagaude, berriak bigarrenetik aurrera erakutsiko ditugu
while ($Besteak_erakus=mysql_fetch_array($Besteak_ikus)){
$i++;
//hemen bigarrenetik aurrera
if ($i>1){
echo "";
echo "$Besteak_erakus[datates] | ";
echo " ";
echo " ";
echo "";
if ($Besteak_erakus[aurretitularra]!=''){
echo "$Besteak_erakus[aurretitularra] ";
}
echo "$Besteak_erakus[titularra] | ";
echo " ";
echo "";
echo " | ";
echo " ";
echo "";
echo "$Besteak_erakus[azpititularra] | ";
echo " ";
if ($i<$Besteak_zenbat){
echo " ";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo " ";
}//Bigarren "if"arena
}//Lehenego "if"arena
}//while-arena
}else{
while ($Besteak_erakus=mysql_fetch_array($Besteak_ikus)){
$i++;
//Ondorengo pantailetan sarrera guztiak erakutsiko ditugu
echo "";
echo "$Besteak_erakus[datates] | ";
echo " ";
echo " ";
echo "";
if ($Besteak_erakus[aurretitularra]!=''){
echo "$Besteak_erakus[aurretitularra] ";
}
echo "$Besteak_erakus[titularra] | ";
echo " ";
echo "";
echo " | ";
echo " ";
echo "";
echo "$Besteak_erakus[azpititularra] | ";
echo " ";
if ($i<$Besteak_zenbat){
echo " ";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo " ";
}//Bigarren "if"arena
}//while-arena
}//"else"rena
echo " ";
//hemen bukatzen da taula
?>
|
$Bazkena = $bhasi + $zbt;
if ($Bazkena > $zenbat_berri){
$Bazkena = $zenbat_berri;
}
if ($Bazkena<$zenbat_berri){
$bhasi2=$Bazkena++;
echo " ";
echo "  | ";
echo " ";
echo " ";
echo "  | ";
echo " ";
echo " ";
echo "  | ";
echo " ";
echo " ";
echo " ";
echo " l Hurrengoak >>> ";
echo " | ";
echo " ";
echo " ";
echo "  | ";
echo " ";
echo " ";
echo "  | ";
echo " ";
echo " ";
echo "  | ";
echo " ";
}
?>
|
|
|
|
|
|
|
©
Berria.info 2004 |
|