PHP/IIS to SQLServer connection issues

[Keyth]

I cannot believe this site is still going, how cool!

Can anybody help please. I would like to convert this code to use the sqlserver connection methods.

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$server = "localhost:1433";
$user_name = "sa";
$password = "??";
$database = "Quotes";

$link = mysqli_connect($server, $user_name,$password,$database);

if (!$link) {
    printf("Can't connect to localhost. Error: %s\n", mysqli_connect_error());
    exit();
}

if (isset($_GET['Action'])){
	//added bracket before isset
	if ($_GET['Action'] == 'approve'){
		verify_approve_decline(1);
	}
	else{
		verify_approve_decline(0);
	}
}

//removed public 
function verify_approve_decline($approve){
	
	$SQL1 = "UPDATE release_code SET 'approve'= ".$approve." , 'UID'= ".$_GET['Uid']." WHERE RELEASE_CODE = ".$_GET ['Id'];
	
	$result1 = mysqli_query($link,$SQL1);
	if($result1){
		if($approve == 1){
			echo "<h1>The decision has been approved.</h1>";
		} else {
			echo "<h1>The decision has been declined.<h1>";
		}
	}

}

?>

With the existing code, I get the following errors.


Warning: mysqli_connect(): MySQL server has gone away in D:\inetpub\Development\apps\process.php on line 11
Warning: mysqli_connect(): Error while reading greeting packet. PID=6900 in D:\inetpub\Development\apps\process.php on line 11
Warning: mysqli_connect(): (HY000/2006): MySQL server has gone away in D:\inetpub\Development\apps\process.php on line 11
Can't connect to localhost. Error: MySQL server has gone away

 

[vacunita]

Use the SQLSRV methods then:

http://php.net/manual/en/intro.sqlsrv.php

http://php.net/manual/en/function.sqlsrv-connect.php

----------------------------------
Phil AKA Vacunita
----------------------------------
OS-ception: Running Linux on a Virtual Machine in Windows which itself is running in a Virtual Machine on Mac OSx.

Web & Tech