Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <meta charset="utf8"></meta>
- </head>
- <?php
- class ConnexionBdd {
- private $_dbmysql;
- public function __construct() {
- $connect_str = "mysql:host=localhost;dbname=subway";
- $connect_user = "root";
- $connect_pass = "";
- try {
- $options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8', PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION);
- $this->_dbmysql = new PDO($connect_str, $connect_user, $connect_pass, $options);
- }
- catch (Exception $e)
- {
- throw new Exception("Erreur à la connexion \n" . $e->getMessage());
- }
- }
- public function displayData()
- {
- $sql = $this->_dbmysql->prepare('SELECT * FROM aliment');
- $sql->execute();
- $data=$sql->fetchAll();
- foreach($data as $key=>$value)
- {
- echo '<tr>';
- echo '<td>'.$data[$key][1].'</td>';
- echo '<td>'.$data[$key][2].'</td>';
- echo '<td>'.$data[$key][3].'</td>';
- echo '<td>'.$data[$key][4].'</td>';
- echo '</tr>';
- }
- echo "</table>";
- }
- public function getData()
- {
- $sql = $this->_dbmysql->prepare('SELECT * FROM aliment');
- $sql->execute();
- $data=$sql->fetchAll();
- return $data;
- }
- public function getDataRecent()
- {
- $sql = $this->_dbmysql->prepare('SELECT * FROM data ORDER BY horodatage');
- $sql->execute();
- $data=$sql->fetchAll();
- return $data;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement