Файловый менеджер - Редактировать - /home/carpe/public_html/dataviz/check.php
Назад
<?php class Database { private $host = "localhost"; private $db_name = "carpe_sae"; private $username = "carpe_php"; private $password = "onestdestubesonestpasdespots"; private $conn; public function getConnection() { $this->conn = null; try { $this->conn = new PDO( "mysql:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password ); $this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $exception) { echo "Erreur de connexion : " . $exception->getMessage(); } return $this->conn; } } $database = new Database(); $connexion = $database->getConnection(); if ($connexion) { if(isset($_POST['cause'])){ $cause = $_POST['cause']; if($cause == "mois"){ $sql = "SELECT MMAR,COUNT(*) as compte FROM `marriages` GROUP BY MMAR ORDER BY MMAR"; $statement = $connexion->prepare($sql); $statement->execute(); $results = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($results as $row) { echo $row['MMAR']; echo ","; echo $row['compte']; echo "."; } } if($cause == "jour"){ $sql = "SELECT JSEMAINE,COUNT(*) as compte FROM `marriages` GROUP BY JSEMAINE ORDER BY JSEMAINE"; $statement = $connexion->prepare($sql); $statement->execute(); $results = $statement->fetchAll(PDO::FETCH_ASSOC); foreach ($results as $row) { echo $row['JSEMAINE']; echo ","; echo $row['compte']; echo "."; } } } } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.0.30 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка