From a8d40a4ac2f73da9509bde6c8337c13042cc6992 Mon Sep 17 00:00:00 2001 From: vincent-peugnet Date: Sat, 17 Mar 2018 19:55:22 +0100 Subject: transfert --- class/class.app.php | 101 ++++++++++++++++++++++--- class/class.art.php | 207 +++++++++++++++++++++++++++++++++++++++++++++++++++- fn/fn.php | 14 +++- public/index.php | 25 +++++++ public/w/index.php | 58 ++++++++++++--- 5 files changed, 379 insertions(+), 26 deletions(-) diff --git a/class/class.app.php b/class/class.app.php index 4078c17..056e65b 100644 --- a/class/class.app.php +++ b/class/class.app.php @@ -1,30 +1,111 @@ +

class.app

bdd = new PDO('mysql:host=' . $config['host'] . ';dbname=' . $config['dbname'] . ';charset=utf8', $config['user'], $config['password']); + // } catch (Exeption $e) { + // die('Erreur : ' . $e->getMessage()); + // } + try { - $this->bdd = new PDO('mysql:host=' . $host . ';dbname=' . $dbname . ';charset=utf8', $user, $password); + $this->bdd = new PDO('mysql:host=localhost;dbname=wcms;charset=utf8', 'root', ''); } catch (Exeption $e) { die('Erreur : ' . $e->getMessage()); } } - public function getBdd() + public function add(Art $art) + { +// tester l'existence de l'id + $now = new DateTimeImmutable(null, timezone_open("Europe/Paris")); + + $q = $this->bdd->prepare('INSERT INTO art(id, titre, soustitre, intro, tag, datecreation, datemodif, css, html, secure, couleurtext, couleurbkg, couleurlien) VALUES(:id, :titre, :soustitre, :intro, :tag, :datecreation, :datemodif, :css, :html, :secure, :couleurtext, :couleurbkg, :couleurlien)'); + + $q->bindValue(':id', $art->id()); + $q->bindValue(':titre', $art->titre()); + $q->bindValue(':soustitre', $art->soustitre()); + $q->bindValue(':intro', $art->intro()); + $q->bindValue(':tag', $art->tag()); + $q->bindValue(':datecreation', $now->format('Y-m-d H:i:s')); + $q->bindValue(':datemodif', $now->format('Y-m-d H:i:s')); + $q->bindValue(':css', $art->css()); + $q->bindValue(':html', $art->html()); + $q->bindValue(':secure', $art->secure()); + $q->bindValue(':couleurtext', $art->couleurtext()); + $q->bindValue(':couleurbkg', $art->couleurbkg()); + $q->bindValue(':couleurlien', $art->couleurlien()); + + $q->execute(); + } + + public function delete(Art $art) { - return $this->bdd; + $this->bdd->exec('DELETE FROM art WHERE id = ' . $art->id()); } - public function createfrombdd($id, $bdd) + public function get($id) { + $q = $this->bdd->query('SELECT * FROM art WHERE id = ' . $id); + $donnees = $q->fetch(PDO::FETCH_ASSOC); + + return new Art($donnees); + } + + public function getlist() + { + $listart = []; + + $q = $this->bdd->query('SELECT titre, soustitre, intro FROM art ORDER BY titre'); + + while ($donnees = $q->fetch(PDO::FETCH_ASSOC)) { + $listart[] = new art($donnees); + } + return $listart; } + public function count() + { + return $this->bdd->query('SELECT COUNT(*) FROM art')->fetchColumn(); + } + + // public function exist($id) + // { + // $r = $this->bdd->query('SELECT COUNT(*) AS art FROM art WHERE id = '.$id); + // return $donnees = $r->fetch(PDO::FETCH_ASSOC); + // } + + public function exist($id) + { + return $this->bdd->query('SELECT COUNT(*) FROM art WHERE id = ' . $id)->fetchColumn(); + } + + public function update(Art $art) + { + $q = $this->bdd->prepare('UPDATE art SET titre = :titre, soustitre = :soustitre, intro = :intro, tag = :tag, datecreation = :datecreation, datemodif = :datemodif, cass = :css, html = :html, secure = :secure, couleurtext = :couleurtext, couleurbkg = :couleurbkg, couleurlien = :couleurlien WHERE id = :id'); + + $q->bindValue(':id', $art->id()); + $q->bindValue(':titre', $art->titre()); + $q->bindValue(':soustitre', $art->soustitre()); + $q->bindValue(':intro', $art->intro()); + $q->bindValue(':tag', $art->tag()); + $q->bindValue(':datecreation', $art->datecreation()); + $q->bindValue(':datemodif', $art->datemodif()); + $q->bindValue(':css', $art->css()); + $q->bindValue(':html', $art->html()); + $q->bindValue(':secure', $art->secure(), PDO::PARAM_INT); + $q->bindValue(':couleurtext', $art->tag()); + $q->bindValue(':couleurbkgt', $art->couleurbkgt()); + $q->bindValue(':couleurlien', $art->couleurlien()); + + $q->execute(); + } + + } ?> \ No newline at end of file diff --git a/class/class.art.php b/class/class.art.php index 6b126ea..a94b649 100644 --- a/class/class.art.php +++ b/class/class.art.php @@ -1,12 +1,215 @@ +

class.art

hydrate($donnees); + } - public function createfrombdd($id, $bdd) + public function hydrate(array $donnees) { + foreach ($donnees as $key => $value) { + $method = 'set' . $key; + if (method_exists($this, $method)) { + $this->$method($value); + } + } } + // _____________________________________________________ G E T ____________________________________________________ + + public function id() + { + return $this->id; + } + + public function titre() + { + return $this->titre; + } + + public function soustitre() + { + return $this->soustitre; + } + + public function intro() + { + return $this->intro; + } + + public function tag() + { + return $this->tag; + } + + public function datecreation() + { + return $this->datecreation; + } + + public function datemodif() + { + return $this->datemodif; + } + + public function css() + { + return $this->css; + } + + public function html() + { + return $this->html; + } + + public function secure() + { + return $this->secure; + } + + public function couleurtext() + { + return $this->couleurtext; + } + + public function couleurbkg() + { + return $this->couleurbkg; + } + + public function couleurlien() + { + return $this->couleurlien; + } + + + + // _____________________________________________________ S E T ____________________________________________________ + + public function setid($id) + { + if (strlen($id) < self::$len and is_string($id)) { + $this->id = strip_tags(strtolower(str_replace(" ", "", $id))); + } + } + + public function settitre($titre) + { + if (strlen($titre) < self::$len and is_string($titre)) { + $this->titre = strip_tags(trim($titre)); + } + } + + public function setsoustitre($soustitre) + { + if (strlen($soustitre) < self::$len and is_string($soustitre)) { + $this->soustitre = strip_tags(trim($soustitre)); + } + } + + public function setintro($intro) + { + if (strlen($intro) < self::$len and is_string($intro)) { + $this->intro = strip_tags(trim($intro)); + } + } + + public function settag($tag) + { + if (strlen($tag) < self::$len and is_string($tag)) { + $this->tag = strip_tags(trim(strtolower($tag))); + } + } + + public function setdatecreation($datecreation) + { + if ($datecreation instanceof DateTimeImmutable) { + $this->datecreation = $datecreation; + } else { + $this->datecreation = DateTimeImmutable::createFromFormat('Y-m-d H:i:s', $datecreation, new DateTimeZone('Europe/Paris')); + } + } + + public function setdatemodif($datemodif) + { + if ($datemodif instanceof DateTimeImmutable) { + $this->datemodif = $datemodif; + } else { + $this->datemodif = DateTimeImmutable::createFromFormat('Y-m-d H:i:s', $datemodif, new DateTimeZone('Europe/Paris')); + } + } + + public function setcss($css) + { + if (strlen($css) < self::$len and is_string($css)) { + $this->css = strip_tags(trim(strtolower($css))); + } + } + + public function sethtml($html) + { + if (strlen($html) < self::$lenhtml and is_string($html)) { + $this->html = $html; + } + } + + public function setsecure($secure) + { + if ($secure >= 0 and $secure <= self::$securemax) { + $this->secure = $secure; + } + } + + public function setcouleurtext($couleurtext) + { + $couleurtext = strval($couleurtext); + if (strlen($couleurtext) < self::$lencouleur) { + $this->couleurtext = strip_tags(trim($couleurtext)); + } + } + + public function setcouleurbkg($couleurbkg) + { + $couleurbkg = strval($couleurbkg); + if (strlen($couleurbkg) < self::$lencouleur) { + $this->couleurbkg = strip_tags(trim($couleurbkg)); + } + } + + public function setcouleurlien($couleurlien) + { + $couleurlien = strval($couleurlien); + if (strlen($couleurlien) < self::$couleurlien) { + $this->couleurlien = strip_tags(trim($couleurlien)); + } + } + + } ?> \ No newline at end of file diff --git a/fn/fn.php b/fn/fn.php index e64a9c4..cef8a1c 100644 --- a/fn/fn.php +++ b/fn/fn.php @@ -1,6 +1,4 @@ -secure - -session +

functions

+ + + + <?= $title ?> + + diff --git a/public/index.php b/public/index.php index e69de29..90df7d7 100644 --- a/public/index.php +++ b/public/index.php @@ -0,0 +1,25 @@ + +w + + + \ No newline at end of file diff --git a/public/w/index.php b/public/w/index.php index 250a870..85c0902 100644 --- a/public/w/index.php +++ b/public/w/index.php @@ -2,24 +2,60 @@ //inw -$root = $_SERVER["DOCUMENT_ROOT"]; -require($root . '/fn.php'); -require($root . '/class/art.php'); -$config = include($root . '/config.php'); -$domaine = $config['domaine']; +set_include_path('e:/WEB/wcms'); + +require('fn/fn.php'); +require('class/class.art.php'); +require('class/class.app.php'); +$config = include('config.php'); +$app = new App(); session(); // fin de in -$app = new App($config); -$art = new Art; -$art->createfrombdd($id, $app->getBdd()); -include($root . '/head.php') +head('article'); + + +// $art = new Art([ +// 'id' => 'prout', +// 'titre' => 'Prout', +// 'soustitre' => 'mega prout !', +// 'intro' => 'bienvenue dans le mega prout', +// 'datemodif' => new DateTimeImmutable(null, timezone_open("Europe/Paris")) +// ]); + +// echo '
';
+// print_r($art);
+// print_r($app);
+// echo '
'; + +// $app->add($art); + +// echo '

art count :' . $app->count() . '

'; +// echo '

article exist :' . $app->exist('articlet') . '

'; +// var_dump($app->exist('articlet')); + +// $app->get('articlet'); + +// echo '
';
+// print_r($art);
+// print_r($app);
+// echo '
'; + +try { + $bdd = new PDO('mysql:host=localhost;dbname=wcms;charset=utf8', 'root', ''); +} catch (Exeption $e) { + die('Erreur : ' . $e->getMessage()); +} + +$q = $bdd->query('SELECT * FROM art WHERE id = articlet'); +$donnees = $q->fetch(); + +var_dump($donnees); -rpout -CURLOPT_PROXYAUT +$q = closeCursor(); -- cgit v1.2.3