001.<meta http-equiv=Content-Type content="text/html; charset=utf-8">
002.<?php
003.$conn = mysqli_connect("localhost","root","root","disdata");
004.mysqli_set_charset($conn, "utf8");
005.require_once('vendor/php-excel-reader/excel_reader2.php');
006.require_once('vendor/SpreadsheetReader.php');
007.
008.if (isset($_POST["import"]))
009.{
010.
011.
012. $allowedFileType = ['application/vnd.ms-excel','text/xls','text/xlsx','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'];
013.
014. if(in_array($_FILES["file"]["type"],$allowedFileType)){
015.
016. $targetPath = 'uploads/'.$_FILES['file']['name'];
017. move_uploaded_file($_FILES['file']['tmp_name'], $targetPath);
018.
019. $Reader = new SpreadsheetReader($targetPath);
020.
021. $sheetCount = count($Reader->sheets());
022. for($i=0;$i<$sheetCount;$i++)
023. {
024. $Reader->ChangeSheet($i);
025.
026. foreach ($Reader as $Row)
027. {
028.
029. $member_key = "";
030. if(isset($Row[0])) {
031. $member_key = mysqli_real_escape_string($conn,$Row[0]);
032. }
033.
034. $member_code = "";
035. if(isset($Row[1])) {
036. $member_code = mysqli_real_escape_string($conn,$Row[1]);
037. }
038.
039. $member_prefix = "";
040. if(isset($Row[2])) {
041. $member_prefix = mysqli_real_escape_string($conn,$Row[2]);
042. }
043.
044. $member_name = "";
045. if(isset($Row[3])) {
046. $member_name = mysqli_real_escape_string($conn,$Row[3]);
047. }
048.
049. $member_lastname = "";
050. if(isset($Row[4])) {
051. $member_lastname = mysqli_real_escape_string($conn,$Row[4]);
052. }
053.
054. $member_prefix_en = "";
055. if(isset($Row[5])) {
056. $member_prefix_en = mysqli_real_escape_string($conn,$Row[5]);
057. }
058.
059. $member_name_en = "";
060. if(isset($Row[6])) {
061. $member_prefix_en = mysqli_real_escape_string($conn,$Row[6]);
062. }
063.
064. $member_lastname_en = "";
065. if(isset($Row[7])) {
066. $member_prefix_en = mysqli_real_escape_string($conn,$Row[7]);
067. }
068. if (!empty($member_key) || !empty($member_code)) {
069. $query = "insert into member (member_key,member_code,member_prefix,member_name,member_lastname,member_prefix_en,member_name_en,member_lastname_en) values('".md5(addslashes($member_key))."','".$member_code."','".$member_prefix."','".$member_name."','".$member_lastname."','".$member_prefix_en."','".$member_name_en."','".$member_lastname_en."')";
070. $result = mysqli_query($conn, $query);
071.
072.
073. if (! empty($result)) {
074. $type = "success";
075. $message = "นำเข้าข้อมูลจาก EXCEL เรียบร้อยแล้ว";
076. } else {
077. $type = "error";
078. $message = "ไม่สามารถนำเข้าข้อมูลจาก Excel ได้ โปรลองอีกครั้ง";
079. }
080. }
081. }
082.
083. }
084. }
085. else
086. {
087. $type = "error";
088. $message = "ประเภทไฟล์ไม่ถูกต้อง กรุณาอัพโหลดไฟล์ Excel (XLS และ XLSX)";
089. }
090.}
091.?>
092.
093.<!DOCTYPE html>
094.<html>
095.<head>
096.<style>
097.body {
098. font-family: Arial;
099. width: 550px;
100.}
101.
102..outer-container {
103. background: #F0F0F0;
104. border: #e0dfdf 1px solid;
105. padding: 40px 20px;
106. border-radius: 2px;
107.}
108.
109..btn-submit {
110. background: #333;
111. border: #1d1d1d 1px solid;
112. border-radius: 2px;
113. color: #f0f0f0;
114. cursor: pointer;
115. padding: 5px 20px;
116. font-size:0.9em;
117.}
118.
119..tutorial-table {
120. margin-top: 40px;
121. font-size: 0.8em;
122. border-collapse: collapse;
123. width: 100%;
124.}
125.
126..tutorial-table th {
127. background: #f0f0f0;
128. border-bottom: 1px solid #dddddd;
129. padding: 8px;
130. text-align: left;
131.}
132.
133..tutorial-table td {
134. background: #FFF;
135. border-bottom: 1px solid #dddddd;
136. padding: 8px;
137. text-align: left;
138.}
139.
140.#response {
141. padding: 10px;
142. margin-top: 10px;
143. border-radius: 2px;
144. display:none;
145.}
146.
147..success {
148. background: #c7efd9;
149. border: #bbe2cd 1px solid;
150.}
151.
152..error {
153. background: #fbcfcf;
154. border: #f3c6c7 1px solid;
155.}
156.
157.div#response.display-block {
158. display: block;
159.}
160.</style>
161.</head>
162.
163.<body>
164. <h2>ระบบนำเข้าข้อมูลจาก EXCEL</h2>
165.
166. <div class="outer-container">
167. <form action="" method="post"
168. name="frmExcelImport" id="frmExcelImport" enctype="multipart/form-data">
169. <div>
170. <label>เลือกไฟล์ Excel</label> <input type="file" name="file"
171. id="file" accept=".xls,.xlsx">
172. <button type="submit" id="submit" name="import"
173. class="btn-submit">นำเข้าข้อมูล</button>
174.
175. </div>
176.
177. </form>
178.
179. </div>
180. <div id="response" class="<?php if(!empty($type)) { echo $type . " display-block"; } ?>"><?php if(!empty($message)) { echo $message; } ?></div>
181.
182.
183.<?php
184. $sqlSelect = "SELECT * FROM tbl_info";
185. $result = mysqli_query($conn, $sqlSelect);
186.
187.if (mysqli_num_rows($result) > 0)
188.{
189.?>
190.
191. <table class='tutorial-table'>
192. <thead>
193. <tr>
194. <th>Name</th>
195. <th>Description</th>
196.
197. </tr>
198. </thead>
199.<?php
200. while ($row = mysqli_fetch_array($result)) {
201.?>
202. <tbody>
203. <tr>
204. <td><?php echo $row['name']; ?></td>
205. <td><?php echo $row['description']; ?></td>
206. </tr>
207.<?php
208. }
209.?>
210. </tbody>
211. </table>
212.<?php
213.}
214.?>
215.
216.</body>
217.</html>
