====== Publications ====== <php> $mysqli = new mysqli("localhost", "tempo", "RsKGJxbQnG9CSFb9", "tempo"); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $query = "SET NAMES 'utf8'"; $dummy = $mysqli->query($query); $query = "SELECT af.artikkel, af.forfatter, af.arbeidsinnsats, a.id, a.publiseringsaar, a.kategori, a.overskrift_eng, a.publikasjonssted_eng, a.registrert, f.id, GROUP_CONCAT(f.fullt_navn ORDER BY af.arbeidsinnsats DESC SEPARATOR ', ') FROM artikkel_forfattere AS af LEFT JOIN artikler AS a ON af.artikkel = a.id LEFT JOIN forfattere AS f ON af.forfatter = f.id GROUP BY af.artikkel ORDER BY a.publiseringsaar DESC, a.kategori ASC, a.registrert DESC"; //echo $query; if ($result = $mysqli->query($query)) { $dato = date("Y"); $kategori = 0; echo "<strong><a name=\"" . $dato. "\">" . $dato . "</a></strong><br>"; /* fetch object array */ while ($row = $result->fetch_row()) { if (($row[4] != $dato) & ($row[4] < $dato)) { echo "</ul>"; echo "<strong><a name=\"" . $row[4]. "\">" . $row[4]. "</a></strong><br>"; $dato--; } if ($row[5] != $kategori) { $kategori = $row[5]; switch ($kategori) { // Book chapter case 1: //echo "</ul>"; echo "<em>Book chapters:<br></em>"; echo "<ul>"; echo "<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</li>"; break; // Journal case 2: echo "</ul>"; echo "<em>Journals:<br></em>"; echo "<ul>"; echo "<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</li>"; break; // Conference Paper case 3: echo "</ul>"; echo "<em>Conference papers: <br></em>"; echo "<ul>"; echo "<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</div></li>"; break; // Plenary talk case 4: echo "</ul>"; echo "<em>Plenary talk: <br></em>"; echo "<ul>"; echo "<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</li>"; break; } } else { echo "<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</li>"; } } /* free result set */ $result->close(); } /* close connection */ $mysqli->close(); </php>