Repository files navigation

This application connects to your YugabyteDB instance via thephp-pgsql driver for PostgreSQL and performs basic SQL operations. The instructions below are provided forYugabyteDB Aeon deployments.If you use a different type of deployment, then update thesample-app.php file with proper connection parameters.

• PHP runtime - the sample project was created with PHP 8.1 but should work with earlier and later versions.
• Command line tool or your favorite IDE, such as Visual Studio Code.

• Start YugabyteDB Aeon instance. You can usethe free tier at no cost.
• Add an IP address of your machine/laptop to theIP allow list

Clone the repository and change dirs into it:

git clone https://github.com/YugabyteDB-Samples/yugabyte-simple-php-app.git&&cd yugabyte-simple-php-app

Set the following connection parameters in thesample-app.php file:

• HOST - the hostname of your YugabyteDB Managed instance.
• USER - the username for your database.
• PASSWORD - the password for your database.
• SSL_MODE - an SSL mode. Make sure it's set toverify-full for YugabyteDB Aeon.
• SSL_ROOT_CERT - a full path to your CA root cert (for example,/Users/dmagda/certificates/root.crt).

Note, you can easily find all the settings on the YugabyteDB Aeon dashboard:

1. Install thephp-pgsql driver:

   • Homebrew users of version PHP 7.2+: the driver is installed automatically with thebrew install php command.
   • Ubuntu users can install with thesudo apt-get install php-pgsql command.
   • CentOS users can install with thesudo yum install php-pgsql command.
   • Others need to follow thephp-pgsql installation guide.

2. Run the application:

   php sample-app.php

Upon successful execution, you will see output similar to the following:

>>>> Connecting to YugabyteDB!>>>> Successfully connected to YugabyteDB!>>>> Successfully created table DemoAccount.>>>> Selecting accounts:name=Jessica, age=28, country=USA, balance=10000name=John, age=28, country=Canada, balance=9000>>>> Transferred 800 between accounts>>>> Selecting accounts:name=Jessica, age=28, country=USA, balance=9200name=John, age=28, country=Canada, balance=9800

Congrats! You've successfully executed a simple PHP app that works with YugabyteDB Aeon.

Now, explore the source code ofsample-app.php:

1. connect function - establishes a connection with your cloud instance via the php-pgsql driver.
2. create_database function - creates a table and populates it with sample data.
3. select_accounts function - queries the data with SQLSELECT statements.
4. transfer_money_between_accounts function - updates records consistently with distributed transactions.

Having issues running this application or want to learn more from Yugabyte experts?

Joinour Slack channel,or raise a question on StackOverflow and tag the question withyugabytedb!