Questions tagged [php-mssql]

A PHP extension which allows you to access Microsoft SQL Server databases. It was available until PHP 5.3 (on Windows) and removed in PHP 7.0.0.

54 questions
0
votes
1 answer

How to get null value from stored procedure out parameter using php mssql?

I am using the following code to bind out parameter for stored procedure. mssql_bind($stmt, '@_SORef', $Ref, SQLVARCHAR, true); But, I am getting empty value instead of null as value of $Ref. How can I get null value from the out parameter?
anik_s
  • 243
  • 3
  • 18
0
votes
1 answer

mssql_execute causing Error code: ERR_EMPTY_RESPONSE

I am having an issue with a site that I am moving onto a new server. This site is connected to a SQL Server database, and is working correctly in it's current location. However, the new location is having problems with a single mssql_execute. …
BLenau
  • 95
  • 1
  • 4
  • 12
0
votes
1 answer

SQL Server Stored Procedure Call in PHP - Can't get xml data it returns back into php

Trying to call an SQL SERVER stored procedure from php. Think I've got it working but I can't get the data it returns back into php. I'm copying my php code and also the sample SQL SERVER code below. Believe my problem is how do get the data back…
Jason
  • 1,496
  • 4
  • 29
  • 41
0
votes
0 answers

MSSQL / PHP Stored procedure call and execute

I am trying to access a stored procedure, have it execute and using an html table to display the results. the code I have right now using PHP.net with an mssql_init and mssql_execute: ?php $month = $_POST['month']; $year = $_POST['year']; $dayfrm =…
DoCnTex
  • 113
  • 2
  • 5
  • 11
0
votes
1 answer

mssql_bind not working in heterogenous server

I have PHP on linux server and mssql 2005 on windows server, whenever i try to connect php with mssql , while executing stored procedure it give me error , my code is as below mssql_connect('DBSERVER', 'sa', 'password'); …
sumit
  • 15,003
  • 12
  • 69
  • 110
-1
votes
1 answer

sqlsrv_connect works fine in php but fails in laravel on the same server(AWS EC2 Instance)

I am trying to connect MSSQL database as my second database in Laravel, In the core PHP file It works fine but when I try to connect in the laravel It throws an error. Here is my…
Mahak Choudhary
  • 1,286
  • 1
  • 16
  • 13
-1
votes
2 answers

Problems with xampp

I can not recognize the SQL Server command in XAMPP 1.8.1 and PHP 5.4.7, this code had already used it and it worked before but now it doesn't. I have already tried to put the php_mssql.dll dll and still don't recognize the command: $con =…
-1
votes
1 answer

I am having an issue with PHP. I can query from MSSMS directly to the DB but my web pages all will not connect to the Server

I am having an issue with PHP. I can query from MSSMS directly to the DB but my web pages all will not connect to the Server.. SQL Server 2016 PHP version 5.2.4 Sample: $DatabaseServer = 'server'; $DatabaseUser = 'reader'; $DatabasePassword =…
kvngarner
  • 9
  • 3
-1
votes
1 answer

Difficulty in using SQLSERVER with PHP

I need to create a crud in PHP with the SQLSERVER database for a college job, connect the bank in PHP I got it, now execute no instructions, please help me, I am very difficult ..? my code
1 2 3
4