2
mysqli bind_param/bind_result date
4
<?php require_once('skipif.inc'); ?>
9
/*** test mysqli_connect 127.0.0.1 ***/
10
$link = mysqli_connect($host, $user, $passwd);
12
mysqli_select_db($link, "test");
14
mysqli_query($link,"DROP TABLE IF EXISTS test_bind_result");
15
mysqli_query($link,"CREATE TABLE test_bind_result(c1 date, c2 time,
22
$stmt = mysqli_prepare($link, "INSERT INTO test_bind_result VALUES (?,?,?,?,?,?,?)");
23
mysqli_bind_param($stmt, "sssssss", $d1, $d2, $d3, $d4, $d5, $d6, $d7);
27
$d3 = '2002-01-02 17:46:59';
33
mysqli_execute($stmt);
34
mysqli_stmt_close($stmt);
36
$stmt = mysqli_prepare($link, "SELECT * FROM test_bind_result");
38
mysqli_bind_result($stmt,$c1, $c2, $c3, $c4, $c5, $c6, $c7);
40
mysqli_execute($stmt);
43
$test = array($c1,$c2,$c3,$c4,$c5,$c6,$c7);
47
mysqli_stmt_close($stmt);
53
string(10) "2002-01-02"
57
string(19) "2002-01-02 17:46:59"
61
string(19) "2010-07-10 00:00:00"
63
string(19) "0000-00-00 00:00:00"
65
string(19) "1999-12-29 00:00:00"