get_project_list.php 543 B

1234567891011121314151617181920
  1. <?php
  2. include("sql.php");
  3. $array = [];
  4. $connectionInfo = array("Database" => "$dbname", "UID" => "$username", "PWD" => "$password", "CharacterSet" => "UTF-8");
  5. $conn = sqlsrv_connect($hostname, $connectionInfo);
  6. if ($conn === false) {
  7. die(print_r(sqlsrv_errors(), true));
  8. }
  9. $sql = "SELECT DISTINCT * FROM [21000X].[dbo].[Project_Table];";
  10. $fetchResult = sqlsrv_query($conn, $sql);
  11. while ($row = sqlsrv_fetch_array($fetchResult, SQLSRV_FETCH_ASSOC)) {
  12. array_push($array ,$row);
  13. }
  14. echo json_encode($array,JSON_UNESCAPED_UNICODE);
  15. ?>