Advertisement
Guest User

Untitled

a guest
Sep 1st, 2017
371
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $dbname = "databasename";
  4. $username = "username";
  5. $password = "password";
  6.  
  7. try {
  8. $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  9. // set the PDO error mode to exception
  10. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  11. echo "Connected successfully :D";
  12. }
  13. catch(PDOException $e)
  14. {
  15. echo "Connection failed: " . $e->getMessage();
  16. }
  17. ?>
  18.  
  19. <!DOCTYPE html>
  20. <html>
  21. <head>
  22. <?php require 'db.php';
  23. $conn;
  24. $add1sql = "UPDATE supplies SET quantity = quantity + 1 WHERE Id=1";
  25. ?>
  26. <title>Homepage</title>
  27. <link rel="stylesheet" type="text/css" href="style/main.css">
  28. </head>
  29. <body>
  30. <h1>testpage</h1>
  31. <form method="POST" action="<?php exec($add1sql) ?>">
  32. <input type="submit" name="+1" value="+1"/>
  33. </form>
  34.  
  35. </body>
  36. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement