Simple Example of making a PDO ODBC connection to an IBM i and running prepared statements

PHPPDOIBMiConnection.php

<?php
$hostname = "MYIBMI";
$user = "MYPROFILE";
$password = "";//leave blank and prompt.  (works in windows not sure if it will work in other situations)
$pdoConnection = new PDO("odbc:" . $hostname, $user, $password);

$sql="SELECT * FROM MYLIB.MYTABLE WHERE NAME=:NAME AND CITY=:CITY";
$stmt = $pdoConnection->prepare($sql);
if (!$stmt)
{
    echo implode($this->_pdoConnection->errorInfo());
}
else
{
    $stmt->bindValue(":NAME", "Chuck");
    $stmt->bindValue(":CITY", "Orlando");
}

if ($stmt->execute())
{
  while ($row = $stmt->fetch(PDO::FETCH_ASSOC))
  {
      var_dump($row).PHP_EOL;
  }
}
else
{
  echo 'statement failed with '.$stmt->errorInfo();
}