I am moving from .net/MSSQL to PHP/MSSQL for obvious reasons, I am new to PHP. My PHP code
setup is
PHP on Ubuntu 12.04
MSSQL on Windows server.
Code: Select all
$paramDueDateBy = "Today";
$paramUserName = "MB";
$paramDueDateFrom = "2009-10-10 00:00:00";
$paramDueDateTo ="2013-10-10 00:00:00";
$conn = connect_db() or exit('Db connect failed...');
// Bind values
$stmt = mssql_init('GetToDoList',$conn);
mssql_bind($stmt, '@strDueDateBy', $paramDueDateBy, SQLVARCHAR, false, false,50);
mssql_bind($stmt, '@strScheduleTo', $paramUserName, SQLVARCHAR,false, false,50);
mssql_bind($stmt, '@strDueDateFrom', $paramDueDateFrom, SQL_DATE,false, false,50);
mssql_bind($stmt, '@strDueDateTo', $paramDueDateTo, SQL_DATE,false, false,50);
//exit;
$result = mssql_execute($stmt);