Fatal error: Call to undefined function mssql_fetch_array() in C:\xampp\htdocs\myFolder\exceltest.php on line 25

Question

I am trying to export data from MSSQL table to Excel. Below is my code. Problem is that i am getting the following error:

    Fatal error: Call to undefined function mssql_fetch_array() in C:xampp\code.php on line 25

I am running Windows Server 2008 R2, IIS7, SQL Server 2008, PHP Version 5.4.4.

I have un-commented the line: "extension=php_mssql.dll" found in C:\xampp\php\php.ini

    <?php
// load library
require 'include\php-excel.class.php';

$i = 0; // used as a counter

$myServer = "SERVERNAME\SQLEXPRESS";
$myUser = "UserName";
$myPass = "xxxxxx";
$myDB = "dbName";

$conn = new COM ("ADODB.Connection") or die("Cannot start ADO");

$connStr = "PROVIDER=SQLOLEDB;SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB;
$conn->open($connStr); //Open the connection to the database

$result = "SELECT Col1, Col2, Col3 FROM myTable WHERE Col3='myCondition'";

//$rs = $conn->execute($result);
//$num_columns = $rs->Fields->Count();

    // create data array and print headers on the first row
    $data = array(1 => array ('No.', 'Col1', 'Col2', 'Col3'));

    while($row=mssql_fetch_array($result)) {
//include additional rows
array_push($data, array($i, $row['Col1'], $row['Col2'], $row['Col3']));
$i++;
}

// If no results, indicate this on the first row
if ($i == 0){
$data = array(1 => array ('No results', 'empty', 'empty', 'empty'));
                        }

//generate file (constructor parameters are optional)
$xls = new Excel_XML('UTF-8', false, 'My Test Sheet');
$xls->addArray($data);
$xls->generateXML('MyReport');
    ?>

Thank you in advance.

Did you verify that it was the correct ini file, and restart IIS after enabling the module? (Check for it in phpinfo()'s output — Chris Trahey
– Chris Trahey, Commented Aug 14, 2012 at 14:15
@ctrahey is correct. Run phpinfo() and see if the MS SQL functions are enabled. — GoofyX
– GoofyX, Commented Aug 14, 2012 at 14:32
Loaded Configuration File: C:\xampp\php\php.ini and that is where i edited/un-commented the "extension=php_mssql.dll" file then restarted webserver. — user1533724
– user1533724, Commented Aug 14, 2012 at 14:38

Gavin Burke · Accepted Answer · 2012-08-16 12:48:13Z

1

PHP5.3 onwards doesn't support the mssql functions. If you check your PHP ext folder, you will find there isn't a php_mssql.dll no more

answered Aug 16, 2012 at 12:48

Gavin Burke

1491 gold badge2 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SDC · Accepted Answer · 2012-08-16 13:08:52Z

1

You're using an ADODB COM to create your DB connection. This isn't the same thing as using the mssql_xx library.

You can't mix and match between the two - they're not compatible.

In any case, you clearly don't have the mssql_xx library installed (I'm not even sure it's supported any more), so you can't use that.

Right above your failing call to mssql_fetch_array(), you have some commented out lines:

//$rs = $conn->execute($result);
//$num_columns = $rs->Fields->Count();

Not sure why you've commented these out, because you'll need them, or something like them. Particularly the first of those lines. And after that, you'd need to use the ADODB equivalent to mssql_fetch_array() to read the records in the loop.

However, my advice is to ditch all of this, and switch to using the PDO library instead. PDO supports the MS SQL database, and is standard PHP, unlike the ADODB stuff you're trying to use here.

See the PHP manual for the PDO library here: http://php.net/manual/en/book.pdo.php

answered Aug 16, 2012 at 13:08

SDC

14.2k2 gold badges38 silver badges49 bronze badges

1 Comment

Dung Over a year ago

Thanks @SDC very much, very important note for everyone that you have to Pay attention on what Library you use to create your DB connection in my case Ubuntu 16.04 PHP7 MSSQL server and I use FreeTDS which use PDO JUST as SDC mentioned here Hence I need to use the right support function for it.

GoofyX · Accepted Answer · 2012-08-14 14:15:44Z

0

After uncommenting the line for MS SQL library, have you restarted the web server for the change to take effect?

answered Aug 14, 2012 at 14:15

GoofyX

1,1791 gold badge16 silver badges37 bronze badges

1 Comment

Chris Trahey Over a year ago

These should be comments on the question (and the info bout a restart not fixing it should be an edit to the question)

Pradeep Kumar · Accepted Answer · 2017-07-19 13:37:20Z

0

For sql, we can use sqlsrv_fetch_array with sqlsrv_query as:

$sql_query = "SELECT Col1, Col2, Col3 FROM myTable WHERE Col3='myCondition'";
$result = sqlsrv_query($conn,$sql_query);
while( $row = sqlsrv_fetch_array( $result, SQLSRV_FETCH_ASSOC) ) {
        echo $row['Col1'];
        /*etc codes here*/
}

answered Jul 19, 2017 at 13:37

Pradeep Kumar

4,1712 gold badges36 silver badges41 bronze badges

Collectives™ on Stack Overflow

Fatal error: Call to undefined function mssql_fetch_array() in C:\xampp\htdocs\myFolder\exceltest.php on line 25

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related