|
$DB="basket";
$Connection = MySQL_Connect("localhost","jiskra","mkjd85246");
MySQL_Select_DB($DB);
if (!$Connection):
echo "nepodarilo se pripojit \n";
break;
endif;
@$zaznam=MySQL_DB_Query("$DB", "SELECT * FROM $table_logo WHERE Param='all' ORDER BY Poradi", $Connection);
$Pocet=MySQL_Num_Rows($zaznam);
if ($Pocet>=1):
$vypis = MySQL_Fetch_Array($zaznam);
$soubor="logo/".$vypis["Name"];
$Size=GetImageSize($soubor);
$Sirka=140;
$koef=$Sirka/$Size[0];
$Vyska=$Size[1]*$koef;
?>
endif; ?> Dnes má svátek a zítra Zde nám můžete psát if ($Pocet>=2): $vypis = MySQL_Fetch_Array($zaznam); $soubor="logo/".$vypis["Name"]; $Size=GetImageSize($soubor); $Sirka=140; $koef=$Sirka/$Size[0]; $Vyska=$Size[1]*$koef; ?> endif; ?> for ($i=3;$i<=$Pocet-2;$i++): $vypis = MySQL_Fetch_Array($zaznam); $soubor="logo/".$vypis["Name"]; $Size=GetImageSize($soubor); $Sirka=140; $koef=$Sirka/$Size[0]; $Vyska=$Size[1]*$koef; ?> endfor; MySQL_Close($Connection); ?> Docházka na tréninky
|
$DB="basket"; $Connection = MySQL_Connect("localhost","jiskra","mkjd85246"); MySQL_Select_DB($DB); if (!$Connection): echo "nepodarilo se pripojit \n"; break; endif; $pocet=0; $actdate=Time(void); //echo $min_den.".".$min_mes.".".$min_rok." - ".$max_den.".".$max_mes.".".$max_rok; $fly_text_exist=false; $den_last=0; @$zaznam=MySQL_DB_Query("$DB", "SELECT * FROM $table_akce ORDER BY Datum", $Connection); while ($vypis = MySQL_Fetch_Array($zaznam)): $akce_d=intval(SubStr($vypis["Datum"],8,2)); $akce_m=intval(SubStr($vypis["Datum"],5,2)); $akce_y=intval(SubStr($vypis["Datum"],0,4)); $akce_h=intval(SubStr($vypis["Cas"],0,2)); $akce_mi=intval(SubStr($vypis["Cas"],3,2)); $mindate=MkTime($akce_h,$akce_mi,1,$akce_m,$akce_d,$akce_y); //jedna hodina // $maxdate=$mindate+(3600); //dve hodiny $maxdate=$mindate+(7200); if ( (($mindate<$actdate)&&($actdate<$maxdate)&&($pocet<5)) ): // echo $mindate.",".$maxdate.",".$actdate.",".$pocet."\n "; if ($pocet<1): ?> Právě se hraje utkání
$pocet++; //echo $actdate.", ".$mindate.", ".$maxdate; endif; endwhile; MySQL_Close($Connection); ?> $DB="basket"; $Connection = MySQL_Connect("localhost","jiskra","mkjd85246"); MySQL_Select_DB($DB); if (!$Connection): echo "nepodarilo se pripojit \n"; break; endif; $i=1; @$zaznam=MySQL_DB_Query("$DB", "SELECT * FROM $table_clanky ORDER BY Datum DESC", $Connection); while (($vypis = MySQL_Fetch_Array($zaznam)) && ($i<=4)): $akce_d=intval(SubStr($vypis["Datum"],8,2)); $akce_m=intval(SubStr($vypis["Datum"],5,2)); $akce_y=intval(SubStr($vypis["Datum"],0,4)); ?>&r=" TARGET="_blank"> echo $vypis["Nadpis"]; ?> echo "\n ".$akce_d.".".$akce_m.".".$akce_y.", ".$vypis["Jmeno"]." - ";?> if (strlen($vypis["Komentar"])<=500): $text=$vypis["Komentar"]; else: $MinLen=300; //minimalni delka vynateho textu v upoutavce $text=SubStr($vypis["Komentar"],$MinLen,8000); $konec=$MinLen+StrPos($text,"."); $text=SubStr($vypis["Komentar"],0,$konec)." ..."; endif; echo NL2BR($text)." "; ?> $i++; endwhile; MySQL_Close($Connection); ?> Archív článků |
$DB="basket";
$Connection = MySQL_Connect("localhost","jiskra","mkjd85246");
MySQL_Select_DB($DB);
if (!$Connection):
echo "nepodarilo se pripojit \n";
break;
endif;
@$zaznam=MySQL_DB_Query("$DB", "SELECT * FROM $table_logo WHERE Param='all' ORDER BY Poradi DESC", $Connection);
if (MySQL_Num_Rows($zaznam)>1):
$vypis = MySQL_Fetch_Array($zaznam);
$vypis = MySQL_Fetch_Array($zaznam);
$soubor="logo/".$vypis["Name"];
$Size=GetImageSize($soubor);
$Sirka=150;
$koef=$Sirka/$Size[0];
$Vyska=$Size[1]*$koef;
?>
endif; MySQL_Close($Connection); ?> Kalendář akcí
$DB="basket"; $Connection = MySQL_Connect("localhost","jiskra","mkjd85246"); MySQL_Select_DB($DB); if (!$Connection): echo "nepodarilo se pripojit \n"; break; endif; @$zaznam=MySQL_DB_Query("$DB", "SELECT * FROM $table_logo WHERE Param='all' ORDER BY Poradi DESC", $Connection); if (MySQL_Num_Rows($zaznam)>=1): $vypis = MySQL_Fetch_Array($zaznam); $soubor="logo/".$vypis["Name"]; $Size=GetImageSize($soubor); $Sirka=150; $koef=$Sirka/$Size[0]; $Vyska=$Size[1]*$koef; ?> endif; MySQL_Close($Connection); ?> $DB="basket"; $Connection = MySQL_Connect("localhost","jiskra","mkjd85246"); MySQL_Select_DB($DB); if (!$Connection): echo "nepodarilo se pripojit \n"; break; endif; @$zaznam=MySQL_DB_Query("$DB", "SELECT * FROM $table_novinky ORDER BY Cislo DESC", $Connection); while ($vypis = MySQL_Fetch_Array($zaznam)) if ($vypis>0): ?> Novinky
ShoutBoard
SMS ve tvaru:
SHOUT 105418 jmeno vzkaz tel.č. +420 736 300 202 | ||||||||||||||