Advertisement
Guest User

Untitled

a guest
Nov 13th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Afisare</title>
  4. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  5. </head>
  6.  
  7. <body>
  8.  
  9. <center>
  10. <h2>
  11. <a href="http://localhost/lab3/meniu.htm">Revenire la meniu</a>
  12. </h2>
  13. </center>
  14.  
  15. </body>
  16.  
  17. <?php
  18.  
  19. mysql_connect("localhost", "root", "") or die ("Nu se poate conecta la serverul MySQL");
  20. mysql_select_db("facultate") or die ("Nu se poate selecta baza de date");
  21.  
  22. $query = mysql_query("select * from studenti_ac");
  23.  
  24. $nr_inregistrari = mysql_num_rows($query);
  25.  
  26. if($nr_inregistrari == 0)
  27. {
  28. echo "<center>"."Baza de date este goala."."br"."</center";
  29. }
  30. else
  31. {
  32. echo "<center>"."Studentii din baza de date sunt:"."<br>"."</center";
  33. echo "<tr>";
  34. //cap de tabel
  35. echo "<table border='2' align='center'>";
  36. echo "<tr bgcolor='silver'>";
  37. echo "<th>Marca</th>";
  38. echo "<th>Nume</th>";
  39. echo "<th>Prenume</th>";
  40. echo "<th>An Studiu</th>";
  41. echo "</tr>";
  42. //valorile efective
  43. while($row = mysql_fetch_row($query))
  44. {
  45. echo "<tr>";
  46. foreach ($row as $value)
  47. echo "<td>$value</td>";
  48. echo "</tr>";
  49. }
  50.  
  51. }
  52.  
  53. ?>
  54.  
  55. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement