Guest User

Untitled

a guest
Dec 8th, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. <?php
  2.  
  3. $host = "localhost";
  4.  
  5. $username = "root";
  6.  
  7. $password = "";
  8.  
  9. $database = "database_name";
  10.  
  11. $table = "table_name";
  12.  
  13.  
  14. mysql_connect($host, $username, $password) or die();
  15.  
  16. $selectDB = mysql_select_db($database);
  17.  
  18. $selectTable = mysql_query("SELECT * FROM `" . $table . "`")
  19.  
  20.  
  21. if (!isset($_POST['send'])) { ?>
  22.  
  23. <form method="post">
  24.  
  25. First Name: <input type="text" value="" name="firstname" /><br />
  26.  
  27. Last Name: <input type="text" value="" name="lastname" /><br />
  28.  
  29. Age: <input type="text" value="" name="age" /><br />
  30.  
  31. <input type="submit" value="Submit" name="send" />
  32.  
  33. </form>
  34.  
  35. <? } else {
  36.  
  37. if (!$selectDB) {
  38.  
  39. echo "The database does not exist!";
  40.  
  41. } elseif(!$selectTable) {
  42.  
  43. mysql_query("CREATE TABLE `" . $table . "` (firstname varchar(25), lastname varchar(25), age int");
  44.  
  45. echo "Table not present... creating. Please press back and try again.";
  46.  
  47. } else {
  48.  
  49. $firstname = $_POST['firstname'];
  50.  
  51. $lastname = $_POST['lastname'];
  52.  
  53. $age = $_POST['age'];
  54.  
  55. mysql_query("INSERT INTO `" . $table . "` (firstname, lastname, age) VALUES(" . $firstname . ", " . $lastname . ", " . $age . ")");
  56.  
  57. echo "Successfully inserted data!";
  58.  
  59. }
  60.  
  61. }
  62.  
  63. ?>
Add Comment
Please, Sign In to add comment