Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement