PHP

try {
    $insertSQL =
        "INSERT INTO persons (socialsecurity, firstname, lastname, city)
         VALUES
         ('728496923-J', 'John', 'Smith', 'San Francisco')";
    $stm = $pdoConnection->query($insertSQL) ;
} catch (PDOException $e) {
    echo "Problem inserting a row: " . $e->getMessage();
}

try {
    $insertSQL =
        "INSERT INTO persons (socialsecurity, firstname, lastname, city)
         VALUES
         (:ss, :fn, :ln, :city)";
    $stm = $pdoConnection->prepare($insertSQL) ;
    $stm->execute([
        ':ss'    => '7691241241-Z',
        ':fn'   => 'Carl',
        ':ln'   => 'Parson',
        ':city' => 'New York'
    ]);
} catch (PDOException $e) {
    echo "Problem inserting a row: " . $e->getMessage();
}

try {
    $updateSQL =
        "UPDATE persons
         SET city='Madrid'
         WHERE city='San Francisco'";
    $numAffectedRows = $pdoConnection->exec($updateSQL);
} catch (PDOException $e) {
    echo "Problem updating: " . $e->getMessage();
}

try {
    $deleteSQL =
        "DELETE FROM persons
         WHERE city='New York'";
    $numAffectedRows = $pdoConnection->exec($deleteSQL);
} catch (PDOException $e) {
    echo "Problem deleting: " . $e->getMessage();
}

$tid = lxBegin();

$people = new LxCollection($tid, $tablename);
$tupleBuilder = new LxTupleBuilder($people);

$person = [
  1,
  "123456789A",
  "John",
  "Doe",
  "No comments",
  "Mulholland Drive",
  "555333695",
  "johndoe@nowhere.no",
  "1970-01-01",
  70,
  179
];

$tupleBuilder->addValues($person);
$tuple = $tupleBuilder->build($people);
$people->insert($tuple);

$seqname = "seq";
$startpoint = 2;
$incrementby = 1;
$lxseq = lxCreateSequence($seqname,$startpoint,$incrementby);

$nextval = $lxseq.nextVal();

$person = [
  $nextval,
  "912345678B",
  "Jane",
  "Doe",
  "Mulholland Drive",
  "0034698765432",
  "janedoe@lx.com",
  "1967-01-01",
  70,
  185
];
$tupleBuilder->addValues($person);
$tuple = $tupleBuilder->build($people);
$people->insert($tuple);

$nextval = $lxseq.nextVal();

$person = [
  $nextval,
  null,
  "Jim",
  "Doe",
  "Mulholland Drive",
  null,
  null,
  "2008-01-01"
];

$properties = [
  "autocommit" => "no"
];
lxSetProperties($properties);

$tupleBuilder->addValues($person);
$tuple = $tupleBuilder->build($people);
$people->insert($tuple);

$pic = fopen("/tmp/pic.jpg", "r");
if ($pic) {
  $people.addBlob("photo");

  while (($bufer = fgets($pic, 4096)) !== false) {
    $people.addBlobData($bufer);
  }
  if (!feof($pic)) {
    echo "Error: fallo inesperado de fgets()\n";
  }
  fclose($pic);
  $people.addBlobDone();
}

lxEnd($tid);

$properties = [
  "autocommit" => "yes"
];
lxSetProperties($properties);

$tupleBuilder->addTuple($tuple);
$tupleBuilder->add(9, 75);
$tuple = $tupleBuilder->build($collection);

$people->update($tuple);

$key = $keyBuilder->buildKey($collection);

$collection->delete($key);

$it = $people.find()
        .first(20);

foreach ($it as $key => $value) {
  $people.delete($value);
}

$keyfmt = "l[k]";

$keyBuilder = new LxTupleBuilder($keyfmt);

$person = [
  "personId" => "1"
];
$keyBuilder->addValues($person);
$key = $keyBuilder->buildKey($collection);

$tuple = $collection->get($key);

if ($tuple->isNull()) {
  throw new Exception('Tuple is null');
}
$fno = 2;
$fieldValue = $tuple->get($fno);
if (strcmp($fieldValue, "John") !== 0) {
  throw new Exception("Not the expected value but {$fieldValue}");
}

$people = new LxCollection($tablename);

$it = $people.find()
        .min(0)
        .max(2);

// Max 20 results
$it = $people.find()
        .first(20);

foreach ($it as $key => $value) {
  echo ("$key: \n");
  print_r($value);
}

$it = $people.find()
        .index("dniIdx")
        .indexMin("111111111Q");

foreach ($it as $key => $value) {
  echo ("$key: \n");
  print_r($value);
}

$pipeline = [
  ['$match' => [
    '$and' => [
      ['height' => 179],
      ['weight' => ['$gte' => 65, '$lte' => 80]],
    ]
  ]]
];

$it = $people->aggregateCursor($pipeline);

foreach ($it as $key => $value) {
  echo ("$key: \n");
  print_r($value);
}

$pipeline = [
  ['$match' => [
    '$and' => [
      ['height' => 179],
      ['weight' => ['$gte' => 65, '$lte' => 80]],
    ]
  ]],
  ['$project' => [
    'dni' => '$dni',
    'name' => '$name',
    'lastname' => '$lastname'
  ]]
];

$it = $people->aggregateCursor($pipeline);

foreach ($it as $key => $value) {
  echo ("$key: \n");
  print_r($value);
}

$pipeline = [
  ['$group' => [
    '_id' => [
      'address' => '$address',
    ],
    'namecount' => ['$count' => '$_id']
  ]],
];

$it = $people->aggregateCursor($pipeline);

foreach ($it as $key => $value) {
  echo ("$key: \n");
  print_r($value);
}

$pipeline = [
  ['$match' => [
    "address" => "Mulholland Drive"
  ]],
  ['$group' => [
    '_id' => [
      'address' => '$address',
    ],
    'namecount' => ['$count' => '$_id']
  ]],
  ['$match' => [
    "namecount" => 3
  ]],
];

$it = $people->aggregateCursor($pipeline);

foreach ($it as $key => $value) {
  echo ("$key: \n");
  print_r($value);
}