Advertisement
Guest User

Untitled

a guest
Jul 19th, 2017
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.81 KB | None | 0 0
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  2. <html>
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  5. <title></title>
  6. </head>
  7. <body>
  8. <?php
  9.  
  10. echo "Dette er en test side";
  11. $pageID = 1;
  12. echo "<br>";
  13.  
  14. $dbhost = 'localhost';
  15. //mulig det trengs et port nr her 8889
  16.  
  17. $dbuser = 'root';
  18. $dbpass = 'root';
  19. $dbname = 'kommentar';
  20.  
  21.  
  22. $conn = mysql_connect($dbhost,$dbuser,$dbpass) or die ('Error connecting to mysql');
  23. echo "Koblet til";
  24. echo "<br>";
  25. mysql_select_db($dbname, $conn);
  26.  
  27.  
  28. //
  29. //Disse to linjer henter ut antall tidligere kommentarer
  30. //
  31. $result = mysql_query("Select COUNT(*) AS NUM FROM kommentar Where SideId = 1");
  32. $mycount = mysql_result($result,0,"num");
  33. $mycount = $mycount+1;
  34.  
  35. mysql_query("INSERT INTO kommentar (KommentarId, SideId, kommentar)
  36. VALUES ('".$mycount."', '".$pageID."', '".$_POST[kommentar]."')");
  37.  
  38. //
  39. //Dette er for å hente ut data og vise det frem
  40. //
  41. //
  42. $result = mysql_query("Select kommentar From kommentar Where SideId ='" . $pageID . "'");
  43.  
  44. echo "<table border='1'>
  45. <tr>
  46. <th>kommentar</th>
  47. </tr>";
  48.  
  49. while($row = mysql_fetch_array($result))
  50. {
  51. echo "<tr>";
  52. echo "<td>" . $row['kommentar'] . "</td>";
  53. echo "</tr>";
  54. }
  55. echo "</table>";
  56.  
  57.  
  58. mysql_close($conn);
  59. ?>
  60. </body>
  61. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement