-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmssql_overwrite.php
56 lines (46 loc) · 1.27 KB
/
mssql_overwrite.php
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
44
45
46
47
48
49
50
51
52
53
54
55
56
<?php
function mssql_connect($db_server, $db_user, $db_pass) {
global $link,$db_server,$db_user,$db_pass;
$connectionOptions = array(
"Database" => "xx",
"Uid" => $db_user,
"PWD" => $db_pass,
"TraceOn"=>"0",
"CharacterSet" =>"UTF-8",
"ConnectionPooling" => "1",
'MultipleActiveResultSets'=>false
);
//Establishes the connection
$link = sqlsrv_connect($db_server, $connectionOptions);
if( $link === false ) {
}else{
return $link;
}
}
function mssql_select_db($db_database, $link){
return true;
}
function mssql_query($query, $link = 0){
global $db_server,$db_user,$db_pass,$link;
if($link == 0){
$link = mssql_connect($db_server, $db_user, $db_pass);
}
$r = sqlsrv_query($link, $query,array(), array( "Scrollable" => 'buffered' ));
return $r;
}
function mssql_num_rows($r){
//return number of rows
return sqlsrv_num_rows($r);
}
function mssql_fetch_object($r){
//return objects
return sqlsrv_fetch_object($r);
}
function mssql_close(){
return true;
}
function mssql_fetch_array($r){
//return array
return sqlsrv_fetch_array($r);
}
?>