Publications SUP CICS
Books:
- P.J. From, J.-T. Gravdahl and K.Y. Pettersen Modeling and Control of Vehicle-Manipulator Systems, Springer-Verlag, To be published.
- Fossen, T. I. and H. Nijmeijer (2011) (eds.). Parametric Resonance in Dynamical Systems, Springer-Verlag, November 2011.
<php> $mysqli = new mysqli(«localhost», «cics», «cics123», «cics»);
/* 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 1) { 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>