質問編集履歴

3

追記

2017/06/01 14:05

投稿

ryo-dev
ryo-dev

スコア437

test CHANGED
File without changes
test CHANGED
@@ -141,3 +141,55 @@
141
141
  Fatal error: Uncaught Error: Call to undefined method PDOStatement::findUser() in /Users/hasegawaryou/Dropbox/alpha/lib/Model/User.php:89 Stack trace: #0 /Users/hasegawaryou/Dropbox/alpha/public/Admin/User_Data/index.php(59): MyApp\Model\User->findUser(Array) #1 {main} thrown in /Users/hasegawaryou/Dropbox/alpha/lib/Model/User.php on line 89
142
142
 
143
143
  ```
144
+
145
+ ###追記です。現状報告
146
+
147
+ ```php
148
+
149
+ try {
150
+
151
+ $userModel = new \MyApp\Model\User();
152
+
153
+ $user = $userModel->findUser([
154
+
155
+ 'number' => $Get_Id
156
+
157
+ ]);
158
+
159
+
160
+
161
+ } catch (\MyApp\Exception\UnmatchUserData $e) {
162
+
163
+ $this->setErrors('Get_User', $e->getMessage());
164
+
165
+ return;
166
+
167
+ }
168
+
169
+
170
+
171
+
172
+
173
+ // 引数で指定されたユーザのデータを返す
174
+
175
+ public function findUser($values) {
176
+
177
+ $stmt = $this->db->prepare("select * from users where anumber = ?");
178
+
179
+ $stmt->execute([$values['number']]);
180
+
181
+ $row=$stmt->fetch(PDO::FETCH_ASSOC);
182
+
183
+ return $row;
184
+
185
+ }
186
+
187
+ ```
188
+
189
+ ```text
190
+
191
+ Fatal error: Uncaught Error: Class 'MyApp\Model\PDO' not found in /Users/hasegawaryou/Dropbox/alpha/lib/Model/User.php:86 Stack trace: #0 /Users/hasegawaryou/Dropbox/alpha/public/Admin/User_Data/index.php(59): MyApp\Model\User->findUser(Array) #1 {main} thrown in /Users/hasegawaryou/Dropbox/alpha/lib/Model/User.php on line 86
192
+
193
+ ```
194
+
195
+ yambejp さんの返答を元に書き直したコードです。

2

訂正

2017/06/01 14:05

投稿

ryo-dev
ryo-dev

スコア437

test CHANGED
File without changes
test CHANGED
@@ -138,6 +138,6 @@
138
138
 
139
139
  ```text
140
140
 
141
- Fatal error: Uncaught Error: Call to a member function execute() on boolean in /Users/hasegawaryou/Dropbox/alpha/lib/Model/User.php:85 Stack trace: #0 /Users/hasegawaryou/Dropbox/alpha/public/Admin/User_Data/index.php(59): MyApp\Model\User->findUser(Array) #1 {main} thrown in /Users/hasegawaryou/Dropbox/alpha/lib/Model/User.php on line 85
141
+ Fatal error: Uncaught Error: Call to undefined method PDOStatement::findUser() in /Users/hasegawaryou/Dropbox/alpha/lib/Model/User.php:89 Stack trace: #0 /Users/hasegawaryou/Dropbox/alpha/public/Admin/User_Data/index.php(59): MyApp\Model\User->findUser(Array) #1 {main} thrown in /Users/hasegawaryou/Dropbox/alpha/lib/Model/User.php on line 89
142
142
 
143
143
  ```

1

訂正

2017/06/01 12:50

投稿

ryo-dev
ryo-dev

スコア437

test CHANGED
File without changes
test CHANGED
@@ -114,7 +114,7 @@
114
114
 
115
115
  public function findUser($values) {
116
116
 
117
- $stmt = $this->db->query("select * from users order by anumber = :number");
117
+ $stmt = this->db->prepare("select * from users where anumber = :number");
118
118
 
119
119
  $stmt->execute([
120
120