PHP SQL Server : 500 Internal server error with specific query

Question

I'm working with PHP Version 5.4.45, my website and a SQL Server database hosted on Microsoft Azure.

At this moment I just have 2 tables:

users (ID [int PK], fname [vchar], lname [vchar]);
user_login (ID [int PK], userID [int], login [datetime]);

I had inserted data on SSMS just for tests.

On my website I run a query to give me a list of registered users and it returns all relevant information (2 rows).

When I run a query to return a list of users login that throws a 500 Internal server error.

When my 1st "echo" is the ID or userID, it returns ONE value and nothing more.
When my 1st "echo" is the login (datetime), it doesn't shows anything, and the next "echo" in code too.

With this I conclude that the error's on login column.

I've read that 'bog queries' could do this error (I only have 30 rows for each userID, 60 for my 2 users) but, for test, I limited my query to only 5 records.

The query that I'm trying at this moment works on SSMS.

I can't access to the PHP error log file.

<?php

    $userID = 1;
    $uid = "xxx";
    $pwd = "xxx";
    $serverName = "xxx";
    $connectionInfo = array( "Database"=>"Development", "UID"=>$uid, "PWD"=>$pwd);
    $conn = sqlsrv_connect( $serverName, $connectionInfo);

    if( $conn )
    {
        // echo "Connection established.\n";
    }
    else
    {
        echo "Connection could not be established.\n";
        die( print_r( sqlsrv_errors(), true));
    }

    $sql = "SELECT * FROM dbo.userLogin WHERE userID=1 AND ID BETWEEN 5 AND 10 ORDER BY ID ASC ";
    $stmt = sqlsrv_query( $conn, $sql);

    if( $stmt === false ) {
        die( print_r( sqlsrv_errors(), true));
    }

    while($sql = sqlsrv_fetch_array($stmt)) {
        $id         = $sql["ID"];
        $login      = $sql["login"];
        $num_row    = count($login);

        for ($i = 0; $i < $num_row; $i++) {
            echo "
                <p>$id</p>
                <p>$login</p>
                <p>$userID</p>
            ";
        }
    }
?>

Query working in SSMS

TiA!

"I can't acess to the PHP error log file.", then contact someone who can. The only way to debug a 500 error is to read the error log. — Oldskool
– Oldskool, Commented Apr 14, 2016 at 11:26
@Oldskool Thanks for the reply! My big problem was exactly that: can't acess the log file to know where was the problem. I made a little search and now I'm able to see the log file. 'Catchable fatal error: Object of class DateTime could not be converted to string in D:\home\site\wwwroot\teste.php on line 44' — Denis V
– Denis V, Commented Apr 14, 2016 at 11:43

gofr1 · Accepted Answer · 2016-04-14 11:42:42Z

1

Try this $sql = "SELECT ID, userID, CONVERT(nvarchar(50),[Login],120) as [Login] FROM dbo.userLogin WHERE userID=1 AND ID BETWEEN 5 AND 10 ORDER BY ID ASC ";

answered Apr 14, 2016 at 11:42

gofr1

16k11 gold badges47 silver badges56 bronze badges

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

4 Comments

Denis V Over a year ago

500 internal server error... such a random error. Thanks!

gofr1 Over a year ago

Once I started with PHP + MS SQL this was the second issue after installing PDO drivers :)

muhammedv Over a year ago

@DenisV gofr1 is right. Also, you can view this link if you want to understand more what was the problem: af-design.com/2010/03/13/…

gofr1 Over a year ago

@muhammedv thanks for valuable reply! Also you can use this stackoverflow.com/questions/26470041/…

Collectives™ on Stack Overflow

PHP SQL Server : 500 Internal server error with specific query

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related