get_log.php 1.2 KB

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. //if (isset($_GET['project_id'])) {
  3. include("sql.php");
  4. $ajax = [];
  5. $connectionInfo = array("Database" => "$dbname", "UID" => "$username", "PWD" => "$password", "CharacterSet" => "UTF-8");
  6. $conn = sqlsrv_connect($hostname, $connectionInfo);
  7. if ($conn === false) {
  8. die(print_r(sqlsrv_errors(), true));
  9. }
  10. $sql = "SELECT [Import_Log].[UserID],[UserName],[DepartmentName],[Import_Log].[project_id],[project_name],[upload_time] FROM [21000X].[dbo].[Import_Log]
  11. JOIN [dbo].[user] ON [user].[UserID] = [21000X].[dbo].[Import_Log].[UserID]
  12. JOIN [21000X].[dbo].[Project_Table] ON [Project_Table].[project_id] = [Import_Log].[project_id]
  13. JOIN [permissions].[dbo].[Department] ON [user].[DepartmentID] = [Department].[DepartmentID]";
  14. $stmt = sqlsrv_query($conn, $sql);
  15. while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
  16. $temp = array();
  17. $temp["UserID"] = $row["UserID"];
  18. $temp["UserName"] = $row["UserName"];
  19. $temp["DepartmentName"] = $row["DepartmentName"];
  20. $temp["project_id"] = $row["project_id"];
  21. $temp["project_name"] = $row["project_name"];
  22. $temp["upload_time"] = array($row["upload_time"]);
  23. array_push($ajax, $temp);
  24. }
  25. echo json_encode($ajax, JSON_UNESCAPED_UNICODE);
  26. //}