CREATE PROCEDURE get_some_list 
   @val1 char(3),
   @val2 char(2),
   @date1 datetime,
   @date2 datetime
AS BEGIN
   SELECT column1, column2, column3 FROM some_table WHERE val1=@val1 AND val2=@val2 AND some_date BETWEEN @date1 AND @date2
END

$stm = $conn->prepare("exec get_some_list");
$stm->execute(
                   ["@val1" => "AAA",
                       "@val2" => "AA",
                       "@date1" => "2014-11-30",
                       "@date2" => "2014-12-03"]
                   );

$stm = $conn->query("exec get_some_list 'AAA', 'AA', '2014-11-30', '2014-12-03'");