SSYT

Sabin cod

May 10th, 2020
347
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.16 KB | None | 0 0
  1. // html form
  2. <form action="post.php" method="post">
  3.     Text: <input type="text" name="data1" />
  4.     Text: <input type="text" name="data2" />
  5.     Text: <input type="text" name="data3" />
  6.     Text: <input type="text" name="data4" />
  7.     <input type="button" name="submit" value="Submit">
  8. </form>
  9.  
  10.  
  11. // db.php content
  12. $link = mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db");
  13.  
  14. // post.php
  15. require 'db.php';
  16. require 'sendpost.php';
  17.  
  18. if(isset($_POST['submit'])) {
  19.     insertToDatabase([
  20.         'data1' => $_POST['data1'],
  21.         'data2' => $_POST['data2'],
  22.         'data3' => $_POST['data3'],
  23.         'data4' => $_POST['data4'],
  24.     ]);
  25. }
  26.  
  27. // sendpost.php
  28. require 'db.php';
  29.  
  30. function insertToDatabase(array $postData) {
  31.     global $link;
  32.     if(!empty($postData) && is_array($postData) ) return false;
  33.     $stmp = mysqli_query($link, 'INSERT INTO `table.name` (`data1`, `data2`, `data3`, `data4`) VALUES ($postData['data1'], $postData['data2'], $postData['data3'], $postData['data4'])');
  34.     mysqli_close($link);
  35.     endif;
  36. }
  37.  
  38. // getdata.php
  39. require 'db.php';
  40. $result = mysqli_query($link, "SELECT * FROM `table.name`");
  41. print_r($result); // return [0 => [0 => '', 1 => '', 2 => '', 3 => '']]
Add Comment
Please, Sign In to add comment