Apache is a free and open-source cross-platform web server software.
PHP is a general-purpose scripting language used for web development.
SPIP is a content management system written in PHP that uses one or more databases like SQL, SQLite or PostgreSQL.