質問編集履歴
1
エラー及びコードの修正。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -28,7 +28,7 @@
|
|
|
28
28
|
|
|
29
29
|
|
|
30
30
|
|
|
31
|
-
Fatal error: Uncaught PDOException: SQLSTATE[HY0
|
|
31
|
+
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'price' at row 1 in /Applications/MAMP/htdocs/product/pro_add_done.php:25 Stack trace: #0 /Applications/MAMP/htdocs/product/pro_add_done.php(25): PDOStatement->execute(Array) #1 {main} thrown in /Applications/MAMP/htdocs/product/pro_add_done.php on line 25
|
|
32
32
|
|
|
33
33
|
```
|
|
34
34
|
|
|
@@ -78,7 +78,9 @@
|
|
|
78
78
|
|
|
79
79
|
$dbh -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
80
80
|
|
|
81
|
-
$sql='INSERT INTO mst_product(name,price) VALUES (?
|
|
81
|
+
$sql='INSERT INTO mst_product(name,price) VALUES ```(?.?)';
|
|
82
|
+
|
|
83
|
+
```*
|
|
82
84
|
|
|
83
85
|
$stmt=$dbh->prepare($sql);
|
|
84
86
|
|