· 10 years ago · Sep 05, 2016, 04:44 PM
1<?php
2
3 ini_set('display_errors', '1');
4 error_reporting(E_ALL);
5
6 $DB_HOST = "localhost";
7 $DB_USER = "root";
8 $DB_PASS = "131";
9 $DB_NAME = "test";
10
11 $db = new mysqli($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
12
13 if ($db->connect_errno) {
14 printf("Ðе удалоÑÑŒ подключитÑÑ Ðº базе данных");
15 exit();
16 }
17
18 $result = $db->query("
19 CREATE TABLE IF NOT EXISTS test_table (
20 id INT AUTO_INCREMENT,
21 data TEXT,
22 PRIMARY KEY (id)
23 );
24 ");
25
26 if (!$result) {
27 printf("Ðе удалоÑÑŒ Ñоздать таблицу: %s", $db->error);
28 exit();
29 }
30
31 if (!empty($_REQUEST["data"])) {
32 $query = $db->prepare("
33 INSERT INTO test_table (id, data)
34 VALUES (1, ?)
35 ON DUPLICATE KEY
36 UPDATE id = 1, data = ?;
37 ");
38
39 $query->bind_param("ss", $_REQUEST["data"], $_REQUEST["data"]);
40
41 $result = $query->execute();
42
43 if (!$result) {
44 printf("Ðе удалоÑÑŒ отправить запроÑ: %s", $query->error);
45 }
46
47 $query->close();
48 }
49
50?>
51
52<!DOCTYPE html>
53<html lang="ru">
54 <head>
55 <meta charset="UTF-8">
56 <title>Document</title>
57 </head>
58 <body>
59
60 <form method="post">
61 <input type="text" name="data">
62 <button type="submit">
63 Send
64 </button>
65 </form>
66
67 <br>
68
69 <form action="." method="post">
70 <input type="hidden" name="get" value="true">
71 <button type="submit" href="#">
72 Get data
73 </button>
74 </form>
75 </body>
76
77 <p>
78 <?php
79 if (!empty($_REQUEST["get"])) {
80 $result = $db->query("
81 SELECT data
82 FROM test_table
83 WHERE id = 1;
84 ");
85
86 if (!$result) {
87 printf("Ðе удалоÑÑŒ получить данные: %s", $db->error);
88 exit();
89 }
90
91 while($row = $result->fetch_assoc()) {
92 printf($row["data"]);
93 }
94 }
95 ?>
96 </p>
97
98</html>
99
100<?php
101
102 $db->close();