回答率: 85.35%

質問するログイン新規登録

トップに関する質問 phpでのページングが上手くいかない

編集履歴

質問編集履歴

1

文法の訂正

2021/07/01 16:05

投稿

スコア1

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -213,3 +213,235 @@
 ```
 よろしくお願いいたします。
+追加情報
+直した部分
+queryを使わずにprepareで準備してからexecuteで実行した。
+$_POSTではなく$_GETを利用するようにした。
+ソースコード
+```html
+<!DOCTYPE html>
+<html lang="ja">
+<head>
+  <meta charset="utf-8">
+  <title>PHP TEST</title>
+</head>
+<body>
+<form action="testphp.php" method="get">
+  検索ワード：<input type="text" name="word" />
+  <input type="submit" />
+</form>
+</body>
+</html>
+```
+```php
+<?php
+define('max_view',10);
+$word = $_GET["word"];
+$servername = "localhost";
+$username = "shizutaro";
+$password = "         ";
+$dbname = "CSexp1DB";
+$port = "80";
+// Create connection
+$conn = new mysqli($servername, $username, $password,$dbname,$port);
+// Check connection
+if ($conn->connect_error) {
+  die("Connection failed: " . $conn->connect_error);
+}
+$word = htmlspecialchars($word);
+if(is_numeric($word)){
+  $result = $conn->prepare("SELECT * FROM zipShizuoka WHERE zip like  '%" .?. "%' ");
+  $result->bind_param('s',$word);
+  $result->execute();
+}else{
+$result = $conn->prepare("SELECT * FROM zipShizuoka WHERE CONCAT(kana1,kana2,kana3,addr1,addr2,addr3) like '%" .?. "%'");
+$result->bind_param('s',$word);
+$result->execute();
+}
+printf("%d",$result->affected_rows);
+$total_count = $result->affected_rows;
+$pages = ceil($total_count / max_view);
+if(!isset($_GET['page_id'])){
+     $now = 1;
+ }else{
+     $now = $_GET['page_id'];
+ }
+ if(is_numeric($word)){
+   if($now == 1){
+   $result1 = $conn->prepare("SELECT * FROM zipShizuoka WHERE zip like  '%" .?. "%'  LIMIT 0,10");
+   $result1->bind_param('s',$word);
+   $result1->execute();
+ }else{
+   $result1 = $conn->prepare("SELECT * FROM zipShizuoka WHERE zip like  '%" .?. "%' LIMIT ?,10");
+   $start = ($now-1)*10;
+   $result1->bind_param('si',$word,$start);
+   $result1->execute();
+ }
+ }else{
+if($now == 1){
+ $result1 = $conn->prepare("SELECT * FROM zipShizuoka WHERE CONCAT(kana1,kana2,kana3,addr1,addr2,addr3) like '%" .?. "%'LIMIT 0,10 ");
+ $result1->bind_param('s',$word);
+ $result1->execute();
+}else {
+ $result1 = $conn->prepare("SELECT * FROM zipShizuoka WHERE CONCAT(kana1,kana2,kana3,addr1,addr2,addr3) like '%" .?. "%'LIMIT ?,10");
+ $result1->bind_param('si',$word,$start);
+ $result1->execute();
+}
+ }
+  echo "<br>";
+foreach($result1 as $row){
+  echo $row['zip'] . '' .$row['addr1'] . '' .$row['addr2'] . '' .$row['addr3'];
+  echo "<br>";
+}
+for ( $n = 1; $n <= $pages; $n ++){
+    if ( $n == $now ){
+        echo "<span style='padding: 5px;'>$now</span>";
+    }else{
+        echo "<a href='./testphp.php?page_id=$n&word=",urldecode($_GET["word"]),"' style='padding: 5px;'>$n</a>";
+    }
+}
+$conn = $conn->close($conn);
+?>
+</body>
+</html>
+```