Kommentar werden auf alles Webseite gezeigt

[liebewinter]

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!