sqlsrv_query() Error

willscarlet · November 27, 2012, 3:13pm

Hello everyone, I seem to be having trouble with a login script. The script was origionally writtin for MySQL, now I am attempting to use it on SQL Server 2008 DB instead. Any advice would be greatly appreciated. On attempting to login I get the following error:

Warning: mysql_query(): [2002] No connection could be made because the target machine actively refused it. (trying to connect via tcp://localhost:3306) in C:\Inetpub\wwwroot\msag\login\core\functions\users.php on line 68 Warning: mysql_query(): No connection could be made because the target machine actively refused it. in C:\Inetpub\wwwroot\msag\login\core\functions\users.php on line 68 Warning: mysql_query(): A link to the server could not be established in C:\Inetpub\wwwroot\msag\login\core\functions\users.php on line 68 Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\Inetpub\wwwroot\msag\login\core\functions\users.php on line 68

My script is:

[php]<?php
function update_user($update_data) {
global $session_user_id;
$update = array();
array_walk($update_data, ‘array_sanitize’);

foreach ($update_data as $field => $data) {
	$update[] = '`' . $field . '` = \'' . $data . '\'';
}

mysql_query("UPDATE users SET " . implode (', ', $update) . "WHERE user_id = $session_user_id") or die (mysql_error());

}

function activate($email, $email_code) {
$email = mysql_real_escape_string($email);
$email_code = mysql_real_escape_string($email_code);

if (mysql_result(mysql_query("SELECT COUNT(user_id) FROM users WHERE email = '$email' AND email_code = '$email_code' AND active = 0"), 0) == 1) {
	mysql_error(); mysql_query("UPDATE users SET active = 1 WHERE email = '$email'");
	return true;
} else {
	return false;	
}

}

function change_password($user_id, $password) {
$user_id = (int) $user_id;
$password = md5($password);

mysql_query ("UPDATE users SET password = '$password' WHERE user_id = $user_id");

}
function register_user($register_data) {
array_walk($register_data, ‘array_sanitize’);
$register_data[‘password’] = md5($register_data[‘password’]);

$fields = '`' . implode('`, `', array_keys ($register_data)) . '`';
$data = '\'' . implode('\', \'', $register_data) . '\'';

mysql_query("INSERT INTO users ($fields) VALUES ($data)");
email($register_data['email'], 'Activate your account', "Hello " . $register_data['first_name'] . ", \n\nYou need to activate your account, please us the link below:\n\nhttp://www.sumterpd.com/login/activate.php?email=" . $register_data['email'] . "&email_code=" . $register_data['email_code'] .  "\n\n  -Sumterpd.com");

}

function user_count() {
return mysql_result(mysql_query(“SELECT COUNT(user_id) FROM users WHERE active = 1”), 0);
}

function user_data($user_id) {
$data = array();
$user_id = (int) $user_id;

$func_num_args = func_num_args();
$func_get_args = func_get_args();

if ($func_num_args > 1) {
	unset($func_get_args[0]);
	
	$fields = '`' . implode('`, `', $func_get_args) . '`' ;
	$data = mysql_fetch_assoc(mysql_query("SELECT $fields FROM users WHERE user_id = '$user_id' "));
	
	return $data;
}

}

function logged_in() {
return (isset($_SESSION[‘user_id’])) ? true : false;
}

function user_exists($username){ $username = sanitize($username); return (mysql_result(mysql_query(“SELECT COUNT(user_id) FROM users WHERE username = ‘$username’”), 0) == 1) ? true : false;
}

function email_exists($email){ $email = sanitize($email); return (mysql_result(mysql_query(“SELECT COUNT(user_id) FROM users WHERE email = ‘$email’”), 0) == 1) ? true : false;
}

function user_active($username){ $username = sanitize($username); return (mysql_result(mysql_query("SELECT COUNT(user_id) FROM users WHERE username = ‘$username’ AND active = 1 "), 0) == 1) ? true : false;
}

function user_id_from_username($username) {
$username = sanitize($username);
return mysql_result(mysql_query(“SELECT user_id FROM users WHERE username = ‘$username’”), 0, ‘user_id’);
}

function login($username, $password) {
$user_id = user_id_from_username($username);

$username = sanitize($username);
$password = md5($password);

return (mysql_result(mysql_query("SELECT COUNT(user_id) FROM users WHERE username = '$username' AND password = '$password'"), 0) == 1) ? $user_id : false;

}
?>[/php]