connect_error) { die("Connection failed: " . $conn->connect_error); } $year = (int)$_REQUEST['year']; $month = (int)$_REQUEST['month']; function format_year($str) { $era = ' CE'; return str_replace('-'.str_replace('-','',$str),str_replace('-','',$str.$era),$str); } $planets = array( '', 'Sun', # 0 'Moon', # 1 'Mercury', # 2 'Venus', # 3 'Mars', # 4 'Jupiter', # 5 'Saturn', # 6 'Uranus', # 7 'Neptune', # 8 'Pluto', # 9 'Chiron', # 10 'Lilith' # 11 ); $signs = array ('','Aries', 'Taurus', 'Gemini', 'Cancer', 'Leo', 'Virgo', 'Libra', 'Scorpio', 'Sagittarius', 'Capricorn', 'Aquarius', 'Pisces'); $planetslist = array( 0 => 'Sun', 1=> 'Moon', 2=> 'Mercury', 3=> 'Venus', 4=> 'Mars', 5=> 'Jupiter', 6=>'Saturn', 7=> 'Uranus', 8=> 'Neptune', 9=> 'Pluto', 10=> 'Chiron', 11=> 'Lilith' ); $signslist = array ( 1=> 'Aries', 2=> 'Taurus', 3=> 'Gemini', 4=> 'Cancer', 5=> 'Leo', 6=> 'Virgo', 7=> 'Libra', 8=> 'Scorpio', 9=> 'Sagittarius', 10=> 'Capricorn', 11=> 'Aquarius', 12=> 'Pisces' ); function getplanetlist($planet,$sign,$year,$month,$options,$conn) { $sig = array(); $sql = "SELECT * FROM astrology_months where month = '".$month."' and year = '".$year."'"; $result = $conn->query($sql) or die(mysqli_error($conn)); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { array_push($sig,array($row['planet'],$row['sign'])); } } $glyphs = array( '', '♈', '♉', '♊', '♋', '♌', '♍', '♎', '♏', '♐', '♑', '♒', '♓'); $qq = ''; for($q=0;$qquery($sql) or die(mysqli_error($conn)); if ($result->num_rows > 0) { $list = "
"; while($row = $result->fetch_assoc()) { if($row['retrograde'] == '1') { $rg = " R "; } else { $rg = ""; } $list .= ""; $i++; } $list .= "
".$glyphs[$row['planet']]."".$glyphs[$row['sign']]."".$row['year']."".$row['month']."".$rg."
"; } return $list; } ?> Planets signatures
".$year." - ".$month.""; echo "
"; echo getplanetlist($planettoshow,$i,$year,$month,$options,$conn).'
'; ?>