File manager - Edit - /home/autoph/public_html/voc/home/MSSQL_Connect.php
Back
<?php $serverName = "172.16.1.126"; //serverName\instanceName $connectionInfo = array( "Database"=>"HRIS_TEST", "UID"=>"jb", "PWD"=>"rse@122877"); $conn = sqlsrv_connect( $serverName, $connectionInfo); ; if( $conn ) { echo "Connection Failed.<br />"; }else{ echo "Connection Error.<br />"; die( print_r( sqlsrv_errors(), true)); } $sql = "SELECT last_name FROM HRIS_TEST.dbo.employeelist"; $params = array(); $options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET ); $stmt = sqlsrv_query( $conn, $sql , $params, $options ); $row_count = sqlsrv_num_rows( $stmt ); if ($row_count === false) echo "Error al obtener datos."; else echo "bien"; //echo $row_count; while( $row = sqlsrv_fetch_array( $stmt) ) { print json_encode($row); } sqlsrv_close($conn); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings