Willkommen Gast. Bitte Einloggen oder Registrieren
 
Sprache wählen:
 
 
Statistik Version 20 online.

  ÜbersichtHilfeSuchenEinloggenRegistrieren  
 
Seitenindex umschalten Seiten: 1
Thema versenden Drucken
SQL Express and v20 (Gelesen: 294 mal)
De Hout
YaBB Newbies
*
Offline



Beiträge: 9
Alkmaar, Netherlands
Geschlecht: male
SQL Express and v20
21.01.24 um 15:26:08
 
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?
Zum Seitenanfang
 
Homepage  
IP gespeichert
 
Reimar
Administrator
*****
Offline



Beiträge: 1982
Geschlecht: male
Re: SQL Express and v20
Antwort #1 - 22.01.24 um 20:26:00
 
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
Zum Seitenanfang
 
 
IP gespeichert
 
De Hout
YaBB Newbies
*
Offline



Beiträge: 9
Alkmaar, Netherlands
Geschlecht: male
Re: SQL Express and v20
Antwort #2 - 22.01.24 um 22:17:21
 
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
Zum Seitenanfang
 
Homepage  
IP gespeichert
 
Seitenindex umschalten Seiten: 1
Thema versenden Drucken