Advertisement
Guest User

Untitled

a guest
Jun 20th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. <!-fechtarr.php->
  2.  
  3. <html>
  4.  
  5. <body>
  6.  
  7. <table>
  8.  
  9. <?php
  10. include ("dbconfig.php");
  11.  
  12. $query = "SELECT * FROM cds";
  13.  
  14. $result = mysql_query($query);
  15.  
  16. echo mysql_error();
  17.  
  18. while ($line = mysql_fetch_array($result)) { ?>
  19.  
  20. <tr>
  21.  
  22. <td><?PHP echo $line[interpret];?></td>
  23.  
  24. <td><?PHP echo $line[titel];?></td>
  25.  
  26. <td><a href="update.php?id=<?PHP echo $line[id];?>">Edit</a></td>
  27.  
  28. <td><a href="delete.php?id=<?PHP echo $line[id];?>">Delete</a></td>
  29.  
  30. </tr>
  31.  
  32. <?PHP
  33.  
  34. }
  35.  
  36. mysql_free_result($result);
  37.  
  38. mysql_close();
  39.  
  40. ?>
  41.  
  42. </table><br>
  43.  
  44. <a href="insert.php">neuer Eintrag</a>
  45.  
  46. </body>
  47.  
  48. </html>
  49.  
  50. <?
  51. $dbname="test";
  52. $dbhost="localhost";
  53. $dbuser="...";
  54. $dbpass="...";
  55. mysql_connect($dbhost,$dbuser,$dbpass);
  56. mysql_select_db($dbname);
  57. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement