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