PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ]); } catch (PDOException $e) { // Connection failed return '
Database connection error.
'; } try { $stmt = $pdo->query($sql); } catch (PDOException $e) { // Query error return 'Query error.
'; } $rows = $stmt->fetchAll(); if (empty($rows)) { return 'No results.
'; } // Get column names from first row $columns = array_keys($rows[0]); // Start building HTML table $html = '| ' . htmlspecialchars($col, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8') . ' | '; } $html .= '
|---|
| ' . htmlspecialchars((string)$value, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8') . ' | '; } $html .= '
Discovery Chart
'; } //print_r($dataz); //echo $place; $sqla = "select `long`,lat from asterplaces where site = '".mysqli_real_escape_string($link, trim($place))."'"; //echo $sqla; $resu = mysqli_query($link, $sqla); $koht = mysqli_fetch_row($resu); //print_r( $koht); $sqla = "select `lng`,lat from asterplaces_new where name LIKE '".trim(mysqli_real_escape_string($link, $place))."%'"; //echo $sqla; $resu = mysqli_query($link, $sqla); $koht2 = mysqli_fetch_row($resu); function dec2pullen($in,$latOrLong) { if ($in < 0) { if ($latOrLong == 'lat') { $suund = 's'; } if ($latOrLong == 'lng') { $suund = 'w'; } } else { if ($latOrLong == 'lat') { $suund = 'n'; } if ($latOrLong == 'lng') { $suund = 'e'; } } if ($in >= 0) { $tais = floor($in); $komak = $in-$tais; $min = round($komak*60); } else { $in = abs($in); $tais = floor($in); $komak = $in-$tais; $min = round($komak*60); } return $tais.$suund.$min; } // $command3="../cgi-bin/swetest -ps -xs".$asteroidarray[0]." -b".$kuup.".".$kuu.".".$aasta." -ut".fraction2time($time)." -g -fpPZl -edir/var/www/vhosts/megadelfi.com/astrolog/ephe -head -roundmin > '../temp/_natal_aster_'$NatalKook"; $command3="../cgi-bin/swetest -ps -xs".$asteroidarray[0]." -b".$kuup.".".$kuu.".".$aasta." -ut".fraction2time($time)." -g -fpPZl -edir/var/www/vhosts/megadelfi.com/astrolog/ephe -head -roundmin"; //echo $command3; exec($command3, $output, $retval); //print_r($output);echo $retval; if (isset($koht[0])) { //$command = "../cgi-bin/astrolog541g -n -z 0 -zl ".$koht[0]." ".$koht[1]." -zt ".fraction2time($time)." -zy $aasta -zm $kuu -zd $kuup -R0 1 2 3 4 5 6 7 8 9 10 11 16 17 > '../temp/_natal_'$NatalKook"; $command = "../cgi-bin/astrolog541g -n -z 0 -zl ".$koht[0]." ".$koht[1]." -zt ".fraction2time($time)." -zy $aasta -zm $kuu -zd $kuup -R0 1 2 3 4 5 6 7 8 9 10 11 16 17"; } //echo $koht[0].' '.$command; if (isset($koht2[0])) { $command2 = "../cgi-bin/astrolog541g -n -z 0 -zl ".dec2pullen($koht2[0],'lng')." ".dec2pullen($koht2[1],'lat')." -zt ".fraction2time($time)." -zy $aasta -zm $kuu -zd $kuup -R0 1 2 3 4 5 6 7 8 9 10 11 16 17 > '../temp/_natal_'$NatalKook"; } //echo 'syy
'.$koht2[0].' '.$command2.'
';
//echo $command.'
';
exec($command, $reaarray, $retval);
//exec("../cgi-bin/astrolog541g -n -z 0 -zl ".$koht[0]." ".$koht[1]." -zt ".fraction2time($time)." -zy $aasta -zm $kuu -zd $kuup -a > '../temp/_natal_asp_'$NatalKook");
if (isset($koht2[0])) {
//echo 'seep';
$comman = "../cgi-bin/astrolog541g -n -z 0 -zl ".dec2pullen($koht2[0],'lng')." ".dec2pullen($koht2[1],'lat')." -zt ".fraction2time($time)." -zy $aasta -zm $kuu -zd $kuup -R0 1 2 3 4 5 6 7 8 9 10 11 16 17";
//echo $comman;
exec($comman, $reaarray, $retval);
}
if (count($asteroidarray) != '0')
{
/*
for ($no=0; $no < count($asteroidarray)-1; $no++) //-1 lisatud 3 apr 2017
{
$command="../cgi-bin/swetest -ps -xs".$asteroidarray[$no]." -b".$kuup.".".$kuu.".".$aasta." -ut".fraction2time($time)." -g -fpPZl -edir/var/www/vhosts/megadelfi.com/astrolog/ephe -head -roundmin >> ../temp/_natal_aster_$NatalKook";
echo $command;
exec($command);
}*/
//echo $command.'
';
/*
$datafile = '../temp/_natal_aster_'.$NatalKook;
$INFO = fopen($datafile,"r");
$filesisu = fread($INFO, filesize($datafile));
fclose($INFO);
unlink('../temp/_natal_aster_'.$NatalKook);
$reaarray0=explode("\n",$filesisu);
*/
$reaarray0 = $output;
//echo 'reaarray: ';
//print_r($reaarray0);
$m=0;
for ($l=0; $l < count($reaarray0)-1; $l++)
if ((substr($reaarray0[$l],0,6) != 'error:') AND (substr($reaarray0[$l],0,5) != '10000') AND (strstr($reaarray0[$l],': not found') == FALSE) )
{
// uus osa asteroidide kaardil nitamiseks
// paneb lppu he thja kirje ja veel koma -- jama!!
$adeg .= str_replace(" ","%20",trim(substr($reaarray0[$l],31,11))).',';
$anam .= str_replace(" ","%20",trim(substr($reaarray0[$l],6,16))).',';
$reaarrayA[$m]=$reaarray0[$l];
$m++;
}
// ASTEROIDID LõPPEVAD ET PÄRAST JÄTKUDA
$anamesarray = explode(",",$anam);
$adegsarray = explode(",",$adeg);
/*
$datafile = '../temp/_natal_'.$NatalKook;
$INFO = fopen($datafile,"r");
$filesisu = fread($INFO, filesize($datafile));
fclose($INFO);
$reaarray=explode("\n",$filesisu);
*/
if ($mis == 'composite')
{
array_unshift($reaarray, "abhi_quick-hack");
}
//print_r($reaarray);
//exit;
if (isset($reaarray[4])) {
$sun=(substr($reaarray[4],12,2)+ari2num(substr($reaarray[4],14,3)));
$moo=(substr($reaarray[5],12,2)+ari2num(substr($reaarray[5],14,3)));
$mer=(substr($reaarray[6],12,2)+ari2num(substr($reaarray[6],14,3)));
$ven=(substr($reaarray[7],12,2)+ari2num(substr($reaarray[7],14,3)));
$mar=(substr($reaarray[8],12,2)+ari2num(substr($reaarray[8],14,3)));
$jup=(substr($reaarray[9],12,2)+ari2num(substr($reaarray[9],14,3)));
$sat=(substr($reaarray[10],12,2)+ari2num(substr($reaarray[10],14,3)));
$ura=(substr($reaarray[11],12,2)+ari2num(substr($reaarray[11],14,3)));
$nep=(substr($reaarray[12],12,2)+ari2num(substr($reaarray[12],14,3)));
$plu=(substr($reaarray[13],12,2)+ari2num(substr($reaarray[13],14,3)));
$chi=(substr($reaarray[14],12,2)+ari2num(substr($reaarray[14],14,3)));
$lil=(substr($reaarray[16],12,2)+ari2num(substr($reaarray[16],14,3)));
$nn=(substr($reaarray[15],12,2)+ari2num(substr($reaarray[15],14,3)));
$asc=(substr($reaarray[4],72,2)+ari2num(substr($reaarray[4],74,3)));
$h2=(substr($reaarray[5],72,2)+ari2num(substr($reaarray[5],74,3)));
$h3=(substr($reaarray[6],72,2)+ari2num(substr($reaarray[6],74,3)));
$h4=(substr($reaarray[7],72,2)+ari2num(substr($reaarray[7],74,3)));
$h5=(substr($reaarray[8],72,2)+ari2num(substr($reaarray[8],74,3)));
$h6=(substr($reaarray[9],72,2)+ari2num(substr($reaarray[9],74,3)));
//$adeg='.$adeg;
//.'&anam='.$anam.'&ast=yes">
//echo 'päike '.$sun;
}
//echo $koht[0];
if (isset($koht[0]))
{
$avastamine = $kuup.'.'.$kuu.'.'.$aasta.' '.
fraction2time($time).' '.
$place.' '.$koht[0].' '.$koht[1].' '.
' observations '.mysqli_num_rows($result);
}
if (isset($koht2[0])) // lisasin selle alles 28 jan 2026 sest on uus ja vana kohtade tabel
{
$avastamine = $kuup.'.'.$kuu.'.'.$aasta.' '.
fraction2time($time).' '.
$place.' '.$koht2[0].' '.$koht2[1].' '.
' observations '.mysqli_num_rows($result);
}
/*
echo
$kuup.'.'.$kuu.'.'.$aasta.' '.
fraction2time($time).' '.
$place.' '.$koht[0].' '.$koht[1].' '.
' observations '.mysqli_num_rows($result);
*/
/*
if (mysqli_num_rows($result) == 0)
{
//echo '
Discovery time NOT available!';
}
echo'
'&adeg='.$adeg.'&anam='.$anam.'&ast=yes">
';
'&adeg='.$adeg.'&anam='.$anam.'&ast=yes>
';
//see alakriips ja muu on 21 jan 2014 hakk
*/
/*
echo'
| '.$lang['sun'].' | '.substr($reaarray[4],12,2).'° '. substr($reaarray[4],17,2)."' | ".''.eng2est(substr($reaarray[4],14,3)). ' | '.$anamesarray[0].' | '. $adegsarray[0].' | ||||
| '.$lang['moo'].' | '.substr($reaarray[5],12,2).'° '. substr($reaarray[5],17,2)."' | ".''.eng2est(substr($reaarray[5],14,3)). ' | '.$anamesarray[1].' | '. $adegsarray[1].' | ||||
| '.$lang['mer'].' | '.substr($reaarray[6],12,2).'° '. substr($reaarray[6],17,2)."' | ".''.eng2est(substr($reaarray[6],14,3)). ' | ||||||
| '.$lang['ven'].' | '.substr($reaarray[7],12,2).'° '. substr($reaarray[7],17,2)."' | ".''.eng2est(substr($reaarray[7],14,3)). ' | ||||||
| '.$lang['mar'].' | '.substr($reaarray[8],12,2).'° '. substr($reaarray[8],17,2)."' | ".''.eng2est(substr($reaarray[8],14,3)). ' | ||||||
| '.$lang['jup'].' | '.substr($reaarray[9],12,2).'° '. substr($reaarray[9],17,2)."' | ".''.eng2est(substr($reaarray[9],14,3)). ' | ||||||
| '.$lang['sat'].' | '.substr($reaarray[10],12,2).'° '. substr($reaarray[10],17,2)."' | ".''.eng2est(substr($reaarray[10],14,3)). ' | ||||||
| '.$lang['ura'].' | '.substr($reaarray[11],12,2).'° '. substr($reaarray[11],17,2)."' | ".''.eng2est(substr($reaarray[11],14,3)). ' | ||||||
| '.$lang['nep'].' | '.substr($reaarray[12],12,2).'° '. substr($reaarray[12],17,2)."' | ".''.eng2est(substr($reaarray[12],14,3)). ' | ||||||
| '.$lang['plu'].' | '.substr($reaarray[13],12,2).'° '. substr($reaarray[13],17,2)."' | ".''.eng2est(substr($reaarray[13],14,3)). ' | ||||||
| '.$lang['chi'].' | '.substr($reaarray[14],12,2).'° '. substr($reaarray[14],17,2)."' | ".''.eng2est(substr($reaarray[14],14,3)). ' | ||||||
| '.$lang['lil'].' | '.substr($reaarray[16],12,2).'° '. substr($reaarray[16],17,2)."' | ".''.eng2est(substr($reaarray[16],14,3)). ' | ||||||
| NN | '.substr($reaarray[15],12,2).'° '. substr($reaarray[15],17,2)."' | ".''.eng2est(substr($reaarray[15],14,3)). ' |
';
*/
//echo $adeg.'
';
//echo $anam.'
';
}
}
//echo 'päike '.$sun;
?>
<< prev in category - Cities -
Discovered on 11-10-2015 in Baldone by K. Černis, I. Eglitis | ||
| ORBITS | AstDys | Wikipedia | Dictionary | UrbanDictionary | Bartleby | Webster | Name Source | | ||
| Categories: Cities, |