/hphp/test/zend/good/ext/mysqli/tests/bug42548.php
PHP | 47 lines | 41 code | 6 blank | 0 comment | 10 complexity | 865f130f352f115615dbc2464b2d36c3 MD5 | raw file
Possible License(s): LGPL-2.1, BSD-2-Clause, BSD-3-Clause, MPL-2.0-no-copyleft-exception, MIT, LGPL-2.0, Apache-2.0
- <?php
- require_once('connect.inc');
- $mysqli = mysqli_init();
- $mysqli->real_connect($host, $user, $passwd, $db, $port, $socket);
- if (mysqli_connect_errno()) {
- printf("Connect failed: %s\n", mysqli_connect_error());
- exit();
- }
- $mysqli->query("DROP PROCEDURE IF EXISTS test_bug42548_procedure_1") or die($mysqli->error);
- $mysqli->query("CREATE PROCEDURE test_bug42548_procedure_1() BEGIN SELECT 23; SELECT 42; END") or die($mysqli->error);
- if ($mysqli->multi_query("CALL test_bug42548_procedure_1();"))
- {
- do
- {
- if ($objResult = $mysqli->store_result()) {
- while ($row = $objResult->fetch_assoc()) {
- print_r($row);
- }
- $objResult->close();
- if ($mysqli->more_results()) {
- print "----- next result -----------\n";
- }
- } else {
- print "no results found\n";
- }
- } while ($mysqli->more_results() && $mysqli->next_result());
- } else {
- print $mysqli->error;
- }
- $mysqli->query("DROP PROCEDURE test_bug42548_procedure_1") or die($mysqli->error);
- $mysqli->close();
- print "done!";
- ?>
- <?php error_reporting(0); ?>
- <?php
- require_once("connect.inc");
- if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
- printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
- mysqli_query($link, "DROP PROCEDURE IF EXISTS test_bug42548_procedure_1");
- mysqli_close($link);
- ?>