setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//echo "Connected successfully";
// Example SELECT query
$sql = "SELECT * FROM recent_publications WHERE status = 'ACTIVE' AND ack_miro = 1 ORDER BY publication_date DESC";
$result = $conn->query($sql);
$papers = [];
$i = 0;
$pre_year = "";
if ($result->rowCount() > 0) {
// Fetch data
foreach ($result as $row) {
//echo "
";
//print_r($row);
//echo "
";
$year = date("Y",strtotime($row['publication_date']));
if($pre_year != $year)
$i = 0;
$papers[$year][$i]['title'] = $row['title'];
$papers[$year][$i]['title_hindi'] = $row['title_hindi'];
$papers[$year][$i]['authors'] = $row['authors'];
$papers[$year][$i]['authors_hindi'] = $row['authors_hindi'];
$papers[$year][$i]['journal'] = $row['journal'];
$papers[$year][$i]['journal_hindi'] = $row['journal_hindi'];
$papers[$year][$i]['publication_date'] = $row['publication_date'];
$papers[$year][$i]['link'] = $row['link'];
$papers[$year][$i++]['impact_factor'] = $row['impact_factor'];
$pre_year = $year;
}
} else {
//echo "No records found";
}
//print_r($papers);
// Close connection
$conn = null;
}
catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
?>
PRL Mount Abu Observatory Publications
PRL Mount Abu Observatory Publications
$paper)
{
echo "
";
echo "";
echo "
";
echo "
";
echo "
";
foreach($paper as $row)
{
echo "- ";
echo $row['authors']. ", " .$row['title']. ", " .$row['journal']. ", Date of Publication: " .$row['publication_date']. ", Impact Factor: " .$row['impact_factor'];
echo "
";
}
echo "
";
echo "
";
echo "
";
echo "
";
}
?>