Gitlab@Informatics

Skip to content
Snippets Groups Projects
Select Git revision
  • b49bfe37802c0f863f204e356bc9f92b3ea933c8
  • main default protected
2 results

index.php

Blame
  • index.php 623 B
    <?php
    
    $servername = "db";
    $username = "lab2-65160381";
    $password = "mark254421.";
    $dbname = "db";
    
    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    
    // Check connection
    if ($conn->connect_error) {
      die("Connection failed: " . $conn->connect_error);
    }
    
    $sql = "SELECT * FROM student";
    $result = $conn->query($sql);
    
    if ($result->num_rows > 0) {
      // output data of each row
      while($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"]. " - Name: " . $row["fname"]. " " . $row["lname"]. " - Score: " . $row["score"]."<br>";
      }
    } else {
      echo "0 results";
    }
    $conn->close();
    ?>