Advertisement
Guest User

Untitled

a guest
Feb 13th, 2016
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. <?php
  2. if ( empty( $_POST ) ) {
  3. ?>
  4. <form name="newaddgenre" action="newaddgenre.php" method="POST">
  5. <label for 'genre'>Genre: </label>
  6. <input type="text" name="genre_name"/>
  7. <br/>
  8. <button type="button" class="btn btn-primary">Submit</button>
  9. </form>
  10. <?php
  11. } else {
  12. $user = 'root';
  13. $pass = 'mysql';
  14. $db = new PDO ('mysql:host=localhost;dbname=musicdb', $user, $pass);
  15. $form = $_POST;
  16. $genre_name = $form[ 'genre_name' ];
  17. $sql = "INSERT INTO genre (genre_name)
  18. VALUES (genre_name)";
  19. $query = $db->prepare( $sql );
  20. $query->execute( array( ':genre_name'=>$genre_name) );
  21. print_r( $_POST );
  22. }
  23. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement