Php - Call to undefined function mssql_query()

Question

I have used the following php code to show the number of rows from sql table but I am getting below error message.

Fatal error: Call to undefined function mssql_query()
             in D:\wamp\www\thereport24\gp.php
             on line 22

my code:

$conn = odbc_connect('gpcon','',''); 
if ($conn)
    {
    $query= "select * from SubscriberServices where SubscriptionGroupID like 'ms_gp_tr24bn_3333'";
    $results = mssql_query($query);
    $rows    = mssql_fetch_array($results);
    echo $rows[0];
    mssql_close($con); 
}

check if extension=php_mssql.dll is uncommented in your php.ini and mssql installed on your machine — bigbobr
– bigbobr, Commented Nov 8, 2014 at 12:18
@bigbobr , check if extension=php_mssql.dll ...it is done ...mssql already installed...but i m getting same error... — Sazal Ahmed
– Sazal Ahmed, Commented Nov 8, 2014 at 14:06
@Max...i have follow it ...but facing same problem...what is it real solution.. — Sazal Ahmed
– Sazal Ahmed, Commented Nov 8, 2014 at 18:41
Have you restarted Apache/PHP? Can you call php_info() and see if the right extensions are indeed loaded? — GolezTrol
– GolezTrol, Commented Nov 8, 2014 at 21:00

Tunaki · Accepted Answer · 2016-04-27 18:06:06Z

0

If you use sql server, use this code. This works for me:

<?php
    $serverName = "serverName"; 
    $options = array(  "UID" => "sa",  "PWD" => "Password",  "Database" => "DBname");
    $conn = sqlsrv_connect($serverName, $options);

    if( $conn ) {
         echo "Connection established.<br />";

         $query="select * from SubscriberServices where SubscriptionGroupID like 'ms_gp_tr24bn_3333'";
         $result = sqlsrv_query($conn,$query);
         sqlsrv_close($conn);


    }else{
         echo "Connection could not be established.<br />";
         die( print_r( sqlsrv_errors(), true));
    }

?>

if it returns "Connection established." it's mean you install MS SQL Drivers correct.

edited Apr 27, 2016 at 18:06

Tunaki

138k46 gold badges370 silver badges443 bronze badges

answered Apr 27, 2016 at 17:39

Ali

4693 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Php - Call to undefined function mssql_query()

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related