From bd20965314da58dd81a19ed20e9b539b7045257a Mon Sep 17 00:00:00 2001
From: vincent-peugnet <v.peugnet@free.fr>
Date: Sat, 17 Mar 2018 22:15:58 +0100
Subject: class stables

---
 public/index.php | 40 +++++++++++++++++++++++++++++++++-------
 1 file changed, 33 insertions(+), 7 deletions(-)

(limited to 'public/index.php')

diff --git a/public/index.php b/public/index.php
index 90df7d7..9b8a61b 100644
--- a/public/index.php
+++ b/public/index.php
@@ -4,22 +4,48 @@
 
 <?php
 
-var_dump(__FILE__);
+try
+{
+	$bdd = new PDO('mysql:host=localhost;dbname=wcms;charset=utf8', 'root', '');
+}
+catch(Exception $e)
+{
+        die('Erreur : '.$e->getMessage());
+}
 
-$htdocs = str_replace(basename(__FILE__), __FILE__, '');
+// $reponse = $bdd->query('SELECT nom, age FROM art2 WHERE nom = \'eddie\'');
 
-var_dump($htdocs);
+// while ($donnees = $reponse->fetch())
+// {
+// 	echo $donnees['nom'] . ' a ' . $donnees['age'] . ' ANS<br />';
+// }
 
-var_dump($_SERVER["DOCUMENT_ROOT"]);
+// $reponse->closeCursor();
 
+// $req = $bdd->prepare('SELECT nom, age FROM art2 WHERE age = 23 ');
+// $req->execute(array($_GET['possesseur'], $_GET['prix_max']));
 
-set_include_path('e:/WEB/wcms');
+// echo '<ul>';
+// while ($donnees = $req->fetch())
+// {
+// 	echo '<li>' . $donnees['nom'] . ' (' . $donnees['prix'] . ' EUR)</li>';
+// }
+// echo '</ul>';
 
-echo get_include_path();
+// $req->closeCursor();
 
+$req = $bdd->prepare('SELECT * FROM art WHERE id = :id ');
+$req->execute(array('id' => 'articlet'));
 
+echo '<ul>';
+while ($donnees = $req->fetch())
+{
+    echo '<li>' . $donnees['titre'] . ' (' . $donnees['id'] . ' ANS)</li>';
+}
+echo '</ul>';
+
+$req->closeCursor();
 
-include('fn/fn.php');
 
 
 ?>
\ No newline at end of file
-- 
cgit v1.2.3