Connect php in sql server

Php connect ms sql server

<?php
$serverName = "serverName\\sqlexpress"; //serverName\instanceName

// Since UID and PWD are not specified in the $connectionInfo array,
// The connection will be attempted using Windows Authentication.
$connectionInfo = array( "Database"=>"dbName");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>

Source: php.net

Connect php in sql server

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);
?>

Source: php.net

Php sql server connect

$serverName = "serverName\sqlexpress"; //serverName\instanceName
$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

-1

Similar codes

1 vote315 views1 answer
Laravel queue work schedule cpanel
PHP Laravel
0 vote320 views1 answer
Php get long word in array
PHP
1 vote356 views1 answer
Get user with role laravel
PHP Laravel
4 votes352 views4 answers
Laravel current timestamp
PHP
0 vote327 views1 answer
Woocommerce set default shipping country
PHP
0 vote349 views1 answer
Login with email or username codeigniter 4
PHP CodeIgniter
44 votes285 views3 answers
Php trim string to length
PHP
19 votes282 views3 answers
Root composer.json requires php ^7.2.5 but your php version (8.0.3) does not satisfy that require
PHP
1 vote320 views1 answer
Php curl verbose
PHP
0 vote407 views2 answers
Search post by post title in wordpres
PHP