<?php
/**
* mssqlconn.inc.php : Base Configuration File for the MS-SQL Conection
*
* PHP version 5
*
* LICENSE: This source file is subject to version 3.01 of the PHP license
* that is available through the world-wide-web at the following URI:
* http://www.php.net/license/3_01.txt. If you did not receive a copy of
* the PHP License and are unable to obtain it through the web, please
* send a note to license@php.net so we can mail you a copy immediately.
*
* @author Aquiles dos Santos Crespo <aquilescrespo@gmail.com>
* @copyright 2011-2013 DjinnSoftWorks (DSW)
* @license http://www.php.net/license/3_01.txt PHP License 3.01
*/
/*
* Verify the php_mssql libary is installed and enabled.
* Stops script if mssql functions are missing
*/
if(!function_exists('mssql_connect')){
die("You must have the php_mssql library for Apache (win) or httpd "
. "(Linux) installed and enabled to connect to an MSSQL database. "
. "php.ini or configure your Linux Web Server to enable this extension. "
. "This requires a restart of the Apache/httpd service to take effect.");
}
/*
* Title : mssql_escape_string
*
* Description :
* MSSQL Escape Function is an SQL Injection Prevention values from the $non_dispayebles array variable
* of passing to your query's
* Non Dispayables :
* => url encoded 00-08, 11, 12, 14, 15
* => url encoded 16-31
* => 00-08
* => 11
* => 12
* => 14-31
*
* Author : CodeIgniter by Rick Ellis
* Remake : Aquiles dos Santos Crespo
*/
function mssql_escape_string($data) {
if(!isset($data) or empty($data)){return '';}
if(\is_numeric($data)){return $data;}
$non_displayables = array('/%0[0-8bcef]/','/%1[0-9a-f]/','/[\x00-\x08]/','/\x0b/','/\x0c/','/[\x0e-\x1f]/');
foreach($non_displayables as $regex){$data = \preg_replace($regex,'',$data);}
$data = \str_replace("'","''",$data);
return $data;
}
// Database configuration parameters
$db_host = 'Address Here';
$db_user = 'DB Login Here';
$db_pass = 'DataBase Password Here';
// Connect to MSSQL server
$conn = \mssql_connect($db_host,$db_user,$db_pass) or die('Failed to connect to MSSQL Server, in the MSSQL DB conf File.');
