質問編集履歴
1
変数の名称変更
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -35,7 +35,7 @@
|
|
|
35
35
|
|
|
36
36
|
```ここに言語名を入力
|
|
37
37
|
router.get('/authed/ths_home',async function (req, res, next) {
|
|
38
|
-
let
|
|
38
|
+
let page_count = 0
|
|
39
39
|
let pageCount=null
|
|
40
40
|
let search_word = null;
|
|
41
41
|
|
|
@@ -51,14 +51,14 @@
|
|
|
51
51
|
|
|
52
52
|
```ここに言語名を入力
|
|
53
53
|
router.get('/authed/ths_home',async function (req, res, next) {
|
|
54
|
-
let
|
|
54
|
+
let page_count = 0
|
|
55
55
|
let pageCount=null
|
|
56
56
|
let search_word = null;
|
|
57
57
|
|
|
58
58
|
if(req.query.search_word){
|
|
59
59
|
search_word = req.query.search_word;
|
|
60
60
|
//動いた時と、ここが違う↓
|
|
61
|
-
|
|
61
|
+
pageCount = await client.query("SELECT * FROM ths_data_table WHERE sentence LIKE '%$1%' ORDER BY table_id DESC OFFSET 10*$2;",[search_word,page_count]);
|
|
62
62
|
}
|
|
63
63
|
});
|
|
64
64
|
```
|