| 1234567891011121314151617181920 |
- <?php
- include("sql.php");
- $array = [];
- $connectionInfo = array("Database" => "$dbname", "UID" => "$username", "PWD" => "$password", "CharacterSet" => "UTF-8");
- $conn = sqlsrv_connect($hostname, $connectionInfo);
- if ($conn === false) {
- die(print_r(sqlsrv_errors(), true));
- }
- $sql = "SELECT DISTINCT * FROM [21000X].[dbo].[Project_Table];";
- $fetchResult = sqlsrv_query($conn, $sql);
- while ($row = sqlsrv_fetch_array($fetchResult, SQLSRV_FETCH_ASSOC)) {
- array_push($array ,$row);
- }
- echo json_encode($array,JSON_UNESCAPED_UNICODE);
- ?>
|