) private $tempResultObj = '';// Almacena el resultado del Objeto Recientemente creado via el método execute() private $error=""; //----------------Métodos Públicos--------------------// public function DBManager() { if(!empty($user))$this->user=$user; if(!empty($pass))$this->pass=$pass; //$connectionInfo = array("Database"=>"BDESCALAFON","UID"=>"ArturoCode","PWD"=>"ArturoCode***2026"); $connectionInfo = array("Database"=>"BDSITT","UID"=>"ArturoCode","PWD"=>"ArturoCode***2026"); try{ $this->connectionID=sqlsrv_connect($this->host,$connectionInfo);//$conn = sqlsrv_connect('GVILLAFANA',$connectionInfo); //if(!$this->connectionInfo) throw new Exception(mssql_min_error_severity()); if($this->connectionID){ ;//echo('Conectado'); }else{ echo('No se pudo conectar...
'); die( print_r( sqlsrv_errors(), true)); } } catch(Exception $e) { echo "A ocurrido un error: ".$e->getMessage(); exit();//termina la ejecucion del script } } public function execute($sql) { $connectionInfo = array("Database"=>$this->db, "UID"=>$this->user, "PWD"=>$this->pass); // $this->connectionID=sqlsrv_connect($serverName,$connectionInfo); $conn = sqlsrv_connect($this->host, $connectionInfo); $options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET ); // $this->queryID = sqlsrv_query(/*$this->connectionID*/$conn,$sql,array(2)); $queryID = sqlsrv_query($conn,$sql,array(),$options); $this->tempResultObj = new Recordset($queryID);//Inicializa un objeto sin considerar si la consulta retorna algun resultado o no. return $this->tempResultObj; } //funcion ADHOC utilizada con INSERT, UPDATE, DELETE public function _execute($sql)//devuelve falso si la consulta tuvo exito { $resp=false; $this->queryID = @sqlsrv_query($this->connectionID,$sql); //Inicializa un objeto sin considerar si la consulta retorna algun resultado o no. if($this->queryID) $resp=true; return $resp; } public function ejecutar($sql="") { $params = array(2); $options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET ); $this->queryID = @sqlsrv_query($this->connectionID,$sql,$params,$options); return $this->queryID; } public function getConnection() { return $this->connectionID;} public function closeConnection(){ sqlsrv_close($this->connectionID);} } ?>