Quick Snippet for Running MSSQL Stored Procedures with Zend Framework

In order to hopefully save some poor PHP programmer out there the same headaches and endless curses of frustrations with syntax and vague database error messages when trying to call a MSSQL stored procedure using Zend Framework (using 1.11)....here is the syntax.

#!/usr/local/zend/bin/php
<?php
require_once 'Zend/Loader/Autoloader.php';
Zend_Loader_Autoloader::getInstance();
try {
$db = Zend_Db::factory('Pdo_Mssql', array(
'host' => 'host.name.com',
'username' => 'username',
'password' => 'password',
'dbname' => 'databasename',
'pdoType' => 'dblib'
));
$startDate = "05/01/2011 12:00:00";
$endDate = "06/01/2011 12:00:00";
$stmt = $db->prepare("EXEC sp_name ?, ?");
$stmt->bindParam(1, $startDate, PDO::PARAM_STR);
$stmt->bindParam(2, $endDate, PDO::PARAM_STR);
$stmt->execute();
$rows = $stmt->fetchAll();
Zend_Debug::dump($rows);
$stmt->closeCursor();
} catch (Zend_Db_Adapter_Exception $e) {
print $e->__toString();
} catch (PDOException $e) {
print $e->__toString();
} catch (Zend_Exception $e) {
print $e->__toString();
}
view raw gistfile1.php hosted with ❤ by GitHub