1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119
| <?php
include("MySql.php");
class Publication
{
var $num_publi;
var $titre;
var $date_publi;
var $langage;
// le constructeur permet d'initialiser
// les variables membres
function __construct($num_publi,$titre,$date_publi,$langage)
{
$this->num_publi =$num_publi;
$this->titre =$titre;
$this->date_publi = $date_publi;
$this->langage = $langage;
}
function getnum_publication() { return $this->num_publi;}
function gettitre_publication() { return $this->titre; }
function getdat_publi() { return $this->date_publi; }
function getlangage() { return $this->langage; }
function lire( $num_publi )
{
$this->num = $num_publi;
if($this->num> 0)
{
$bdd = new MySql();
$bdd->connecter();
$requete = "SELECT Titre_publication,Date_publication,langage FROM publication WHERE num_publication='".$this->num."'";
$resultat = $bdd->executerRequete( $requete );
$bdd->deconnecter();
$donnees = $bdd->prochainResultat($resultat);
$this->titre = $donnees['titre_publication'];
$this->date_publi = $donnees['date_publication'];
$this->langage = $donnees['langage'];
}
}
function enregistrer()
{
$bdd = new MySql();
$bdd->connecter();
$requete="INSERT INTO publication(titre_publication,Date_publication,langage )
VALUES ('".mysql_escape_string($this->titre)."','".mysql_escape_string($this->date_publi)."',
'".mysql_escape_string($this->langage)."');";
$bdd->executerRequete( $requete );
$bdd->deconnecter();
}
function modifier()
{
$bdd = new MySql();
$bdd->connecter();
$requete = "UPDATE publication";
$requete .= "SET titre_publication='" . mysql_escape_string($this->titre) . "', ";
$requete .= "Date_publication='" . mysql_escape_string($this->date_publi) . "', ";
$requete .= "langage='" . mysql_escape_string($this->language) . "' ";
$requete .= "WHERE num_publication='" . $this->num_publi . "'";
$bdd->executerRequete( $requete );
$bdd->deconnecter();
}
function supprimer( $num_publi)
{
$bdd = new MySql();
$bdd->connecter();
$bdd->executerRequete(" DELETE FROM news WHERE id='".$num_publi."'");
//$bdd->executerRequete(" DELETE FROM WHERE num_publications='".$num_publi."'");
$bdd->deconnecter();
}
function __toString()
{
setlocale(LC_TIME, "fr_FR", "FRA");
$date = strftime("Le %A %d %B %Y ", $this->date);
$ret = "<b><u>".$this->titre . "</u></b><br/>" . nl2br($this->langage) . "<br/>" . $date . " - ";
$ret .= "<br/><br/><br/>";
return $ret;
}
}
?>
et la classe livre est :
<?
class Livre extends Publication
{
private $editeur;
private $isbn;
private $type_livre;
function __construct($num_publi, $titre, $date_publi, $langage, $isbn,$editeur,$type_livre)
{
$this->editeur = $editeur;
$this->isbn = $isbn;
$this->type_livre= $type_livre;
parent::__construct($num_publi, $titre, $date_publi, $langage);
}
}
?> |
Partager