Very Thanks for your recommendations ! , i Edit new my Code because before i did a mistake.. , i will which on the File Only Display the Table with Comments with a button for DELETE beside each row so that if I want to delete that row I click the delete button ....
Before I has not gut explain what i have , sorry about these mistake....
So , i have Two Files for my Comments , classprove.php for Administrate my Comments (People help me with these Code..), and kommenter_verwalter.php , where i will they to Display.
My classprove.php , https://codeshare.io/Gq9byk
The Code from kommenter_verwalter.php,
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
require 'classprove.php';
class ClassProveContakt2
{
private $dbHost = 'localhost'; # Host der Datenbank
private $dbName = 'meine'; # Name der Datenbank
private $dbUser = 'root'; # Name phpmyadmin
private $dbPass = 'pass'; # Passwort
private $Name;
private $Email;
private $Message;
private $PostOK;
private $datetime;
private $items;
private $ip;
private $db;
function CommentToDatabase()
{
// Establish connection with MYSQL Server
try
{
$db = new PDO("mysql:host=localhost;dbname=meine", "root", "pass");
}
catch (PDOException $pe)
{
echo "<br>Cannot connect to database: " . $pe->getMessage();
return false;
}
if(isset($_POST["delete"])) {
try {
require classprove.php;
$connection = new PDO($id, $name, $email, $message, $datetime, $ip);
$id = $_POST["id"];
$sql = "DELETE FROM mela WHERE id = :id";
$statement = $connection->prepare($sql);
$statement->bindValue(':id', $id);
$statement->execute();
$success = "User successfully deleted";
}catch(PDOException $error) {
echo $sql . "<br>" . $error->getMessage();
}
}
}
function tabelle($New)
{
$db = $this ->getMessages();
if ($sb)
{
echo "<table id='user' class='table table-bordered'>
<tr>
<th>id</th>
<th>name</th>
<th>email</th>
<th>message</th>
<th>datetime</th>
<th>ip</th>
<th>Delete User</th>
</tr>";
foreach ($sb as $row):
echo "EOT
<form action="classprove.php" method="post"><tr>
<td>{$row['id']}</td>
<td>{$row['name']}</td>
<td>{$row['email']}</td>
<td>{$row['datetime']}</td>
<td>{$row['ip']}</td>
</tr></form>
EOT";
endforeach;
echo "</table>";
}
}
}
$New = new ClassProveContakt2();
$New -> tabelle();
?>
With
sudo tail -n0 -f /var/log/apache2/error.log /var/log/mysql/error.log
Now to come,
PHP Parse error: syntax error, unexpected 'classprove' (T_STRING), expecting ',' or ';' in /var/www/html/kommenter_verwalter.php on line 91
On Line 91 , I have
<form action="classprove.php" method="post"><tr>
