Jump to content

mssql connection Call to undefined mssql_connect()


newphpcoder

Recommended Posts

Actually, now I only test my webpage in a computer that I create as a server. And also I’m not too familiar in a server.  Now I created a database in SQL Server 2005 Express and some of information I will share is:

 

I also used:

SQL Server 2005 Express

IIS 6.0

php 5.2.14

 

Server Type: Database Engine

Server name: ComputerName\SQLEXPRESS

Authentication: Windows Authentication

Username: NETBIOS NAME\Administrator [hide]

Password:  [hide]

 

My problem is I cannot connect to my database using php and I don't know what username and password I should use if the Username: NETBIOS NAME\Administrator Password:  [no password]

 

This is my php code:

<?php
//session_start(); 
//session_regenerate_id(); 

//if($_SESSION['loggedin']){ 
//the user is already logged in, lets redirect them to the other page 
  //  header("Location:company.php"); 
//} 


$server = "Computer Name\SQLEXPRESS";
$user = "NETBIOS\Administrator";
$pass = "";
$db_name="dbase"; 

//connection to database
$dbhandle = mssql_connect($server, $user, $pass) or die ("Cannot connect to Server");

//mssql_connect($server, 'sa', 'pass') or die("Cannot connect to server"); 
$selected = mssql_select_db($db_name, $dbhandle)or die("Cannot select DB");    


        $department = $_POST['department'];    
        $username = $_POST['username']; 

        $sql=mssql_query("SELECT `Department`, `Username` FROM `tbl_user` WHERE `Department` = '{$department}' AND Username = '{$username}'") or die(mssql_min_error_severity()); 
        $ct = mssql_num_rows($sql); 
      
        if($ct == 1) { 
// im guessing this means that the user is valid. 
$_SESSION['loggedin'] = true; // now that the user is valid we change the session value. 
            $row = mssql_fetch_assoc($sql);   

		//$_SESSION['username'] = $row['Username'] ;
		//$_SESSION['department'] = $row['Department'];

		$Departments=array('Accounting', 'Engineering', 'Finishing_Goods', 'HRAD', 'MIS', 'Packaging_and_Design', 'Production', 'Purchasing_Logistic', 'QA_and_Technical', 'Supply_Chain');

		if (in_array($row['Department'], $Departments)){
				header ('Location:company.php');
		}else{
				echo "Incorrect Username or Department";
				header ('Location:index.php');
		}
	}
?> 

 

I don't know if what configuration i need to do to work my connection. I configured php.ini like:

 

I uncommented the following:

 

extension_dir = "C:\php\ext"

extension=php_sqlsrv_52_ts_vc6.dll

extension=php_bz2.dll

extension=php_curl.dll

extension=php_dba.dll

extension=php_exif.dll

extension=php_gd2.dll

extension=php_gettext.dll

 

mssql.allow_persistent=On

mssql.max_persistent=-1

mssql_max_links=-1

mssql.min_error_severity=10

mssql.compatibility_mode=Off

mssql.connect_timeout=5

mssql.timeout=60

mssql.textlimit=4096

mssql.textsize=4096

mssql.batchsize=0

mssql.datetimeconvert=On

mssql.secure_connetion=Off

 

FreeTDS default to 4096

mssql.max_procs=25

mssql.charset = "ISO-8859-1"

 

After I commented out that in php.ini, I put all sqlsrv file in C:\php\ext and the ntwdlib.dll into C:\WINDOWS\system32. After that still when I run my webpage the error is still there. I have no idea how I can fix that error.

 

 

Error:

Fatal error: call to undefined function mssql_connect() in C:\Inetpub\wwwroot\web_intranet\index.php on line 17

 

I hope somebody can help or tell me what I should do.

Thank you

 

 

Link to comment
Share on other sites

It looks to me like you have the sqlsrv extension enabled, but you are calling functions that are defined in the mssql extension. These are different PHP extensions for connecting to SQL Server. These blog posts should help you understand the differences (and write code that will work with the sqlsrv extension):

 

http://blogs.msdn.com/b/brian_swan/...nce-part-1.aspx

 

http://blogs.msdn.com/b/brian_swan/...nce-part-2.aspx

 

If those links still don't help, please post with further questions.

 

Hope that helps.

 

-Brian

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.