Connecting to a database

1. Make sure that PHP and composer are installed.

2. Install php-pgsql library.

3. Connect to the database using the function pg_connect():

   Copy
   $conn = pg_connect("host=<IP-ADDRESS> dbname=<DATABASE> user=<USERNAME> password=<PASSWORD>");

   Here:

   • <IP-ADDRESS> — external IP address of the DB instance;
   • <DATABASE> — database name;
   • <USERNAME> — DB user name;
   • <PASSWORD> — DB user password.

Read more about connecting to PostgreSQL in PHP in documentation.

1. Make sure that PHP and composer are installed.

2. Install php-mysql library.

3. Connect to the database using the function mysqli_real_connect():

   Copy
   $conn = mysqli_init();mysqli_real_connect($conn, "<IP-ADDRESS>", "<USERNAME>", "<PASSWORD>", "<DATABASE>", <PORT>);

   Here:

   • <IP-ADDRESS> — external IP address of the DB instance;
   • <DATABASE> — database name;
   • <PORT> — connection port, standard — 3306;
   • <USERNAME> — DB user name;
   • <PASSWORD> — DB user password.

Read more about connecting to MySQL in PHP in documentation.

1. Make sure that PHP and composer are installed.

2. Install tarantool/client library.

3. Connect to the database using the method Client::fromDsn:

   Copy
   require_once __DIR__ . '/vendor/autoload.php';use Tarantool\Client\Client;$client = Client::fromDsn('tcp://<USERNAME>:PASSWORD>@<IP-ADDRESS>');

   Here:

   • <IP-ADDRESS> — external IP address of the DB instance;
   • <USERNAME> — DB user name;
   • <PASSWORD> — DB user password.

Read more about connecting to Tarantool in PHP in documentation.

1. Make sure that PHP and composer are installed.

2. Install php-curl.

3. Install smi2/phpclickhouse module.

4. Connect to the database:

   Copy
   require_once __DIR__ . '/vendor/autoload.php';$config = [    'host' => '<IP-ADDRESS>',    'port' => '<PORT>',    'username' => '<USERNAME>',    'password' => '<PASSWORD>'];$db = new ClickHouseDB\Client($config);$db->database('<DATABASE>');

   Here:

   • <IP-ADDRESS> — external IP address of the DB instance;
   • <DATABASE> — database name;
   • <PORT> — connection port, standard — 8123;
   • <USERNAME> — DB user name;
   • <PASSWORD> — DB user password.

1. Make sure that PHP and composer are installed.

2. Install PHP library for MongoDB.

3. Connect to the database:

   Copy
   $manager = new MongoDB\Driver\Manager("mongodb://<IP-ADDRESS>/<DATABASE>", array("username" => <USERNAME>, "password" => <PASSWORD>));

   Here:

   • <IP-ADDRESS> — external IP address of the DB instance;
   • <DATABASE> — database name;
   • <USERNAME> — DB user name;
   • <PASSWORD> — DB user password.

1. Make sure that PHP and composer are installed.

2. Install predis.

3. Connect to the database:

   Copy
   require_once __DIR__ . '/vendor/autoload.php';Predis\Autoloader::register();$client = new Predis\Client('tcp://<IP-ADDRESS>');

   Here:

   • <IP-ADDRESS> — external IP address of the DB instance;
   • <DATABASE> — database name;
   • <USERNAME> — DB user name;
   • <PASSWORD> — DB user password.