Advertisement
Guest User

Untitled

a guest
Mar 1st, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. $servername = "localhost";
  2. $username = "root";
  3. $password = "pass";
  4. $dbname = "db";
  5.  
  6. try {
  7. $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  8. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  9. $stmt = $conn->prepare("SELECT * FROM Notes");
  10. $stmt->execute();
  11.  
  12. $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
  13.  
  14. if(isset($_POST["szoveg"])){
  15. $query = "INSERT INTO Notes ('id', 'reg_date', 'szoveg') VALUES (NULL, CURDATE(), '".$_POST["szoveg"]."')";
  16.  
  17. $stmt = $conn->prepare($query);
  18. $stmt->execute();
  19.  
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement