List websites running a specific PHP version

Discussion in 'General' started by topogigio, Sep 25, 2023.

  1. topogigio

    topogigio Member

    I cannot find a way to get a list of all websites running a specific PHP version, not in GUI or accessing the DB (I'm sure that it will exist some field but I cannot find it).

    How can I perform this?
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    There is no simple way through the GUI, but you can check in the database which PHP versions have which ID and then check the list of websites with their php version ID's.
    ahrasis likes this.
  3. topogigio

    topogigio Member

    I was looking for something similar, but I cannot find the field. In websites table I can find a string field with only "php-fpm" value and I cannot find the other field that has the ID of the PHP version...
  4. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter


    which you'll need to cross reference with the 'server_php_id' and 'name' fields in the server_php table.
  5. topogigio

    topogigio Member

    got it, thank you!

    full query for who need it:

    SELECT domain, web_domain.server_php_id, FROM web_domain
    INNER JOIN server_php ON server_php.server_php_id = web_domain.server_php_id
    till, madmucho, ahrasis and 1 other person like this.

Share This Page