Advertisement
Guest User

Untitled

a guest
Jul 27th, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. <title>Add to Table</title>
  2. <body>
  3.  
  4. <form id="form1" name="form1" method="post" action="">
  5. <p>
  6. <input name="Title" type="text" id="Title"size="50" />
  7. </p>
  8.  
  9. <p>
  10. <input name="Game" type="text" id="Game" size="50" />
  11. </p>
  12.  
  13. <p>
  14. <input name="Description" type="text" id="Description" size="75" />
  15. </p>
  16.  
  17. <p>
  18. <input name="Author" type="text" id="Author" size="50" />
  19. </p>
  20.  
  21.  
  22. <p>
  23. <input name="TitleID" type="text" id="tid" size="50" />
  24. </p>
  25.  
  26. <p>
  27. <input name="Hash" type="text" id="Hash" size="50" />
  28. </p>
  29.  
  30. <p>
  31. <input name="Like" type="text" id="Like" size="50" />
  32. </p>
  33.  
  34. <button name="Add" Type="Submit" id="Add">Add Save</button>
  35. </form>
  36.  
  37. <?php
  38. // SQL Database Structure
  39. $Host = "localhost";
  40. $Username = "asdwer45_billyf";
  41. $Password = "I~d*X@upz-cI";
  42. $db_name = "asdwer45_billy";
  43.  
  44. // Table Structure
  45. $Table = "gamesave";
  46. $Col1 = "ID";
  47. $Col2 = "Title";
  48. $Col3 = "Game";
  49. $Col4 = "Description";
  50. $Col5 = "Author";
  51. $Col6 = "Hash";
  52. $Col7 = "TitleID";
  53. //Performs Login to SQL Database
  54. $Conn = mysql_connect($Host,$Username,$Password,$db_name) or die(mysql_error());
  55. mysql_select_db($db_name,$Conn) or die(mysql_error());
  56.  
  57. // Adds to table
  58. if(isset($_POST['Add']))
  59. {
  60. mysql_query("INSERT INTO gamesave (Title,TitleID, Game, Description, Author, Hash,Likes) VALUES ('$_POST[Title]', '$_POST[TitleID]', '$_POST[Game]','$_POST[Description]','$_POST[Author]','$_POST[Hash]','$_POST[Like]')");
  61. }
  62. ?>
  63. </body>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement