Install the php-pgsql driver

To install, see php-pgsql - Installation.

For example, for CentOS, use sudo yum install php-pgsql For Ubuntu, use sudo apt-get install php-pgsql.

Create the sample PHP application

Create a file yb-sql-sample.php and copy the following content into it.

<?php try { /* Establish connection. */ $dbh = new PDO('pgsql:host=127.0.0.1;port=5433;dbname=yugabyte;user=yugabyte;password=yugabyte', 'yugabyte', null, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_EMULATE_PREPARES => true, PDO::ATTR_PERSISTENT => true)); /* Create the table if it doesn't exist. */ $stmt = 'CREATE TABLE IF NOT EXISTS employee (id int PRIMARY KEY, name varchar, salary int, dept varchar)'; $dbh->exec($stmt); /* Prepare the insert statement. */ $insert_stmt = $dbh->prepare('INSERT INTO employee(id, name, salary, dept) ' . 'VALUES (:id, :name, :salary, :dept)'); /* Insert a row. */ $insert_stmt->bindValue(':id', 10, PDO::PARAM_INT); $insert_stmt->bindValue(':name', 'Jane', PDO::PARAM_STR); $insert_stmt->bindValue(':salary', 150000, PDO::PARAM_INT); $insert_stmt->bindValue(':dept', 'Engineering', PDO::PARAM_STR); $insert_stmt->execute(); /* Insert a row. */ $insert_stmt->bindValue(':id', 11, PDO::PARAM_INT); $insert_stmt->bindValue(':name', 'Joe', PDO::PARAM_STR); $insert_stmt->bindValue(':salary', 140000, PDO::PARAM_INT); $insert_stmt->bindValue(':dept', 'Finance', PDO::PARAM_STR); $insert_stmt->execute(); echo "Inserted new records successfully.\n"; /* Prepare query statement to retrieve user info by id */ $query = $dbh->prepare('SELECT name, salary, dept FROM employee WHERE id = :id'); $query->bindValue(':id', 11, PDO::PARAM_INT); $query->execute(); $user_info = $query->fetch(PDO::FETCH_ASSOC); echo "Retrieving info for user id 11...\n"; print_r($user_info); } catch (Exception $excp) { print "EXCEPTION: " . $excp->getMessage() . "\n"; exit(1); }

Run the application

To run the application:

$ php yb-sql-sample.php

and you should see the following output:

Inserted new records successfully.
Retrieving info for user id 11...
Array
(
    [name] => Joe
    [salary] => 140000
    [dept] => Finance
)