Php sql server connect

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

Database connection in php

<?php

$hostName = 'localhost';
$userNmame = 'root';
$password = '';
$dbname = 'topproduct';
$db_name = "mysql:host=$hostName;dbname=$dbname";
$conn = new PDO($db_name,$userNmame,$password);

if(!$conn){
    echo 'Error database connection';    
}

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

191 votes351 views1 answer
Php pdo error handling
PHP
11 votes137 views5 answers
PHP array sum
PHP
15 votes152 views2 answers
Laravel/ui v3.0.0 requires php ^7.3 -> your php version (8.0.2) does not satisfy that requirement.
PHP
3 votes141 views3 answers
Php keep only numbers in string
PHP
1 vote124 views1 answer
Php curl Content-Length
PHP
0 vote147 views1 answer
Move post to draft php wordpress
PHP Wordpress
4 votes154 views2 answers
Laravel hash::check
PHP Laravel
0 vote175 views1 answer
Laravel - Comparison betweeon two column values - whereColumn
PHP Laravel
0 vote136 views1 answer
Return last inserted id mysql opencart
PHP
0 vote185 views1 answer
Maximum upload file size: 2 MB. how to increase in softaculous
PHP