Advertisement
Guest User

Untitled

a guest
Oct 3rd, 2018
198
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.54 KB | None | 0 0
  1.  <?php
  2.  if(isset($_POST['extract']))
  3.  {
  4. $servername = "***";
  5. $username = "***";
  6. $password = "***";
  7. $dbname = "***";
  8. $tekst=$_POST['extract'];
  9. try {
  10.     $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  11.     // set the PDO error mode to exception
  12.     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  13.  
  14.     // prepare sql and bind parameters
  15.     $stmt = $conn->prepare("INSERT INTO history (id, name, message, data)
  16.    VALUES (NULL, :name, :message, :data)");
  17.     $stmt->bindParam(':name', $name);
  18.     $stmt->bindParam(':message', $message);
  19.     $stmt->bindParam(':data', $data);
  20.  
  21.     $name = "Name";
  22.     $message = $_POST['extract'];
  23.     $data = "2018-08-08";
  24.     $stmt->execute();
  25.  
  26.     echo "New records created successfully";
  27.     }
  28. catch(PDOException $e)
  29.     {
  30.     echo "Error: " . $e->getMessage();
  31.     }
  32. $conn = null;
  33. }
  34. ?>
  35.  
  36. <!DOCTYPE html>
  37. <html>
  38. <head>
  39.     <meta charset="utf-8">
  40.     <link rel="stylesheet" type="text/css" href="style.css">
  41.     <link href="https://fonts.googleapis.com/css?family=Roboto+Condensed" rel="stylesheet">
  42.     <title>Test</title>
  43.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  44. </head>
  45. <body>
  46. <div class="chatDiv">
  47.     <div class="chat" id="chatBox">
  48.     </div>
  49.         <form name="textBoxForm" method="POST">
  50.                 <textarea name="extract" id="textBox1"></textarea>
  51.                 <input name="submit" type="submit" class="show" onclick="show()" value="Wyślij" id="btn">
  52.         </form>
  53. </div>
  54. <script type="text/javascript" src="main.js"></script>
  55. </body>
  56. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement