質問編集履歴
2
エラー文が出なくなりました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -52,11 +52,11 @@
|
|
|
52
52
|
|
|
53
53
|
|
|
54
54
|
|
|
55
|
-
$dsn = 'mysql:host=
|
|
55
|
+
$dsn = 'mysql:host=○○○';'dbname=○○○;charset=utf8';
|
|
56
|
-
|
|
56
|
+
|
|
57
|
-
$user = '
|
|
57
|
+
$user = '○○○';
|
|
58
|
-
|
|
58
|
+
|
|
59
|
-
$password = '
|
|
59
|
+
$password = '○○○';
|
|
60
60
|
|
|
61
61
|
|
|
62
62
|
|
1
エラーが出なくなりました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -4,7 +4,7 @@
|
|
|
4
4
|
|
|
5
5
|
「Warning: PDOStatement::bindValue() expects at most 3 parameters, 5 given in /○○○/○○○/○○○/○○○/○○○/search.php on line 28」と
|
|
6
6
|
|
|
7
|
-
「Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in /○○○/○○○/○○○/○○○/○○○/search.php on line 30」と「検索失敗しました。」と出てきます
|
|
7
|
+
「Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in /○○○/○○○/○○○/○○○/○○○/search.php on line 30」というエラーは色々調べた結果出なくなったのですが「検索失敗しました。」と出てきます
|
|
8
8
|
|
|
9
9
|
教えてくださったら助かります
|
|
10
10
|
|
|
@@ -52,11 +52,11 @@
|
|
|
52
52
|
|
|
53
53
|
|
|
54
54
|
|
|
55
|
-
$dsn = 'mysql:
|
|
55
|
+
$dsn = 'mysql:host=mysql1.php.xdomain.ne.jp';'dbname=tchi_dbb;charset=utf8';
|
|
56
|
-
|
|
56
|
+
|
|
57
|
-
$user = '
|
|
57
|
+
$user = 'tchi_db';
|
|
58
|
-
|
|
58
|
+
|
|
59
|
-
$password = '
|
|
59
|
+
$password = 'moehaii1';
|
|
60
60
|
|
|
61
61
|
|
|
62
62
|
|
|
@@ -64,7 +64,7 @@
|
|
|
64
64
|
|
|
65
65
|
$dbh = new PDO($dsn, $user, $password);
|
|
66
66
|
|
|
67
|
-
$statement = $dbh->prepare("SELECT * FROM hito where name
|
|
67
|
+
$statement = $dbh->prepare("SELECT * FROM hito where name LIKE (:name) and tel LIKE (:tel)");
|
|
68
68
|
|
|
69
69
|
|
|
70
70
|
|
|
@@ -76,34 +76,34 @@
|
|
|
76
76
|
|
|
77
77
|
//プレースホルダへ実際の値を設定する
|
|
78
78
|
|
|
79
|
-
$statement->bindValue(':name',
|
|
79
|
+
$statement->bindValue(':name', $like_yourname, PDO::PARAM_STR);
|
|
80
|
+
|
|
81
|
+
$statement->bindValue(':tel', $like_yourname, PDO::PARAM_STR);
|
|
82
|
+
|
|
83
|
+
if($statement->execute()){
|
|
84
|
+
|
|
85
|
+
//レコード件数取得
|
|
86
|
+
|
|
87
|
+
$row_count = $statement->rowCount();
|
|
88
|
+
|
|
89
|
+
|
|
90
|
+
|
|
91
|
+
while($row = $statement->fetch()){
|
|
92
|
+
|
|
93
|
+
$rows[] = $row;
|
|
94
|
+
|
|
95
|
+
}
|
|
96
|
+
|
|
97
|
+
|
|
98
|
+
|
|
99
|
+
}else{
|
|
100
|
+
|
|
101
|
+
$errors['error'] = "検索失敗しました。";
|
|
102
|
+
|
|
103
|
+
}
|
|
80
104
|
|
|
81
105
|
|
|
82
106
|
|
|
83
|
-
if($statement->execute()){
|
|
84
|
-
|
|
85
|
-
//レコード件数取得
|
|
86
|
-
|
|
87
|
-
$row_count = $statement->rowCount();
|
|
88
|
-
|
|
89
|
-
|
|
90
|
-
|
|
91
|
-
while($row = $statement->fetch()){
|
|
92
|
-
|
|
93
|
-
$rows[] = $row;
|
|
94
|
-
|
|
95
|
-
}
|
|
96
|
-
|
|
97
|
-
|
|
98
|
-
|
|
99
|
-
}else{
|
|
100
|
-
|
|
101
|
-
$errors['error'] = "検索失敗しました。";
|
|
102
|
-
|
|
103
|
-
}
|
|
104
|
-
|
|
105
|
-
|
|
106
|
-
|
|
107
107
|
//データベース接続切断
|
|
108
108
|
|
|
109
109
|
$dbh = null;
|
|
@@ -156,7 +156,7 @@
|
|
|
156
156
|
|
|
157
157
|
<table border='1'>
|
|
158
158
|
|
|
159
|
-
<tr><td>名前</td><td>
|
|
159
|
+
<tr><td>名前</td><td>性別</td></tr>
|
|
160
160
|
|
|
161
161
|
|
|
162
162
|
|