Here's a snippet from my current code:
Code: Select all
$sth = mssql_init($query, $this->dbh);
if(is_array($params))
{
foreach($params as $name => $value)
{
$success = mssql_bind($sth, $name, $value, SQLVARCHAR, false, false);
if(!$success)
{
throw new \Errors\SqlException('Failed to bind paramater.', 0, print_r(array($query, $params, mssql_get_last_message()), true));
}
}
}
$result = mssql_execute($sth) or die('Failed to execute.');
while($row = mssql_fetch_assoc($result))
{
// Do stuff
}
Thanks very much for any help, I appreciate it.