Re j'ai pas bien compris donc je vais donner tout le code ^^.
config.php:
class News
{
/* Attribut */
private $bdd;
private $perPage;
public function __construct()
{
$this->perPage = 4;
}
/* GETTER */
public function getPerPage()
{
return $this->perPage;
}
/* SETTER */
public function setPerPage($perPage)
{
$this->perPage = $perPage;
}
/* Méthodes */
public function Connectauto()
{
try
{
$this->bdd=new PDO("mysql:host=localhost;dbname=news", 'root', '');
}
catch (PDOException $e)
{
die( "Erreur : " . $e->getMessage() . "<br/>");
}
}
public function SelectAll ()
{
$id=$_GET['id'];
$sql="SELECT * FROM news WHERE id=$id";
$result = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
$data=$result->fetch(PDO::FETCH_ASSOC);
echo "<h1>{$data['titre']}</h1>";
echo "<p> {$data['contenu']} </p>";
echo "<p align\"right\">".date("j/n/Y G:i",strtotime($data["date"]))."</p>";
$sql="SELECT * FROM comment WHERE news_id=$id ORDER BY id DESC";
$result = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
while($data2=$result->fetch(PDO::FETCH_ASSOC))
{
echo "-------------------------------<br/>";
echo $data2["pseudo"];
echo "<p>{$data2['contenu']}</p>";
echo "-------------------------------<br/>";
}
?>
<form action="addcom.php" method="post">
Pseudo : <input type="text" name="pseudo" /><br/>
URL : <input type="text" name="url" /><br/>
Mail : <input type="text" name="mail" /><br/>
Contenu : <br/><textarea name="contenu" style="width:500px;height:200px;"></textarea>
<input type="submit" value="Envoyer" />
<input type="hidden" name="news_id" value="<?php echo $data['id']; ?>" />
</form>
<?php
}
public function linkNewsAll ()
{
$sql = "SELECT COUNT(id) as nbNews FROM news";
$result = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
$data=$result->fetch(PDO::FETCH_ASSOC);
$nbNews = $data['nbNews'];
$nbPage = ceil($nbNews/$this->getPerPage());
if(isset($_GET['p']) && $_GET['p']>0 && $_GET['p']<=$nbPage)
{
$cPage = $_GET['p'];
}
else
{
$cPage = 1;
}
$firstPage = ($cPage-1)*$this->getPerPage();
$sql="SELECT titre, id FROM news ORDER BY date DESC LIMIT $firstPage,".($this->getPerPage())."";
$result = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
while($data=$result->fetch(PDO::FETCH_ASSOC))
{
echo "<a href=\"voir.php?id={$data['id']}\">{$data['titre']}</a>";
$sql="SELECT id FROM comment WHERE news_id={$data['id']}";
$result2 = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
echo "(".$result2->rowCount().")<br/>";
}
for($i=1;$i<=$nbPage;$i++)
{
if($i==$cPage)
{
echo " $i /";
}
else
{
echo "<a href=\"index.php?p=$i\">$i</a> /";
}
}
}
public function SelectAllAdmin ()
{
$sql="SELECT * FROM news ORDER BY date DESC";
$result = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
while($data=$result->fetch(PDO::FETCH_ASSOC))
{
echo "<p>{$data['titre']} -- ";
echo "<a href=\"edit.php?id={$data['id']}\">Modifier cette news</a>";
echo " -- <a href=\"suppr.php?id={$data['id']}\">x</a>";
echo "</p>";
}
}
public function Create()
{
extract($_POST);
$sql= "INSERT INTO news (titre, contenu) VALUES ('$titre' , '$contenu') ";
$result = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
header("Location: index.php");
}
public function Edit()
{
if(!empty($_POST))
{
extract($_POST);
$sql="UPDATE news SET titre='$titre', contenu='$contenu' WHERE id=$id";
$result = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
echo "New Modifiée";
$_GET["id"]=$id;
}
$sql= "SELECT * FROM news WHERE id={$_GET['id']}";
$result = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
$data=$result->fetch(PDO::FETCH_ASSOC);
?>
<form method="post" action="edit.php" />
<input name="id" type="hidden" value=" <?php echo $data["id"]; ?>" />
Titre :<input type="text" name="titre" value= "<?php echo $data["titre"]; ?>" />
<br/>
Contenu :<br/>
<textarea name="contenu" style="with:100%;height:150px;"><?php echo $data["contenu"]; ?></textarea>
<input type="submit" value="C'est parti" >
<br/>
<a href="index.php">Redirection vers index</a>
</form>
<?php
}
public function Delete()
{
$sql= "DELETE FROM news WHERE id={$_GET['id']}";
$result = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
header("Location: index.php");
}
public function addCom ()
{
extract($_POST);
$sql= "INSERT INTO comment (pseudo, url, mail, contenu, news_id) VALUES ('$pseudo', '$url', '$mail', '$contenu', '$news_id') ";
$result = $this->bdd->query($sql) or die ('Erreur SQL !<br />'.$sql.'<br />'.mysql_error() );
header("Location: voir.php?id=$news_id");
}
}
et j'ai voir.php:
<?php
require "config.php";
$app= new News();
$app->Connectauto();
$app->SelectAll();
?>
<!--
<form action="addcom.php" method="post">
Pseudo : <input type="text" name="pseudo" /><br/>
URL : <input type="text" name="url" /><br/>
Mail : <input type="text" name="mail" /><br/>
Contenu : <br/><textarea name="contenu" style="width:500px;height:200px;"></textarea>
<input type="submit" value="Envoyer" />
<input type="hidden" name="news_id" value=" ?php echo $data["id"]; ?>" />
</form>
-->
et enfin edit.php:
<?php
require "../config.php";
$app= new News();
$app->Connectauto();
$app->Edit();
?>
<!--
<form method="post" action="edit.php" />
<input name="id" type="hidden" value=" ?php echo $data["id"]; ?>" />
Titre :<input type="text" name="titre" value= " ?php echo $data["titre"]; ?>" />
<br/>
Contenu :<br/>
<textarea name="contenu" style="with:100%;height:150px;">?php echo $data["contenu"]; ?></textarea>
<input type="submit" value="C'est parti" >
<br/>
<a href="index.php">Redirection vers index</a>
</form>
-->
voila donc mon problème est que j'aimerais utiliser le html dans edit.php et voir.php mais il ne me reconnait pas <?php echo $data['n'importe la quelle']; ?> donc je suis obligé de mettre le html dans mes class se qui n'est pas très propre comme code php OO.
Merci :)