dejo el codigo para que lo puedan ver
Código PHP:
<?php
class SQLconnect
{
public $USER="fact1";
public $PASS="smujer";
public $SERVER="10.0.1.10";
public $PORT="1433";
public $DB="datos";
public $con=false;
function __construct($user="fact1",$pass="smujer",$server="10.0.1.10",$db="datos",$port="1433")
{
$this->new_conection($user,$pass,$server,$db,$port);
}
public function new_conection($user="fact1",$pass="smujer",$server="10.0.1.10",$db="datos",$port="1433"){
$this->DB=$db;
$this->PASS=$pass;
$this->USER=$user;
$this->SERVER=$server.$port;
$this->con = sqlsrv_connect( $this->SERVER, array( "Database"=>$this->DB, "UID"=>$this->USER, "PWD"=>$this->PASS));
if( $this->con === false ) {
die( print_r( sqlsrv_errors(), true));
}
}
public function query($q=""){
return sqlsrv_query($this->con,$q);
}
public function get_results($q){
return $this->sqlsrv_fetch_object($this->query($q));
}
}
?>