The text below is selected, press Ctrl+C to copy to your clipboard. (⌘+C on Mac) No line numbers will be copied.
Guest
Student display
By Guest on 26th July 2024 12:26:54 AM | Syntax: PYTHON | Views: 33


New Paste New paste | Download Paste Download | Toggle Line Numbers Show/Hide line no. | Copy Paste Copy text to clipboard
  1. <?php
  2. $dbhost='localhost';
  3. $dbuser='root';
  4. $dbpass='user@123';
  5. $dbname='BOOK';
  6. $conn=mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
  7. if($conn->connect_error){
  8.  die("connection failed:".$conn->connect_error);
  9. }else{
  10.  echo "connected sucessfully";
  11. }
  12. echo "<br>";
  13. $sql="SELECT * FROM STUDENT";
  14. $result=$conn->query($sql);
  15. if($result->num_rows>0){
  16.  while($row=$result->fetch_assoc()){
  17.  echo "roll_no:".$row["roll_no"]. -"name:".$row["name"]." -marks:".$row["marks"]." -
  18. grade:".$row["grade"]."<br>";
  19.  }
  20. }else {
  21.  echo "0 results";
  22.  }
  23. mysqli_close($conn);
  24. ?>





student display