Hallo, erste entschuldigung für mein deutsch....
Ich habe zwei dateien die kommenter verwalten, beide have vor eineger monate auf diese Forum bekomme..😀 .
Mein Probleme, wenn jemand schreibt ein kommentar, er wird in allem Seite gezeigt, wenn ich möchte der wird nur gezeigt in der datei wo wurde kommentiert...
Die zwei Dateien Code:
Diese Datei benutze um die kommenter zu zeige,
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
class comments {
private $conn;
private $dbHost = 'xxxxxxxx'; # Host der Datenbank
private $dbName = 'xxxxxxxxxxxx'; # Name der Datenbank
private $dbUser = 'xxxxxxxxx'; # Name der User
private $dbPass = 'xxxxxxxxxx'; # Passwort
function __construct() {
try{
$this->conn = new \PDO("mysql:host=localhost;dbname=linuxuse_commentaren", $this->dbUser, $this->dbPass);
}
catch(PDOException $e)
{
echo "Connection failed: " . $e->getMessage();
}
}
function deleteComment($id){
$sql = "DELETE FROM commentar WHERE id=?";
$statement= $this->conn->prepare($sql);
$statement -> bindParam('i', $id);
$statement->execute(array($id));
}
function printAdminTable() {
$sql = "SELECT id, name, email, message, datetime, ip FROM commentar ORDER BY datetime DESC";
$statement= $this->conn->prepare($sql);
$statement->execute();
$result = $statement-> fetchAll();
if ( $result ) {
echo "
<form action=\"kommentaren.php\" method=\"POST\">\n
<table id='user' class='table table-bordered' border= '1px solid';>
<tr>
<th>ID</th>
<th>Name</th>
<th>E-mail</th>
<th>Message</th>
<th>Datetime</th>
<th>IP</th>
<th>Delete</th>
</tr>";
foreach($result as $row) {
echo <<<EOT
<tr>
<td>{$row['id']}</td>
<td>{$row['name']}</td>
<td>{$row['email']}</td>
<td>{$row['message']}</td>
<td>{$row['datetime']}</td>
<td>{$row['ip']}</td>
<td><button type="submit" name="delete" value="{$row['id']}">Delete</button>
</tr>
EOT;
}
echo '</table></form>';
} else {
echo '<p class="error">Hm. $arrRows enthält nichts oder false. '
.'Entweder ist die Datenbank noch leer oder da ist was falsch.</p>';
}
}
function __destruct(){
$this->conn = null;
}
}
$News = new comments();
if (isset($_POST['delete'])){
$News -> deleteComment($_POST['delete']);
}
$News -> printAdminTable();
Diese verwalte der datenbank,
<?php
class ClassProveContakt3 {
private $dbHost = 'xxxxxxxxxxxx'; # Host der Datenbank
private $dbName = 'xxxxxxxxx'; # Name der Datenbank
private $dbUser = 'xxxxxxxxx'; # Name der User
private $dbPass = 'xxxxxxxxxxxxx'; # Passwort
private $Name;
private $Email;
private $Message;
private $PostOK;
private $DateTime;
private $items;
private $ip;
private $dbh;
private $ok;
function __construct() {
$this -> ip = $_SERVER['REMOTE_ADDR'];
$this -> DateTime = date('m/d/Y h:i:s a');
$this -> items = ['Name', 'Email', 'Message'];
$flag = true;
if(isset($_POST['Name']) || isset($_POST['Email']) || isset($_POST['Message'])) {
foreach ( $this -> items as $key ) {
if ( empty ( $_POST[$key] ) ) {
$flag = false;
} else {
#trigger_error('Codepoint __construct:1 ' . $key . ': ' . $_POST[$key]);
$this -> $key = trim( filter_var( $_POST[$key], FILTER_SANITIZE_STRING ) );
$this -> $key = trim( $_POST[$key] );
}
}
}
#trigger_error('Codepoint __construct:2 TRUE');
$this -> PostOK = $flag;
#trigger_error('Codepoint __construct:3 ' . $this -> PostOk );
}
public function getConnection() {
// Establish connection with MYSQL Server
try {
$this -> dbh = new PDO( 'mysql:host=' . $this -> dbHost . ';dbname=' . $this -> dbName, $this -> dbUser, $this -> dbPass );
} catch ( PDOException $pe ) {
trigger_error ("Cannot connect to database: " . $pe -> getMessage() , E_USER_ERROR );
}
}
private function reportPDOError( $message, $sql ) {
$info = $this -> dbh -> errorInfo();
echo "<div style='color:red'><b>Error in SQL Access: $message</b>";
echo "<br>SQL-Statement: $sql";
echo "<br>PDO SQLSTATE: $info[0]";
echo "<br>MySQL error code: $info[1]";
echo "<br>MySQL error message: $info[2]</div>";
}
private function unsetFormdata() {
foreach ( $this -> items as $key ) {
unset( $_POST[$key] );
}
}
function ShowForm() {
?>
<!-- <form method="POST" action="https://home.fastix.org/phpinfo.php">-->
<form method="POST" class="post_color">
<label for="name"><b>Name * </b></label>
<input type="text" id="name" name="Name" value="<?=@htmlentities( $_POST['Name'] );?>"><br><br>
<label for="email"><b>E-mail * </b></label>
<input type="email" id="email" name="Email" value="<?=@htmlentities( $_POST['Email'] );?>"><br>
<br><br>
<label><b> Message * </b><br>
<textarea cols="45" rows="6" id="text" name="Message"><?=@htmlspecialchars( $_POST['Message'] );?></textarea>
</label>
<br><br>
<input type="submit" name="post" value="POST COMMENT" id="comment">
</form>
<?php
}
function TestPostData() {
if(isset($_POST['Name']) || isset($_POST['Email']) || isset($_POST['Message'])) {
if ( $this -> PostOK ) {
$this -> writeCommentToDatabase();
} else {
echo '<div class="msg">*** Please enter all required fields ***</div><br><br>';
}
}
}
function writeCommentToDatabase() {
// Establish connection with MYSQL Server
if ( ! $this -> dbh ) {
$this -> getConnection();
}
//Prepare Query of SQL
$statement = $this -> dbh -> prepare("INSERT INTO commentar(name, email, message, datetime, ip) VALUES (:name, :email, :message, :date, :ip)");
if ( ! $statement ) {
trigger_error( 'prepare failed: SQLSTATE=' . $this -> dbh -> errorCode() . ', Error Info=' . print_r( $this -> dbh -> errorInfo(), true ), E_USER_ERROR ) ;
} else {
$ok = $statement -> bindValue( ':name', $this -> Name, PDO::PARAM_STR )
&& $statement -> bindValue( ':email', $this -> Email, PDO::PARAM_STR )
&& $statement -> bindValue( ':message', $this -> Message, PDO::PARAM_STR )
&& $statement -> bindValue( ':date', date("Y-m-d H:i:s"), PDO::PARAM_STR )
&& $statement -> bindValue( ':ip', $this -> ip, PDO::PARAM_STR );
if ( ! $ok ) {
echo "<br><br>bindValue failed: SQLSTATE=" . $this -> dbh -> errorCode() . ", Error Info=" . print_r( $dbh -> errorInfo(), true ) . "</p>";
}
}
if ( $ok ) {
$ok = $statement -> execute();
}
if ( $ok === false ) {
trigger_error( 'execute failed: SQLSTATE=' . $this -> dbh -> errorCode() . ', Error Info=' . print_r($this -> dbh -> errorInfo(), true), E_USER_ERROR );
} else {
#echo '<div class="msg">Data Inserted successfully!</div>';
$this -> unsetFormdata();
return $ok;
}
}
function getMessages()
{
if ( ! $this -> dbh ) {
$this -> getConnection();
}
$sql = "SELECT id, name, email, message, datetime FROM commentar ORDER BY datetime DESC";
$statement = $this -> dbh -> query( $sql );
if ( ! $statement ) {
$this -> reportPDOError('SQL-Error:', $sql );
return false;
}
$result = $statement -> fetchAll( PDO::FETCH_ASSOC );
if ( false === $result ) {
$this->reportPDOError( "fetchAll(ASSOC) failed", $sql );
}
foreach ($result as $message) {
?>
<p><strong>From: </strong> <?=htmlspecialchars( $message['name'] ) ?> <strong>at: </strong> <?=htmlspecialchars( $message['datetime'] ); ?></p>
<p><?=htmlspecialchars( $message['message'] ); ?></p><hr>
<?php
}
}
}
$Newobject = new ClassProveContakt3();
$Newobject -> TestPostData();
$Newobject -> ShowForm();
$Newobject -> getMessages();
ich verbinde meine dateien mit dem verwaltet datei mit,
<?php
include '/home/xxxxxxxx/xxxx/xxxxx.php';
?>
Kann Bitte jemand mir hilfe mit diesem probleme, Danke!
liebewinter
Matthias Apsel
Rolf B
Der Martin
