This directory contains samples for calling Google Cloud Spanner from PHP.

Google Cloud Spanner is a highly scalable, transactional, managed, NewSQL database service. Cloud Spanner solves the need for a horizontally-scaling database with consistent global transactions and SQL semantics.

See Getting Started in PHP for a walkthrough of these samples.

Authentication is typically done through Application Default Credentials which means you do not have to change the code to authenticate as long as your environment has credentials. You have a few options for setting up authentication:

1. When running locally, use the Google Cloud SDK

    gcloud auth application-default login
   

2. When running on App Engine or Compute Engine, credentials are already set-up. However, you may need to configure your Compute Engine instance with additional scopes.

3. You can create a Service Account key file. This file can be used to authenticate to Google Cloud Platform services from any environment. To use the file, set the GOOGLE_APPLICATION_CREDENTIALS environment variable to the path to the key file, for example:

    export GOOGLE_APPLICATION_CREDENTIALS=/path/to/service_account.json
   

These samples require you to first set up a Spanner Instance. Once you've finished with the samples, you can delete your instance to prevent incurring any additional charges.

1. Ensure the gRPC PHP Extension is installed and enabled on your machine.

2. Enable the Cloud Spanner API.

3. Install dependencies via Composer. Run php composer.phar install (if composer is installed locally) or composer install (if composer is installed globally).

4. Create a service account at the Service account section in the Cloud Console

5. Download the json key file of the service account.

6. Set GOOGLE_APPLICATION_CREDENTIALS environment variable pointing to that file.

To run the Spanner Samples, run any of the files in src/ on the CLI:

$ php src/create_instance.php

Usage: create_instance.php $instanceId

  @param string $instanceId The Spanner instance ID.

If you get the following error, set the environment variable GCLOUD_PROJECT to your project ID:

[Google\Cloud\Core\Exception\GoogleException]
No project ID was provided, and we were unable to detect a default project ID.

This sample uses the Spanner Client Library for PHP. You can read the documentation for more details on API usage and use GitHub to browse the source and report issues.