Advertisement
Guest User

Untitled

a guest
Apr 12th, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. <?php
  2. $dbhost = 'localhost';
  3. $dbuser = 'root';
  4. $dbpass = '';
  5. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  6.  
  7. if (!$conn) {
  8. die ("could not connect: " . mysql_error());
  9. }
  10.  
  11. $first_name = $_POST['first_name'];
  12. $last_name = $_POST['last_name'];
  13. $deck = $_POST['deck'];
  14. $card_number = $_POST['card_number'];
  15. $year = $_POST['year'];
  16.  
  17. $sql = "INSERT INTO `cards`(`ID`, `first_name`, `last_name`, `deck`, `card_number`, `year`)
  18. VALUES ('','$first_name','$last_name','$deck', '$card_number','$year')";
  19.  
  20. mysql_select_db('baseball_cards');
  21. $query = mysql_query($sql, $conn);
  22.  
  23. if(!$query) {
  24. die('Could not enter data' . mysql_error());
  25. }
  26. echo "entered successfully";
  27.  
  28. mysql_close($conn);
  29. header('Location: cards.php')
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement