PHP MS SQL Placeholders for Date

Question

How do I pass date into placeholder for PHP and MS SQL?

The sample code I am using:

$fromDate = '2013-01-01';
$toDate = '2013-02-28';
$empno = 12345;

$sqlStr = "SELECT * FROM histTable WHERE EmpNum = ?
           AND toDate >= ? AND fromDate <= ?";

$sqlResult = $this->db->query($sqlStr, $empno, $fromDate, $toDate);

I could not get anything from the database unless I hard code the date values.

Can anyone please help?

Thank you.

im guessing your mysql has column as datatype or timestamp and your passing a string — Nishant Jani, Feb 14 '13 at 12:07
http://stackoverflow.com/questions/10435109/sql-query-escaping-codeigniter — tomexsans, Feb 14 '13 at 12:12

score 0 · Answer 1 · answered Feb 14 '13 at 12:52

0

Try this ...

$fromDate = '2013-01-01 00:00:00';
$toDate = '2013-02-28 00:00:00';
$empno = 12345;

$sqlStr = "SELECT * FROM histTable WHERE EmpNum = $empno
           AND toDate >= '$fromDate' AND fromDate <= '$toDate'";

$sqlResult = $this->db->query($sqlStr);

answered Feb 14 '13 at 12:52

Venkata Krishna

4,287
6
30
53

Wish I could but I have to use placeholders. – Jamie Feb 14 '13 at 12:56

score 0 · Answer 2 · answered Feb 14 '13 at 13:02

0

Straight off the top of my head, try changing:

$sqlStr = "SELECT * FROM histTable WHERE EmpNum = ? AND toDate >= ? AND fromDate <= ?";

to

$sqlStr = "SELECT * FROM histTable WHERE EmpNum = ? AND toDate >= '?' AND fromDate <= '?'";

answered Feb 14 '13 at 13:02

Raad

4,540
2
24
41

score 0 · Answer 3 · answered Feb 14 '13 at 13:06

its all in the '' or "" i rather to use "";

$fromDate = '2013-01-01';
$toDate = '2013-02-28';
$empno = 12345;

$sqlStr = "SELECT * FROM histTable WHERE EmpNum = ?
       AND toDate >= '{$fromDate}' AND fromDate <= '{$toDate}' ";

$sqlResult = $this->db->query($sqlStr, $empno, $fromDate, $toDate);

mind the commas around the vars.

PHP MS SQL Placeholders for Date

3 Answers3