Since a few weeks I'm using textbased logfile PHP Web Stat on my site, and very satisfied with it.

Today I wanted to try the SQL based option, but I failed to login to my SQL database, probably due to a different syntax needed for the Express version.

Is PHP Web Stat v20 compatible with Microsoft's free SQL version SQL Express?

Hi there,

normally it shall not be a problem using a different SQL server software due to using SQL standard language syntax. But: it could by problem that we developed all functions requiring MySQL. So the real difference is only the function for the database connection itself, not the SQL queries.

We therefore used the function:
https://www.php.net/manual/en/function.mysqli-connect.php

And Microsoft SQL express needs this function:
https://www.php.net/manual/en/function.sqlsrv-connect.php

Currently, we are not able to change this due to missing test areas.
But if you are familiar with PHP, try for yourself. The desired file is db_connect.php.

Thx
Reimar

Thanks for your reply.

You confirm my thoughts about MySQL/SQL Express.

I'm not good at PHP programming, so I'll stay with the text file based version.


Best regards,
Derk