connect_error) {
// redirect to server error page
} else {
$sql = "SELECT * FROM ontologies";
if ($result = $conn->query($sql)) {
$count = 0;
$box_class = 'light-box';
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
$ontology_name = $row['ontology_name'];
$author_name = $row['author_name'];
$author_email = $row['author_email'];
$description = $row['description'];
$ontology_url = $row['ontology_url'];
$tags = $row['tags'];
if ($count % 2 == 0) {
echo "
";
if ($box_class == 'dark-box') {
$box_class = 'light-box';
} else {
$box_class = 'dark-box';
}
}
echo "
";
echo "
";
echo "| Name: | $ontology_name |
";
echo "| Author: | $author_name |
";
echo "| Description: | $description |
";
echo "| Tags: | $tags |
";
echo " |
";
echo "
";
echo "
";
if ($count % 2 != 0) {
echo "
";
}
$count++;
}
} else {
// redirect to server error page
}
}
?>