conn = new PDO('pgsql:host=localhost;port=5432;dbname=apisub', $db_user, $db_pass);
} catch (PDOException $e) {
die('Connection failed: ' . $e->getMessage());
}
}
public function printHtmlBegin () {
echo '';
echo 'Api Sub ';
echo 'Inscriptions Api ';
}
function printUser($utclogin, $surname, $firstname) {
echo ''.$firstname.' '. $surname.' ('.$utclogin.' )
';
}
function subList($utclogin) {
$sql = "SELECT *
FROM vsubscription
WHERE utclogin='".$utclogin."'";
$st = $this->conn->prepare($sql);
$st->execute();
$res = $st->fetchAll(PDO::FETCH_ASSOC);
if ($res) {
echo 'Vos inscriptions ';
foreach ($res as $row) {
echo '';
echo ' [désinscription] ';
echo $row['code']."-".$row['name']." (".$row['semester'].$row['year'].", du ".$row['dbegin']." au ".$row['dend'].") [inscrit le ".$row['subdate']."]";
echo '
';
}
}
else {
echo 'Aucune inscription ';
}
}
function apiList($utclogin, $semester, $year) {
$sql = "SELECT *
FROM vApi
WHERE semester='".$semester."' AND year=".$year;
$st = $this->conn->prepare($sql);
$st->execute();
$res = $st->fetchAll(PDO::FETCH_ASSOC);
if ($res) {
echo 'Liste des Api '.$semester.$year.' ';
foreach ($res as $row) {
echo '';
echo '[inscription] ';
echo $row['code']."-".$row['name'];
echo '
';
}
}
else {
echo 'Aucune Api ';
}
}
function subToApi($utclogin, $api) {
$today = date("Ymd");
$sql = "INSERT INTO subscribe VALUES ('".$utclogin."',".$api.",TO_DATE('".$today."','YYYYMMDD'))";
$res=$this->conn->exec($sql);
}
function unsubToApi($utclogin, $api) {
$sql = "DELETE FROM subscribe WHERE utclogin='".$utclogin."' AND api=".$api;
$res=$this->conn->exec($sql);
}
}