teratail
回答率
85.47%
質問するログイン新規登録
トップに関する質問prepareとquery

編集履歴

質問編集履歴

4

間違いの修正

2015/11/19 14:51

投稿

gyojin
gyojin

スコア94

test CHANGED
File without changes
test CHANGED
@@ -8,7 +8,7 @@
8
8
 
9
9
  //query版
10
10
 
11
- $string="SELECT * FROM ".$table." WHERE hashName = '".$searchName."' ;";
11
+ $string="SELECT * FROM ".$table." WHERE hashName = '".$searchName."' ";
12
12
 
13
13
  if( !($result=$mysqli->query($string)) ){
14
14
 
@@ -28,7 +28,7 @@
28
28
 
29
29
  //prepare版
30
30
 
31
- $string="SELECT * FROM ".$table." WHERE hashName = ? ;";
31
+ $string="SELECT * FROM ".$table." WHERE hashName = ? ";
32
32
 
33
33
  if( !($result=$mysqli->prepare($string)) ){
34
34
 

3

読みやすくする修正

2015/11/19 14:51

投稿

gyojin
gyojin

スコア94

test CHANGED
File without changes
test CHANGED
@@ -10,7 +10,7 @@
10
10
 
11
11
  $string="SELECT * FROM ".$table." WHERE hashName = '".$searchName."' ;";
12
12
 
13
- if( !($result=$this->mysqli->query($string)) ){
13
+ if( !($result=$mysqli->query($string)) ){
14
14
 
15
15
  $this->error="query error";
16
16
 
@@ -30,7 +30,7 @@
30
30
 
31
31
  $string="SELECT * FROM ".$table." WHERE hashName = ? ;";
32
32
 
33
- if( !($result=$this->mysqli->prepare($string)) ){
33
+ if( !($result=$mysqli->prepare($string)) ){
34
34
 
35
35
  $this->error="prepare error";
36
36
 

2

余分な部分の削除

2015/11/19 07:55

投稿

gyojin
gyojin

スコア94

test CHANGED
File without changes
test CHANGED
@@ -42,7 +42,7 @@
42
42
 
43
43
  if( !($result->execute()) ){
44
44
 
45
- $this->error="SELECT execute error:".$string;
45
+ $this->error="execute error:";
46
46
 
47
47
  return false;
48
48
 

1

読みやすくするためにリストの修正

2015/11/19 07:51

投稿

gyojin
gyojin

スコア94

test CHANGED
File without changes
test CHANGED
@@ -8,7 +8,7 @@
8
8
 
9
9
  //query版
10
10
 
11
- $string="SELECT * FROM ".$this->table." WHERE hashName = '".$searchName."' ;";
11
+ $string="SELECT * FROM ".$table." WHERE hashName = '".$searchName."' ;";
12
12
 
13
13
  if( !($result=$this->mysqli->query($string)) ){
14
14
 
@@ -28,7 +28,7 @@
28
28
 
29
29
  //prepare版
30
30
 
31
- $string="SELECT * FROM ".$this->table." WHERE hashName = ? ;";
31
+ $string="SELECT * FROM ".$table." WHERE hashName = ? ;";
32
32
 
33
33
  if( !($result=$this->mysqli->prepare($string)) ){
34
34