Advertisement
Guest User

Untitled

a guest
Jan 20th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. <form method="post">
  2. <table>
  3. <tr>
  4. <td style="text-align:right">Artista:</td>
  5. <td><input type="text" name="artist" /></td>
  6. </tr>
  7. <tr>
  8. <td style="text-align:right">Titulo:</td>
  9. <td><input type="text" name="title" /></td>
  10. </tr>
  11. <tr>
  12. <td style="text-align:right">Capa (link):</td>
  13. <td><input type="text" name="cover" /></td>
  14. </tr>
  15. <tr>
  16. <td colspan="2">
  17. <center>
  18. <input type="submit" style="margin-top:20px" />
  19. </center>
  20. </td>
  21. </tr>
  22. </table>
  23. </form>
  24.  
  25. if (isset($_POST['submit'])){
  26. $dbhost = 'HOST';
  27. $dbuser = 'USER';
  28. $dbpass = 'PASS';
  29. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  30. $artist = strtoupper($_POST[artist]);
  31. $title = strtoupper($_POST[title]);
  32. $cover = $_POST[cover];
  33. if(! $conn )
  34. {
  35. die('Could not connect: ' . mysql_error());
  36. }
  37. $sql = "INSERT INTO 'MusicList'('artist', 'title', 'cover', 'votes') VALUES ('".$artist."', '".$title."', '".$cover."', 0)";
  38. mysql_select_db('DATABASE_NAME');
  39. $retval = mysql_query( $sql, $conn );
  40. if(! $retval )
  41. {
  42. die('Could not enter data: ' . mysql_error());
  43. }
  44. echo "<center><h1>Success!</h1></center>";
  45. mysql_close($conn);
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement