<?php
error_reporting(E_ALL);
ini_set('error_reporting', E_ALL);

$sql_server = array(
	'username' => 'quz704',
	'password' => 'sqlserQuino2',
	'hostname' => 'lwdh631.servidoresdns.net',
	'dbname' => 'quz704',
	'dsn' => 'sers.es.sqlserver_test'
);
/*
$mssql_link = mssql_connect($sql_server['hostname'], $sql_server['username'], $sql_server['password']);
$m_res = mssql_query('select * from table_test');
while($rec = mssql_fetch_array($m_res, MSSQL_NUM)){
	echo "<pre>";
	print_r($rec);
	echo "</pre>";
}
*/


//sudo apt-get install freetds-bin freetds-common tdsodbc odbcinst php5-odbc unixodbc
try
{
  //$db = new PDO('odbc:DSN=sers.es.sqlserver_test; UID=quz704; PWD=sqlserQuino2;');
  //$db = new PDO("odbc:DSN=sers.es.sqlserver_test;dbname=quz704", "quz704", "sqlserQuino2");
  
  //$db = new PDO('odbc:Driver=FreeTDS; Server=lwdh631.servidoresdns.net; Port=1433; Database=quz704; UID=quz704; PWD=sqlserQuino2;');
  //$db = new PDO("dblib:host=lwdh631.servidoresdns.net;dbname=quz704", "quz704", "sqlserQuino2");
  //$db = new PDO("odbc:DRIVER=unixODBC;SERVER=lwdh631.servidoresdns.net;DATABASE=quz704;","quz704","sqlserQuino2");
  //$db = new PDO("odbc:DRIVER=FreeTDS;Server=lwdh631.servidoresdns.net;Database=quz704;","quz704","sqlserQuino2");
	$dbh = new PDO("dblib:host=lwdh631.servidoresdns.net;dbname=quz704", "quz704","sqlserQuino2");
	$sql = "select * from procedencia";
	$stmt = $dbh->query($sql);
	//$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
	while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
	    echo "<pre>";
		print_r($row);
		echo "</pre>";
	}

}catch(PDOException $exception){
  die("Unable to open database.<br />Error message:<br /><br />$exception.");
}