Advertisement
Guest User

insertintable

a guest
Jan 9th, 2019
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.85 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $dbname = "scuola";
  6. $tabname = "studenti";
  7. $nome = $_POST['nome'];
  8. $cognome= $_POST['cognome'];
  9. $matricola= $_POST['matricola'];
  10. $classe= $_POST['classe'];
  11. $ddn= $_POST['ddn'];
  12. try {
  13.     $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  14.     // set the PDO error mode to exception
  15.     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  16.     $sql = "INSERT INTO $tabname (nome, cognome, matricola, classe, ddn)
  17.    VALUES ('$nome', '$cognome', '$matricola', '$classe', '$ddn')";
  18.     // use exec() because no results are returned
  19.     $conn->exec($sql);
  20.     echo "New record created successfully";
  21.     }
  22. catch(PDOException $e)
  23.     {
  24.     echo $sql . "<br>" . $e->getMessage();
  25.     }
  26. header("Location: creaStudenti.html");
  27. $conn = null;
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement