aboutsummaryrefslogtreecommitdiff
path: root/class
diff options
context:
space:
mode:
Diffstat (limited to 'class')
-rw-r--r--class/class.app.php101
-rw-r--r--class/class.art.php207
2 files changed, 296 insertions, 12 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 @@
+<h4>class.app</h4>
<?php
class App
{
- protected $bdd;
+ private $bdd;
- public function __construct($config)
+ public function __construct()
{
- $host = $config['host'];
- $dbname = $config['dbname'];
- $user = $config['user'];
- $password = $config['password'];
+ // try {
+ // $this->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 @@
+<h4>class.art</h4>
<?php
+
class Art
{
- public $id;
+ private $id;
+ private $titre;
+ private $soustitre;
+ private $intro;
+ private $tag;
+ private $datecreation;
+ private $datemodif;
+ private $css;
+ private $html;
+ private $secure;
+ private $couleurtext;
+ private $couleurbkg;
+ private $couleurlien;
+
+ private static $len = 255;
+ private static $lenhtml = 65535;
+ private static $securemax = 2;
+ private static $lencouleur = 7;
+
+
+ // _____________________________________________________ F U N ____________________________________________________
+
+ public function __construct(array $donnees)
+ {
+ $this->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
generated by cgit v1.2.3 (git 2.25.1) at 2025-02-23 12:21:25 +0000