Untitled

 <!DOCTYPE html>
<html>
<h1>my first pargraph</h1>
<body>


<form method="POST" action="connection.php">
comment:<br>
Task: <input type="text" name="ID"><br>

<input type="text" name="comment" value=""><br>
<input type="submit" value="submit">
</form>


<h2> cheack connection </h2>


 <?php
$servername = "localhost";
$username = "phpmyadmin";
$password = "ofir1234";
$dbname = "phpmyadmin";

// Create connection
$conn = new mysqli($servername, $username, $password,$dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO userlogin ( names,password)
VALUES ( 'eti', '1234456')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

 <?php
$servername = "localhost";
$username = "phpmyadmin";
$password = "ofir1234";

// Create connection
$conn = mysqli_connect($servername, $username, $password);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());

    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";


mysqli_close($conn);

?>


<section id="new-comment">
        <h2>insert new comment here:</h2>
        <form action=connection.php method="GET">
        <input type="text" name="text" placeholder="Insert your text..." />
        <input type="submit" value="submit text" />

<php
$servername = "localhost";
$username = "phpmyadmin";
$password = "ofir1234";
$dbname = "phpmyadmin";

// Create connection
$conn = mysqli_connect($servername, $names, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT names, password FROM userlogin";
$result = mysqli_query($conn, $sql);

if (phpmyadmin_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "id: " . $row["id"]. " - names: " . $row["password"]. "<br>";
    }
} else {
    echo "0 results";
}

mysqli_close($conn);
?>

</body>
</html>