<?php $conn=odbc_connect('firstsql','sa','krishan');
if (!$conn) { exit("Connection Failed: " . $conn); }
 
$rs=odbc_exec($conn,"SELECT name FROM Dept ");
    if (!$rs) {exit("Error in SQL");}
    //retreive data into array
    $data = array();
    $i=0;
    while( $row = odbc_fetch_array($rs) ) {
        $data[$i] = $row;
        $i++;
    } 
print(utf8_encode(json_encode($data)));






 odbc_close($conn);

?>