Sql connection string from php test file

<?php

$dbname = 'database';
$server = 'something.com:3631';
$username = 'Neo';
$password = 'qwerty';

$sqlquery = "SELECT * FROM sometable ;";
//$sqlquery = "INSERT INTO sometable (fSite, Area, fColumn, Shelf, Item, Quantity) VALUES ('600','FA','8012','3','577300','200');";

$data = mssqlExec($sqlquery, $dbname, $server, $username, $password, $type=MSSQL_ASSOC);

print_r($data);



/**
* Generic Sybase connection to MS SQL using Linux box.
*
* @param int $type 	Can be MSSQL_ASSOC, MSSQL_NUM or MSSQL_BOTH These are constants (numbers) so do not put quotes around them.
* @param string $sqlquery 	the sql query, ensure no semicolon on the end and double quotes with backslashes for name with spaces
* @param string $dbname	name of the database
* @param string $server	name of the server it is hosted on
* @param string $username	username associated with the database
* @param string $password	passsword for that user
* @param global $db_error	contains relevant error message for debugging
*
* @returns array $results	Returns a mutildimensional array with rows an array of fields and values 
*				(row0=>(field0=>value0,field1=>value1),row1=>(field0=>value0,filed1=>value1))
*				
* EXAMPLE: mssqlExec("SELECT Field FROM Table", "PROD1", "sql2.network.com", "fred", "pass", MSSQL_BOTH);
*/
function mssqlExec($sqlquery, $dbname, $server, $username, $password, $type=MSSQL_ASSOC)
{
	global $db_error;
	$sqlconnect=mssql_connect($server,$username,$password);
	
	if (!$sqlconnect) {
		$db_error = "Could not Connect to $server"; 
		return FALSE;
	}
	
	$sqldb=mssql_select_db($dbname,$sqlconnect);
	$process=mssql_query($sqlquery);
	
	if(!$process) {
		$db_error = "Query did not return any results";
		return FALSE;
	}
	
	$chk = substr($sqlquery, 0, 6);
	if ($chk == 'SELECT') {
		while ($row=mssql_fetch_array($process,$type)) {
			foreach ($row as $colNum=>$value) {
				$trimmed[$colNum] = trim($value);
			}
			$results[]=$trimmed;
		}
	} else { 
		$results = TRUE; 
	}
	
	mssql_close($sqlconnect);
	return $results;
}
?>