1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| <?php
class MSSQL {
private $co;
// Méthodes principales
public function sql_connect($server, $database, $login, $password) {
// pour fonction sqlsrv_connect()
//$serverName = "serverName\sqlexpress"; //serverName\instanceName
//$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$serverName = "P71P12DMD5U\CARTO";
$login="carto";
$password="Carto";
$database="ApplicationNationale1";
$connectionInfo = array("Database" => $database,"UID" => $login, "PWD" => $password);
//$conn = sqlsrv_connect($server, $connectionInfo);
try {
/*
$conn = mssql_pconnect($server, $login,$password);
mssql_connect("localhost");
mssql_select_db('ApplicationNationale1');
mssql_select_db($conn,$database);
$row = mssql_query('select * from Technicentre', $conn);
echo $row;
*/
$conn = sqlsrv_connect($serverName, $connectionInfo);
if($conn) {
echo "Connexion établie.<br />";
}else{
echo "La connexion n'a pu être établie.<br />";
die( print_r( sqlsrv_errors(), true));
}
} catch (Exception $e) {
echo 'Exception reçue : ',' $e->getMessage(), "\n";
} |
Partager