Science Score: 18.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
✓CITATION.cff file
Found CITATION.cff file -
○codemeta.json file
-
○.zenodo.json file
-
○DOI references
-
○Academic links in README
-
○Academic email domains
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Unable to calculate vocabulary similarity
Last synced: 10 months ago
·
JSON representation
·
Repository
PDO (bdd citations)
Basic Info
Statistics
- Stars: 0
- Watchers: 2
- Forks: 0
- Open Issues: 0
- Releases: 0
Created about 6 years ago
· Last pushed about 6 years ago
Metadata Files
Citation
Owner
- Name: Laurine Aujeau
- Login: laurineaujeau
- Kind: user
- Company: ISEN Nantes
- Repositories: 1
- Profile: https://github.com/laurineaujeau
Citation (citation.php)
<!DOCTYPE html>
<html>
<head>
<link rel='stylesheet' type='text/css' >
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" href="citation.php">Informations</a>
</li>
<li class="nav-item">
<a class="nav-link" href="recherche.php">Recherche</a>
</li>
<li class="nav-item">
<a class="nav-link" href="modification.php">Modification</a>
</li>
</ul>
</div>
</nav>
<?php
include "connexpdo.php";
$base='pgsql:dbname=citations;host=127.0.0.1;port=5432';
$user = 'postgres';
$password = 'isen2018';
$idcon = connexpdo($base,$user,$password);
echo '<h1>La citation du jour</h1><hr>';
$query4 = "SELECT * from citation";
$result4 = $idcon->query($query4);
$compteur =0;
foreach($result4 as $data){
$compteur = $compteur +1;
}
echo 'Il y a <strong>'.$compteur.'</strong> citations répertoriées.';
echo '<br>';
echo 'Et en voici une générée aléatoirement :';
echo '<br>';
$alea = rand (1,$compteur);
/*if ($result4 ){
//echo $result4; ne fonctionne pas
//echo $result4->fetch() ; fontionne mais n'affiche rien
}*/
$query5 = "SELECT * from citation";
$result5 = $idcon->query($query5);
foreach($result5 as $data){
if($alea == $data['id']){
echo '<strong>';
echo $data['phrase'];
echo '</strong><br>';
$query6 = "SELECT * from auteur";
$result6 = $idcon->query($query6);
foreach($result6 as $data2){
if($data['auteurid'] == $data2['id']){
echo $data2['prenom']." ".$data2['nom']." ";
}
}
$query7 = "SELECT * from siecle";
$result7 = $idcon->query($query7);
foreach($result7 as $data2) {
if ($data['siecleid'] == $data2['id']) {
echo "(" . $data2['numero'] . " ème siècle)";
}
}
}
}
?>
</body>
</html>