Create a TCP connection by using PHP

Open a TCP connection to Cloud SQL PostgreSQL by using the PHP Data Objects (PDO) extension.

Explore further

For detailed documentation that includes this code sample, see the following:

• About connection options
• Connect from App Engine flexible environment
• Connect from App Engine standard environment
• Connect from Cloud Build
• Connect from Cloud Functions
• Connect from Cloud Run
• Connect using the AlloyDB Auth proxy
• Connect using the Cloud SQL Auth proxy
• Manage database connections

Code sample

PHP

View on GitHub

// $username = 'your_db_user';
// $password = 'yoursupersecretpassword';
// $dbName = 'your_db_name';
// $dbHost = "127.0.0.1";

// Connect using TCP
$dsn = sprintf('pgsql:dbname=%s;host=%s', $dbName, $dbHost);

// Connect to the database
$conn = new PDO($dsn, $username, $password, $connConfig);

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.