note 123970 added to function.sqlsrv-connect
| From: | Anonymous@php.net | Date: | Thu, 20 Jun 2019 18:38:37 +0000 |
| Subject: | note 123970 added to function.sqlsrv-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-211324@lists.php.net to get a copy of this message | ||
SQL SERVER 2012 conexion in PHP
<?php
$serverName = "SERVER"; //serverName\instanceName
$connectionInfo = array( "Database"=>"base",
"UID"=>"ex", "PWD"=>"******");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
;
if( $conn ) {
echo "Conexión establecida.<br />";
}else{
echo "Conexión no se pudo establecer.<br />";
die( print_r( sqlsrv_errors(), true));
}
$sql = "SELECT name FROM [base].[dbo].[table]";
$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);
?>
----
Server IP: 208.43.231.9
Probable Submitter: 82.199.157.34 (proxied: 2806:103e:22:ca0:5970:99ce:1f13:e7cc)
----
Manual Page -- http://php.net/manual/en/function.sqlsrv-connect.php
Edit -- https://master.php.net/note/edit/123970
Del: integrated -- https://master.php.net/note/delete/123970/integrated
Del: useless -- https://master.php.net/note/delete/123970/useless
Del: bad code -- https://master.php.net/note/delete/123970/bad+code
Del: spam -- https://master.php.net/note/delete/123970/spam
Del: non-english -- https://master.php.net/note/delete/123970/non-english
Del: in docs -- https://master.php.net/note/delete/123970/in+docs
Del: other reasons-- https://master.php.net/note/delete/123970
Reject -- https://master.php.net/note/reject/123970
Search -- https://master.php.net/manage/user-notes.php