prepare statements and dates

[mclark]

How is a date sent in a mysqli_stmt_bind_param() statement? The mysqli_stmt_bind_param only seems to support INTEGER, STRING, DOUBLE, and BLOBS.

Here's some pseudo-code:
SQL:
create table test (t1 date)
PHP:
$stmt = $mysqli->prepare('insert into test (t1) (?)');
$stmt->bind_param('s', '01/01/2005');

The value entered is ZERO. I have tried 'd' and 'i' for the bind_param() method parameters, and also datetime for the SQL field type. I am using MySQL 4.1 and PHP 5. I would prefer not to convert the database field to an integer.

Thanks in advance.

[konsu]

try to use quotes in the sql statement: 'insert into test (t1) (\'?\')'

[laserlight]

I havent used the mysqli extension myself, but just to check that you didnt make typo errors:

$date = '01/01/2005';
$stmt = mysqli->prepare("INSERT INTO test (t1) VALUES(?)");
$stmt->bind_param('s', $date);
$stmt->execute()

Does the above code work?

try to use quotes in the sql statement

I dont think that's correct since mclark is using the prepared statement interface.