Скачать или смотреть How to Run PHP Files with PostgreSQL Without Using XAMPP

Learn how to set up and run PHP files with PostgreSQL without relying on XAMPP. This guide covers PostgreSQL installation, PHP configuration, and database connection steps.
---
How to Run PHP Files with PostgreSQL Without Using XAMPP

Setting up a web development environment can sometimes be a daunting task, particularly when trying to avoid pre-packaged solutions like XAMPP. If you're looking to run PHP files with PostgreSQL instead, this guide will walk you through the necessary steps.

Install PostgreSQL

First, you need to install PostgreSQL on your system. PostgreSQL is an open-source relational database management system that’s available for various platforms, including Windows.

Windows Installation Steps:

Download the PostgreSQL installer from the official PostgreSQL website.

Run the installer and follow the on-screen instructions.

During installation, choose the components you wish to install (you typically need PostgreSQL server and pgAdmin).

Set a superuser password.

Choose the port (default is 5432).

After installation, you can verify the installation by opening pgAdmin or using the psql command-line tool.

Install PHP

Windows Installation Steps:

Download the latest stable PHP version (ZIP archive) from the official PHP website.

Extract the contents to a directory, e.g., C:\php.

Add the PHP directory to the system’s PATH:

Right-click on This PC or My Computer, and click Properties.

Click Advanced system settings, then the Environment Variables button.

Locate the Path variable in the System variables section, and click Edit.

Add C:\php (or your PHP directory) to the list of paths.

Verify the installation by opening a command prompt and typing php -v. You should see the PHP version displayed.

Configure PHP to Work with PostgreSQL

Open your php.ini file situated in your PHP directory.

Uncomment the following lines by removing the semicolon (;):

[[See Video to Reveal this Text or Code Snippet]]

Save the php.ini file.

Connect PHP with PostgreSQL

Below is a basic PHP script to connect to PostgreSQL:

[[See Video to Reveal this Text or Code Snippet]]

Save and Run the Script:

Save this script with a .php extension in your web server’s document root.

Make sure a server, like Apache or Nginx, is installed and configured to serve PHP files.

Navigate to the PHP file through your web browser to see the connection status message.

Conclusion

By following these steps, you can successfully set up and run PHP files with PostgreSQL without resorting to XAMPP. This setup gives you the flexibility and understanding of each component in your web development stack, allowing for greater customization and control over your development environment.