mysqli_prepare.phpt - OpenGrok cross reference for /PHP-7.4/ext/mysqli/tests/mysqli

Lines Matching refs:stmt
35 …if (!is_object(($stmt = mysqli_prepare($link, 'SELECT id FROM test'))) || !mysqli_stmt_execute($st…
37     mysqli_stmt_close($stmt);
43 …if (!is_object(($stmt = mysqli_prepare($link, 'CREATE TABLE test2(id INT) ENGINE =' . $engine))) |…
45     mysqli_stmt_close($stmt);
48     if (!is_object(($stmt = mysqli_prepare($link, 'INSERT INTO test2(id) VALUES(?)'))))
52     if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt))
54     mysqli_stmt_close($stmt);
56     if (!is_object(($stmt = mysqli_prepare($link, 'REPLACE INTO test2(id) VALUES (?)'))))
60     if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt))
62     mysqli_stmt_close($stmt);
64     if (!is_object(($stmt = mysqli_prepare($link, 'UPDATE test2 SET id = ? WHERE id = ?'))))
69     if (!mysqli_stmt_bind_param($stmt, 'ii', $id, $where) || !mysqli_stmt_execute($stmt))
71     mysqli_stmt_close($stmt);
73     if (!is_object(($stmt = mysqli_prepare($link, 'DELETE FROM test2 WHERE id = ?'))))
77     if (!mysqli_stmt_bind_param($stmt, 'i', $where) || !mysqli_stmt_execute($stmt))
79     mysqli_stmt_close($stmt);
81     if (!is_object(($stmt = mysqli_prepare($link, 'SET @testvar = ?'))))
85     if (!mysqli_stmt_bind_param($stmt, 's', $testvar) || !mysqli_stmt_execute($stmt))
87     mysqli_stmt_close($stmt);
89     if (!is_object(($stmt = mysqli_prepare($link, "DO GET_LOCK('testlock', 1)"))))
91     mysqli_stmt_close($stmt);
93     if (!is_object(($stmt = mysqli_prepare($link, 'SELECT id, @testvar FROM test2'))))
97     if (!mysqli_stmt_execute($stmt) || !mysqli_stmt_bind_result($stmt, $id, $testvar))
99     while (mysqli_stmt_fetch($stmt)) {
102                 $testvar, $id, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
105     var_dump(mysqli_stmt_prepare($stmt, 'SELECT 1; SELECT 2'));
107     mysqli_stmt_close($stmt);