INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

PHP/IIS to SQLServer connection issues

PHP/IIS to SQLServer connection issues

(OP)
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.

CODE

<?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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close