insert_department.php 436 B

123456789101112131415
  1. <?php
  2. include("./script/php/permission/connect_sql.php");
  3. include("./script/php/excel/read_excel.php");
  4. $data = $excelData["部門編號"];
  5. for ($i = 1; $i < count($data); $i++) {
  6. $sql = "INSERT INTO [dbo].[Department]
  7. ([DepartmentID]
  8. ,[DepartmentName]
  9. ,[Manager])
  10. VALUES
  11. (?,?,?)";
  12. $stmt = sqlsrv_query($conn, $sql, array($data[$i][0],$data[$i][1],$data[$i][0]));
  13. }