質問編集履歴
3
現状のキャプチャ追記、テーブル作成時のSQL文追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -107,3 +107,25 @@
|
|
|
107
107
|
?>
|
|
108
108
|
|
|
109
109
|
```
|
|
110
|
+
|
|
111
|
+
追記 2018/08/02
|
|
112
|
+
|
|
113
|
+
上記修正後の実行結果
|
|
114
|
+
|
|
115
|
+
|
|
116
|
+
|
|
117
|
+
|
|
118
|
+
|
|
119
|
+
テーブル作成時のSQL文
|
|
120
|
+
|
|
121
|
+
```SQl
|
|
122
|
+
|
|
123
|
+
CREATE TABLE EXCEL_DLL(DIVISION varchar(2), IMAGE_NM varbinary(max),VERSION varchar(10),UPDATE_DT datetime)
|
|
124
|
+
|
|
125
|
+
INSERT INTO EXCEL_DLL(DIVISION,IMAGE_NM,VERSION,UPDATE_DT)
|
|
126
|
+
|
|
127
|
+
SELECT '1',img.BulkColumn,'1.0',sysdatetime()
|
|
128
|
+
|
|
129
|
+
FROM (SELECT * FROM OPENROWSET(BULK N'C:\Test.xlsm',SINGLE_BLOB) AS i ) img
|
|
130
|
+
|
|
131
|
+
```
|
2
コード修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -92,7 +92,7 @@
|
|
|
92
92
|
|
|
93
93
|
//file_get_contents($row['IMAGE_NM']);
|
|
94
94
|
|
|
95
|
-
echo $row['
|
|
95
|
+
echo $row['IMAGE_NM'];
|
|
96
96
|
|
|
97
97
|
|
|
98
98
|
|
1
コードの修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -86,7 +86,13 @@
|
|
|
86
86
|
|
|
87
87
|
header('Content-Disposition: attachment; filename="'.$filename.'"');
|
|
88
88
|
|
|
89
|
+
|
|
90
|
+
|
|
91
|
+
//2018-08-02 14:10 修正
|
|
92
|
+
|
|
89
|
-
file_get_contents($row['IMAGE_NM']);
|
|
93
|
+
//file_get_contents($row['IMAGE_NM']);
|
|
94
|
+
|
|
95
|
+
echo $row['FILE_NM'];
|
|
90
96
|
|
|
91
97
|
|
|
92
98
|
|