=($fi1) and a.ge_dolzina<=($lam2) and a.ge_dolzina>=($lam1)";
}
//----------------spodaj se tvori selekt-------------------------------
//----------------spodaj se tvori selekt-------------------------------
//----------------spodaj se tvori selekt-------------------------------
//----------------spodaj se tvori selekt-------------------------------
//----------------spodaj se tvori selekt-------------------------------
$spremenljivke_=$_REQUEST['spremenljivke_'];
//$vse_=$_REQUEST['vse_']; $le_en_=$_REQUEST['le_en_']; $kateri_=$_REQUEST['kateri_'];
// spodaj je moznost izpisa imen, naslova, telefona, zadnje stanje opazovalcev
$imena=""; $imena_tabela =""; $imena_id=""; $zadnje_stan_ok="";
if ($naslovi_=='da') {
$imena=", a.st_postaje ||'_'||
convert(convert(a.ime_postaje, 'unicode'),'LATIN2') as st_ime_postaje,
convert(convert(c.priimek_ime, 'unicode'),'LATIN2') as piimek_ime,
convert(convert(c.naslov, 'unicode'),'LATIN2') as naslov,
c.telefon, c.datum_zacetka as zacetek, c.datum_konca as konec";
$imena_tabela =", ident_posx c";
$imena_id=" and b.id=c.id";
if ($zadnje_stan_=='da') { $zadnje_stan_ok="and c.datum_konca='10000-01-01'"; }
}
if ($spremenljivke_=='da')
{
$parametri=" ,
(select distinct on (id_parametra) case when id_parametra='1' then 'Tem' else '0' end
from parametri where id=b.id and id_parametra='1' $datum_par) as Tem,
(select distinct on (id_parametra) case when id_parametra='2' then 'Pri' else '0' end
from parametri where id=b.id and id_parametra='2' $datum_par) as Pri,
(select distinct on (id_parametra) case when id_parametra='3' then 'Vla' else '0' end
from parametri where id=b.id and id_parametra='3' $datum_par) as Vla,
(select distinct on (id_parametra) case when id_parametra='4' then 'SevG' else '0' end
from parametri where id=b.id and id_parametra='4' $datum_par) as SevG,
(select distinct on (id_parametra) case when id_parametra='5' then 'SevD' else '0' end
from parametri where id=b.id and id_parametra='5' $datum_par) as SevD,
(select distinct on (id_parametra) case when id_parametra='6' then 'Vet' else '0' end
from parametri where id=b.id and id_parametra='6' $datum_par) as Vet,
(select distinct on (id_parametra) case when id_parametra='7' then 'Pad' else '0' end
from parametri where id=b.id and id_parametra='7' $datum_par) as Pad,
(select distinct on (id_parametra) case when id_parametra='8' then 'T05' else '0' end
from parametri where id=b.id and id_parametra='8' $datum_par) as T05,
(select distinct on (id_parametra) case when id_parametra='9' then 'T005' else '0' end
from parametri where id=b.id and id_parametra='9' $datum_par) as T005,
(select distinct on (id_parametra) case when id_parametra='10' then 'Tasp' else '0' end
from parametri where id=b.id and id_parametra='10' $datum_par) as Tasp,
(select distinct on (id_parametra) case when id_parametra='11' then 'Tz005' else '0' end
from parametri where id=b.id and id_parametra='11' $datum_par) as Tz005,
(select distinct on (id_parametra) case when id_parametra='12' then 'Tz010' else '0' end
from parametri where id=b.id and id_parametra='12' $datum_par) as Tz010,
(select distinct on (id_parametra) case when id_parametra='13' then 'Tz030' else '0' end
from parametri where id=b.id and id_parametra='13' $datum_par) as Tz030,
(select distinct on (id_parametra) case when id_parametra='14' then 'VlaLi' else '0' end
from parametri where id=b.id and id_parametra='14' $datum_par) as VlaLi,
(select distinct on (id_parametra) case when id_parametra='15' then 'AtmSta' else '0' end
from parametri where id=b.id and id_parametra='15' $datum_par) as AtmSta,
(select distinct on (id_parametra) case when id_parametra='16' then 'T10' else '0' end
from parametri where id=b.id and id_parametra='16' $datum_par) as T10,
(select distinct on (id_parametra) case when id_parametra='17' then 'T40' else '0' end
from parametri where id=b.id and id_parametra='17' $datum_par) as T40,
(select distinct on (id_parametra) case when id_parametra='18' then 'T70' else '0' end
from parametri where id=b.id and id_parametra='18' $datum_par) as T70,
(select distinct on (id_parametra) case when id_parametra='19' then 'Vla10' else '0' end
from parametri where id=b.id and id_parametra='19' $datum_par) as Vla10,
(select distinct on (id_parametra) case when id_parametra='20' then 'Vla40' else '0' end
from parametri where id=b.id and id_parametra='20' $datum_par) as Vla40,
(select distinct on (id_parametra) case when id_parametra='21' then 'Vla70' else '0' end
from parametri where id=b.id and id_parametra='21' $datum_par) as Vla70,
(select distinct on (id_parametra) case when id_parametra='22' then 'Vet2m' else '0' end
from parametri where id=b.id and id_parametra='22' $datum_par) as Vet2m,
(select distinct on (id_parametra) case when id_parametra='23' then 'Vet40m' else '0' end
from parametri where id=b.id and id_parametra='23' $datum_par) as Vet40m,
(select distinct on (id_parametra) case when id_parametra='24' then 'Vet70m' else '0' end
from parametri where id=b.id and id_parametra='24' $datum_par) as Vet70m,
(select distinct on (id_parametra) case when id_parametra='25' then 'Rad' else '0' end
from parametri where id=b.id and id_parametra='25' $datum_par) as Rad,
(select distinct on (id_parametra) case when id_parametra='26' then 'SevUV' else '0' end
from parametri where id=b.id and id_parametra='26' $datum_par) as SevUV,
(select distinct on (id_parametra) case when id_parametra='27' then 'TsenUV' else '0' end
from parametri where id=b.id and id_parametra='27' $datum_par) as TsenUV,
(select distinct on (id_parametra) case when id_parametra='28' then 'SevUVB' else '0' end
from parametri where id=b.id and id_parametra='28' $datum_par) as SevUVB,
(select distinct on (id_parametra) case when id_parametra='29' then 'SevDol' else '0' end
from parametri where id=b.id and id_parametra='29' $datum_par) as SevDol,
(select distinct on (id_parametra) case when id_parametra='30' then 'TsevDol' else '0' end
from parametri where id=b.id and id_parametra='30' $datum_par) as TsevDol,
(select distinct on (id_parametra) case when id_parametra='31' then 'Tp30' else '0' end
from parametri where id=b.id and id_parametra='31' $datum_par) as Tp30,
(select distinct on (id_parametra) case when id_parametra='32' then 'Tpp' else '0' end
from parametri where id=b.id and id_parametra='32' $datum_par) as Tpp,
(select distinct on (id_parametra) case when id_parametra='33' then 'Vet31' else '0' end
from parametri where id=b.id and id_parametra='33' $datum_par) as Vet31,
(select distinct on (id_parametra) case when id_parametra='34' then 'Vet13' else '0' end
from parametri where id=b.id and id_parametra='34' $datum_par) as Vet13,
(select distinct on (id_parametra) case when id_parametra='35' then 'VidHor31' else '0' end
from parametri where id=b.id and id_parametra='35' $datum_par) as VidHor31,
(select distinct on (id_parametra) case when id_parametra='36' then 'VidHorMID' else '0' end
from parametri where id=b.id and id_parametra='36' $datum_par) as VidHorMID,
(select distinct on (id_parametra) case when id_parametra='37' then 'VidHor13' else '0' end
from parametri where id=b.id and id_parametra='37' $datum_par) as VidHor13,
(select distinct on (id_parametra) case when id_parametra='38' then 'VidHMet31' else '0' end
from parametri where id=b.id and id_parametra='38' $datum_par) as VidHMet31,
(select distinct on (id_parametra) case when id_parametra='39' then 'VidHMetMID' else '0' end
from parametri where id=b.id and id_parametra='39' $datum_par) as VidHMetMID,
(select distinct on (id_parametra) case when id_parametra='40' then 'VidHMet13' else '0' end
from parametri where id=b.id and id_parametra='40' $datum_par) as VidHMet13,
(select distinct on (id_parametra) case when id_parametra='41' then 'BazaObl31' else '0' end
from parametri where id=b.id and id_parametra='41' $datum_par) as BazaObl31,
(select distinct on (id_parametra) case when id_parametra='42' then 'BazaObl13' else '0' end
from parametri where id=b.id and id_parametra='42' $datum_par) as BazaObl13,
(select distinct on (id_parametra) case when id_parametra='43' then 'IntLuci' else '0' end
from parametri where id=b.id and id_parametra='43' $datum_par) as IntLuci,
(select distinct on (id_parametra) case when id_parametra='44' then 'PriLet' else '0' end
from parametri where id=b.id and id_parametra='44' $datum_par) as PriLet,
(select distinct on (id_parametra) case when id_parametra='45' then 'SvetlOzdLet' else '0' end
from parametri where id=b.id and id_parametra='45' $datum_par) as SvetlOzdLet,
(select distinct on (id_parametra) case when id_parametra='46' then 'VreTren' else '0' end
from parametri where id=b.id and id_parametra='46' $datum_par) as VreTren,
(select distinct on (id_parametra) case when id_parametra='47' then 'VreTrenPad' else '0' end
from parametri where id=b.id and id_parametra='47' $datum_par) as VreTrenPad,
(select distinct on (id_parametra) case when id_parametra='48' then 'TemVode' else '0' end
from parametri where id=b.id and id_parametra='48' $datum_par) as TemVode,
(select distinct on (id_parametra) case when id_parametra='49' then 'Nivo' else '0' end
from parametri where id=b.id and id_parametra='49' $datum_par) as Nivo,
(select distinct on (id_parametra) case when id_parametra='50' then 'Tmokri' else '0' end
from parametri where id=b.id and id_parametra='50' $datum_par) as Tmokri,
(select distinct on (id_parametra) case when id_parametra='51' then 'SnegSku' else '0' end
from parametri where id=b.id and id_parametra='51' $datum_par) as SnegSku,
(select distinct on (id_parametra) case when id_parametra='52' then 'SnegNov' else '0' end
from parametri where id=b.id and id_parametra='52' $datum_par) as SnegNov,
(select distinct on (id_parametra) case when id_parametra='53' then 'VidOcena' else '0' end
from parametri where id=b.id and id_parametra='53' $datum_par) as VidOcena,
(select distinct on (id_parametra) case when id_parametra='54' then 'Obl10' else '0' end
from parametri where id=b.id and id_parametra='54' $datum_par) as Obl10,
(select distinct on (id_parametra) case when id_parametra='55' then 'VetSmer32' else '0' end
from parametri where id=b.id and id_parametra='55' $datum_par) as VetSmer32,
(select distinct on (id_parametra) case when id_parametra='56' then 'Tmin2m' else '0' end
from parametri where id=b.id and id_parametra='56' $datum_par) as Tmin2m,
(select distinct on (id_parametra) case when id_parametra='57' then 'Tmax2m' else '0' end
from parametri where id=b.id and id_parametra='57' $datum_par) as Tmax2m,
(select distinct on (id_parametra) case when id_parametra='58' then 'SnegGost' else '0' end
from parametri where id=b.id and id_parametra='58' $datum_par) as SnegGost,
(select distinct on (id_parametra) case when id_parametra='59' then 'SevTra' else '0' end
from parametri where id=b.id and id_parametra='59' $datum_par) as SevTra,
(select distinct on (id_parametra) case when id_parametra='60' then 'Pojavi' else '0' end
from parametri where id=b.id and id_parametra='60' $datum_par) as Pojavi,
(select distinct on (id_parametra) case when id_parametra='61' then 'Tla' else '0' end
from parametri where id=b.id and id_parametra='61' $datum_par) as Tla,
(select distinct on (id_parametra) case when id_parametra='62' then 'Higro' else '0' end
from parametri where id=b.id and id_parametra='62' $datum_par) as Higro,
(select distinct on (id_parametra) case when id_parametra='63' then 'VetJak' else '0' end
from parametri where id=b.id and id_parametra='63' $datum_par) as VetJak,
(select distinct on (id_parametra) case when id_parametra='64' then 'Tz002' else '0' end
from parametri where id=b.id and id_parametra='64' $datum_par) as Tz002,
(select distinct on (id_parametra) case when id_parametra='65' then 'Tz020' else '0' end
from parametri where id=b.id and id_parametra='65' $datum_par) as Tz020,
(select distinct on (id_parametra) case when id_parametra='66' then 'Tz050' else '0' end
from parametri where id=b.id and id_parametra='66' $datum_par) as Tz050,
(select distinct on (id_parametra) case when id_parametra='67' then 'Tz100' else '0' end
from parametri where id=b.id and id_parametra='67' $datum_par) as Tz100
";
}
// brez izjem, ki merijo samo sneg, and a.idmm not in
// (1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235)
$pad_brez_sne =""; $jj=0; $sts2 =0; $st_sneg_pad=0; $sts33 =0;
$pad_sneg = explode(",",$izbrani);
foreach ($pad_sneg as $sneg_x) {
if ( (1*$sneg_x ==1) ) {
$pad_brez_sne = "and a.idmm not in (1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235) ";
$st_sneg_pad=1;
}
if (1*$sneg_x ==30){ $sts2 =1;}
if (1*$sneg_x ==31){ $sts33 =1;}
$jj++;
}
if (($sts2 ==1)and($jj==1) ){
$izbrani=$izbrani.", 1";
$pad_brez_sne = "and a.idmm in (1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235)";
}
if ($sts33 ==1) { $pad_brez_sne = ""; }
if (($sts2 ==1)and($st_sneg_pad==1) ) { $pad_brez_sne = ""; }
// - to je kompromisna resitev za zmedo s snegom
$pad_sneg = explode(",",$izbrani);
foreach ($pad_sneg as $sneg_x) {
//if ($sneg_x ==" 1 ") {$pad_brez_sne = " and b.sifra_meritve like '%sneg_%' "; }
//if ((1*$sneg_x ==1)and($sneg_x<>" 1 ")) { $pad_brez_sne = ""; }
}
// convert(convert(a.ime_postaje, 'unicode'),'LATIN2')
//echo "$datumk_ lllllllllllllllllllllll
";
if ($obdobje_==1) {
$datum_par="and datum_konca >= '$datumk_' and datum_zacetka <='$datumk_' ";
$sql = "select a.st_postaje, convert(convert(a.ime_postaje, 'unicode'),'LATIN2') as ____ime_postaje______,
b.tip, b.sifra_meritve, a.nadm_visina as nad_vis_m, x(a.geometry) as x_m,
y(a.geometry) as y_m, a.ge_sirina, a.ge_dolzina,
b.datum_zacetka as dat_zac_tipa, b.datum_konca as dat_kon_tipa, b.id,
a.idmm $imena $parametri
from idmm a, id_obs b
$imena_tabela
where a.idmm=b.idmm
and b.tip in ($izbrani)
and b.datum_konca >= '$datumk_'
and b.datum_zacetka <='$datumk_'
$geo_omejitev
$imena_id $zadnje_stan_ok $pad_brez_sne
order by b.tip, a.st_postaje, b.idmm asc";
##### echo "
";
}
// convert(convert(a.ime_postaje, 'unicode'),'LATIN2')
// -- neprekinjeno na istem mestu
if ($obdobje_==2) {
$datum_par="and datum_konca >= '$datumk_' and datum_zacetka <='$datumz_' ";
$sql = "
select a.st_postaje,
convert(convert(a.ime_postaje, 'unicode'),'LATIN2') as ____ime_postaje______,
b.tip, b.sifra_meritve, a.nadm_visina as nad_vis_m, x(a.geometry)
as x_m, y(a.geometry) as y_m, a.ge_sirina, a.ge_dolzina, b.datum_zacetka
as dat_zac_tipa, b.datum_konca as dat_kon_tipa, b.id, a.idmm
$imena
$parametri
from idmm a,
id_obs b
$imena_tabela
where a.idmm=b.idmm and b.tip in ($izbrani) and
b.datum_konca >= '$datumk_' and
b.datum_zacetka <='$datumz_'
$geo_omejitev
$imena_id $zadnje_stan_ok $pad_brez_sne
order by b.tip, a.st_postaje, b.idmm asc";
}
// -- delala v cel obdobju ali zacela, kocala v obdobju
if ($obdobje_==3) {
$datum_par="and datum_konca >= '$datumz_' and datum_zacetka <='$datumk_' ";
$sql = "
select a.st_postaje,
convert(convert(a.ime_postaje, 'unicode'),'LATIN2') as ____ime_postaje______,
b.tip, b.sifra_meritve, a.nadm_visina as nad_vis_m, x(a.geometry)
as x_m, y(a.geometry) as y_m, a.ge_sirina, a.ge_dolzina, b.datum_zacetka
as dat_zac_tipa, b.datum_konca as dat_kon_tipa, b.id, a.idmm
$imena
$parametri
from idmm a,
id_obs b
$imena_tabela
where a.idmm=b.idmm and b.tip in ($izbrani) and
b.datum_konca >= '$datumz_' and
b.datum_zacetka <='$datumk_'
$geo_omejitev
$imena_id $zadnje_stan_ok $pad_brez_sne
order by b.tip, a.st_postaje, b.idmm asc";
}
if ( isset($selekt_)) { echo "$sql
"; }
// xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
// xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
// xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
// xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
// xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
$ret = pg_exec ($dbconn, $sql);
if ($err = pg_ErrorMessage($dbconn) ) echo "NAPAKA ! -- $err
";
// spodnji stavek nadomesti vse ostale zgoraj za for ($ii
$besedax = '*';
// spodaj, selekt ce je zvezdica ************ za vse
if (($y[2] == '*') or ($besedax == '*'))
{
//spodnja vr. vrze stevilo kolon --------------------
$aa=pg_NumFields($ret);
//print "
fff $aa j
";
//spodnja vr. vrze ime kolone 0, 1 itd ------------------
$bb=pg_FieldName($ret, 1);
// print "
fff $bb j---
";
$besedax ='';
//$st_spre=139;
$st_spre=$aa;
for ($ii=0; $ii<$st_spre; $ii++)
{
//echo "$y[$ii], ";
$y[$ii]='';
//spodnja vr. vrze ime kolone 0, 1 itd ------------------
$y[$ii]=pg_FieldName($ret,$ii);
//$y[$ii]=$polje[$ii];
}
$zac=0;
$zac1=0;
//$j = 139;
$j = $aa;
//konec if ($y[2] == "*")
}
// ---------zacetek vnos slike - karte postaj-----------------
// ---------zacetek vnos slike - karte postaj-----------------
// ---------zacetek vnos slike - karte postaj-----------------
// ---------zacetek vnos slike - karte postaj-----------------
#$datum2=$_REQUEST['datum2'];
#$lam1=$_REQUEST['lam1']; $lam2=$_REQUEST['lam2'];
#$fi1=$_REQUEST['fi1']; $fi2=$_REQUEST['fi2'];
#$geo_=$_REQUEST['geo_'];
#$naslovi_ = $_REQUEST['naslovi_'];
#$zadnje_stan_ = $_REQUEST['zadnje_stan_'];
#$spremenljivke_=$_REQUEST['spremenljivke_'];
#$tipi_=$_REQUEST['tipi_'];
#$izbrani=$_REQUEST['izbrani'];
#$datumk_=$_REQUEST['datumk_'];
#$datumz_=$_REQUEST['datumz_'];
#$obdobje_=$_REQUEST['obdobje_'];
// vse spremenljivke so v spodnji vrstici
# &datum2=$datum2&lam1=$lam1&lam2=lam2&fi1=$fi1&fi2=$fi2&geo_=$geo_&naslovi_ = $naslovi_&zadnje_stan_ = $zadnje_stan_&spremenljivke_=$spremenljivke_&tipi_=$tipi_&izbrani=$izbrani&datumk_=$datumk_&datumz_=$datumz_&obdobje_=$obdobje_
// spodaj narisem karto s karta01_met_pos_jpg.php, v to kodo karte
// nesem naprej vse spremenljivke za enak selekt, ki je tudi v karta01_met_pos_jpg.php
//echo "
";
//echo "
";
#echo "
";
//
$sqlx="DETect_reewr_WEREWREW_WEREWREW_WEREWREW a, bc,
ewrwe
ewrewr
ttzz
33445";
#echo "
";
//echo "![](karta01_met_pos_jpg.php?sql_=\"$sql\")
";
//---------------procedura za zamenjevanje znakov v stringu ----
//---------------procedura za zamenjevanje znakov v stringu ----
//---------------procedura za zamenjevanje znakov v stringu ----
//---------------procedura za zamenjevanje znakov v stringu ----
function zamenjaj($str){
$i=0;
/*
$not_locale_bank_up = Is the replacement character(s)
$not_locale_bank_down = Is the character(s) to search for
*/
//$not_locale_bank_up="ABCDEFGHIJKLMNOPQRSTUVXYZñ?;
//$not_locale_bank_down="abcdefghijklmnopqrstuvxyz?";
// ^ = È, @ = Ž, [ = Š zamenjave velikih èrek za velike - stari slo sitem šumnikov
//$not_locale_bank_up= "ABCÈEÆDÐEFGHIJKLMNOPQRSŠTUVWXYZŽ ÈŽŠ";
//$not_locale_bank_down="abcèeædðefghijklmnopqrsštuvwxyzž ^@[";
$not_locale_bank_up= "£ÆæÐð¤ß°°";
$not_locale_bank_down=",|><'= \r\n";
for ($s=0; $s=$i){
if(substr($str,$s,1) == substr($not_locale_bank_down, $i, 1)){
$rep=substr($not_locale_bank_up,$i, 1);
//$string=substr_replace($str,$rep, $s, 1);
//break;
}
//$i++;
}
$string="$string$rep";
//konec for ($s=0; $s"; //prenos spremenljivk
}
function zamenjaj_o($str){
$i=0;
//$not_locale_bank_up= " =";
//$not_locale_bank_down="#*";
$not_locale_bank_up= ",|><'= \r\n";
$not_locale_bank_down= "£ÆæÐð¤ß°°";
for ($s=0; $s=$i){
if(substr($str,$s,1) == substr($not_locale_bank_down, $i, 1)){
$rep=substr($not_locale_bank_up,$i, 1);
}}
$string="$string$rep";
//konec for ($s=0; $s\n");
// ---- konec - karte postaj ------------------------------
// ---- konec - karte postaj ------------------------------
// ---- konec - karte postaj ------------------------------
// ---- konec - karte postaj ------------------------------
// ---- konec - karte postaj ------------------------------
//---- spodaj je vrstica za formo za risanje slike
if ($karta_==1){
printf("\r\n");
printf("
");
printf("");
// --- spodaj konec: if ($karta_==1){
}
//$st_spre=4;
// testni izpis spremenljivk iz selekt stavka
printf("Izbrali ste naslednje spremenljivke :
\n");
for ($ii=$zac1; $ii<$st_spre; $ii++)
{
echo "$y[$ii], ";
}
printf("
\n Sledi izpis v tabelo.
\n");
$ret = pg_exec ($dbconn, $sql);
$row = pg_numrows($ret);
$i = 0;
//======================izpis v tabelo============================
if ($vkaj == "tabela")
{
if ($barva_ == zelena) { $barva1 = "lime"; }
if ($barva_ == modra) { $barva1 = "87CEFA"; }
if ($barva_ == rdeca) { $barva1 = "FF6347"; }
if ($barva_ == rumena) { $barva1 = "FFFF00"; }
if ($barva_ == bela) { $barva1 = "FFFFFF"; }
if ($barva_ == vijolicna) { $barva1 = "FF00FF"; }
//izpis imen vrstic
printf ("");
printf ("");
for ($ii=$zac; $ii<$st_spre; $ii++)
{
printf ("| $y[$ii] | ");
}
printf ("
\n");
//izpis podatkov
//$j = 1*$st_spre - 3 ali -2;
while ($i < $row) {
$res = pg_fetch_row($ret, $i);
$tipi = "tip$i"; $tipfix = "tipfix$i";
printf ("");
for ($k = 0; $k < $j; $k++)
{
printf ("| $res[$k] | ");
}
printf("
\n");
$i++;
}
printf("\n ");
printf("
");
//konec if ($vkaj == "tabela")
}
if ($vkaj == "vejice")
{
if ($barva_ == zelena) { $barva1 = "lime"; }
if ($barva_ == modra) { $barva1 = "87CEFA"; }
if ($barva_ == rdeca) { $barva1 = "FF6347"; }
if ($barva_ == rumena) { $barva1 = "FFFF00"; }
if ($barva_ == bela) { $barva1 = "FFFFFF"; }
if ($barva_ == vijolicna) { $barva1 = "FF00FF"; }
//izpis imen vrstic
printf ("\n $fontx \n");
for ($ii=$zac; $ii<$st_spre; $ii++)
{
printf (" $y[$ii] $locitev");
}
printf ("\n");
while ($i < $row) {
$res = pg_fetch_row($ret, $i);
for ($k = 0; $k < $j; $k++)
{
printf ("$res[$k]$locitev");
}
printf("
\n");
$i++;
}
// konec if ($vkaj == "vejice")
}
printf ("
TESTNI IZPIS: i = $i , st.vrstic = $row, st_spremenljivk = $st_spre" );
// Zaprem povezavo
pg_close($dbconn);
?>