Guest User

Untitled

a guest
Dec 6th, 2017
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.28 KB | None | 0 0
  1.  
  2. <form action='blogComment.php' method='post'>
  3. E-mail <input type='text' name='Email_com' /><br/>
  4. Text <textarea type='text' name='Text_com' /><br/>
  5. Author <input type='text' name='Author_com' /><br/>
  6. Website <input type='text' name='Website_com' /><br/>
  7. <input type='Submit' value='Add Comment' name='Submit' />
  8. </form>
  9.  
  10. <?php
  11. $hostname='localhost';
  12. $username='root';
  13. $password='plant';
  14. $dbname='blogproject';
  15.  
  16.  
  17. // ansluter till databasen
  18. $opendb = mysql_connect($hostname,$username,$password,$dbname) or die(mysql_error());
  19. mysql_select_db("blogproject") or die(mysql_error());
  20.  
  21. // variabler hämtas från formulärfälten
  22. $Email = mysql_real_escape_string($_POST["Email_com"]);
  23. $Author = mysql_real_escape_string($_POST["Author_com"]);
  24. $Text = mysql_real_escape_string($_POST["Text_com"]);
  25. $Website = mysql_real_escape_string($_POST["Website_com"]);
  26.  
  27. // skriver information till den angivna tabellen
  28. $newComment = mysql_query("INSERT INTO comments (Email_com, Author_com, Text_com, Website_com)
  29. VALUES('$Email', '$Author', '$Text', '$Website')")
  30.  
  31. or die("This is embarrasing we were not able to post your new post ...<br />" . mysql_error());
  32.  
  33. // visar vilket djur som registrerats
  34. echo "Your comment was successfully added";
  35.  
  36. // stänger databasen
  37. mysql_close($opendb);
  38. ?>
Add Comment
Please, Sign In to add comment