PhpDev.App
thorsten/phpMyFAQ

thorsten/phpMyFAQ

Stars: 564

Forks: 257

Pull Requests: 891

Issues: 1750

Watchers: 37

Last Updated: 2023-09-16 16:18:13

#faq #phpmyfaq #php #mysql #database #postgresql #sqlite #mssql #elasticsearch #docker #docker-compose #mariadb

phpMyFAQ - Open Source FAQ web application for PHP 8.1+ and MySQL, PostgreSQL and other databases

License: Mozilla Public License 2.0

Languages: JavaScript, PHP, HTML, Shell, Dockerfile, SCSS, Twig

https://www.phpmyfaq.de

phpMyFAQ 3.3

Packagist PHP Version Support GitHub GitHub commit activity Documentation Status

What is phpMyFAQ?

phpMyFAQ is a multilingual, completely database-driven FAQ-system. It supports various databases to store all data, PHP 8.1+ is needed in order to access this data. phpMyFAQ also offers a multi-language Content Management System with a WYSIWYG editor and a media manager, real time search support with Elasticsearch, flexible multi-user support with user and group based permissions on categories and records, a wiki-like revision feature, a news system, user-tracking, 40+ supported languages, enhanced automatic content negotiation, HTML5/CSS3 based responsive templates, PDF-support, a backup and restore system, a dynamic sitemap, related FAQs, tagging, enhanced SEO features, built-in spam protection systems, Microsoft/Azure Active Directory and OpenLDAP support, and an easy-to-use installation and update script.

Requirements

phpMyFAQ is only supported on PHP 8.1 and up, you need a database as well. Supported databases are MySQL, MariaDB, Percona Server, PostgreSQL, Microsoft SQL Server and SQLite3. If you want to use Elasticsearch as main search engine, you need Elasticsearch 6.x or later. Check our detailed requirements on phpmyfaq.de for more information.

Installation

phpMyFAQ installation package for end-users

The best way to install phpMyFAQ is to download it on phpmyfaq.de, unzip the package and open http://www.example.org/phpmyfaq/setup/index.php in your preferred browser.

phpMyFAQ installation with Docker

Dockerfile

The Dockerfile provided in this repo only builds an environment to run any release for development purpose. It does not contain any code as the phpmyfaq folder is meant to be mounted as the /var/www/html folder in the container.

docker-compose.yml

For development purposes you can start a full stack to run your current PhpMyFAQ source code from your local repo.

$ docker-compose up

The command above starts eight containers for multi database development as following.

Specific images started once to prepare the project:

  • composer: update composer dependencies
  • pnpm: update pnpm dependencies

Running using named volumes:

  • mariadb: image with MariaDB database with xtrabackup support
  • phpmyadmin: a PHP tool to have a look on your MariaDB database.
  • postgres: image with PostgreSQL database
  • pgadmin: a PHP tool to have a look on your PostgreSQL database.
  • sqlserver: image with Microsoft SQL Server for Linux
  • elasticsearch: Open Source Software image (it means it does not have XPack installed)

Running apache web server with PHP 8.3 support:

  • phpmyfaq: mounts the phpmyfaq folder in place of /var/www/html.

Then services will be available at following addresses:

Running tests

To run the test using Docker you have to install the Composer development dependencies

$ curl -s https://getcomposer.org/installer | php
$ php composer.phar install

Quote from ElasticSearch documentation

The vm.max_map_count kernel setting needs to be set to at least 262144 for production use. Depending on your platform:

Linux

The vm.max*map_count setting should be set permanently in */etc/sysctl.conf_:

$ grep vm.max_map_count /etc/sysctl.conf
vm.max_map_count=262144

To apply the setting on a live system type: sysctl -w vm.max_map_count=262144

macOS with Docker for Mac

The vm.max_map_count setting must be set within the xhyve virtual machine:

$ screen ~/Library/Containers/com.docker.docker/Data/com.docker.driver.amd64-linux/tty

Log in with root and no password. Then configure the sysctl setting as you would for Linux:

$ sysctl -w vm.max_map_count=262144
Windows and macOS with Docker Toolbox

The vm.max_map_count setting must be set via docker-machine:

$ docker-machine ssh
$ sudo sysctl -w vm.max_map_count=262144

phpMyFAQ local installation from Github

To run phpMyFAQ locally, you need at least a running web server with PHP support and a database.

$ git clone git://github.com/thorsten/phpMyFAQ.git
$ cd phpMyFAQ
$ git checkout main
$ curl -s https://getcomposer.org/installer | php
$ php composer.phar install
$ curl -fsSL https://get.pnpm.io/install.sh | sh -
$ pnpm install
$ pnpm build

Then just open http://www.example.org/phpmyfaq/setup/index.php in your browser.

Testing

To run our unit tests via PHPUnit v10.x, just execute this command on your CLI

$ curl -s https://getcomposer.org/installer | php
$ php composer.phar install
$ ./vendor/bin/phpunit

Please note that phpMyFAQ needs to be installed via Composer.

Versioning

For transparency and insight into our release cycle, and for striving to maintain backward compatibility, phpMyFAQ will be maintained under the Semantic Versioning guidelines as much as possible.

Releases will be numbered with the following format:

<major>.<minor>.<patch>

And constructed with the following guidelines:

  • Breaking backward compatibility bumps the major (and resets the minor and patch)
  • New additions without breaking backward compatibility bumps the minor (and resets the patch)
  • Bug fixes and misc changes bumps the patch

For more information on SemVer, please visit http://semver.org/.

Bug tracker

Found a bug, or do you have a feature request? Please open a new issue. Before opening any issue, please search for existing issues.

Contributing

Please check out our page about contributing on phpmyfaq.de.

Documentation

You can find the full documentation on https://phpmyfaq.readthedocs.io.

REST API v2.3

The REST API v2.3 documentation is located here in this repository and on phpmyfaq.de.

License

Mozilla Public License 2.0, see LICENSE for more information.

Copyright © 2001–2023 Thorsten Rinne and the phpMyFAQ Team

OPEN ISSUES

See all

RELEASES

See all