PageRenderTime 42ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/hphp/test/zend/bad/ext/mysqli/tests/047.php

http://github.com/facebook/hiphop-php
PHP | 50 lines | 35 code | 14 blank | 1 comment | 3 complexity | 9cbb4ec05f9ed277e6a6da81558fd2ea 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
  1. <?php
  2. require_once("connect.inc");
  3. /*** test mysqli_connect 127.0.0.1 ***/
  4. $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
  5. mysqli_select_db($link, $db);
  6. mysqli_query($link, "DROP TABLE IF EXISTS test_047_table_1");
  7. mysqli_query($link, "CREATE TABLE test_047_table_1 (foo int, bar varchar(10) character set latin1) ENGINE=" . $engine);
  8. mysqli_query($link, "INSERT INTO test_047_table_1 VALUES (1, 'Zak'),(2, 'Greant')");
  9. $stmt = mysqli_prepare($link, "SELECT * FROM test_047_table_1");
  10. mysqli_stmt_execute($stmt);
  11. $result = mysqli_stmt_result_metadata($stmt);
  12. echo "\n=== fetch_fields ===\n";
  13. var_dump(mysqli_fetch_fields($result));
  14. echo "\n=== fetch_field_direct ===\n";
  15. var_dump(mysqli_fetch_field_direct($result, 0));
  16. var_dump(mysqli_fetch_field_direct($result, 1));
  17. echo "\n=== fetch_field ===\n";
  18. while ($field = mysqli_fetch_field($result)) {
  19. var_dump($field);
  20. }
  21. print_r(mysqli_fetch_lengths($result));
  22. mysqli_free_result($result);
  23. mysqli_stmt_close($stmt);
  24. mysqli_query($link, "DROP TABLE IF EXISTS test_047_table_1");
  25. mysqli_close($link);
  26. print "done!";
  27. ?>
  28. <?php error_reporting(0); ?>
  29. <?php
  30. require_once("connect.inc");
  31. if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
  32. printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
  33. if (!mysqli_query($link, "DROP TABLE IF EXISTS test_047_table_1"))
  34. printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  35. mysqli_close($link);
  36. ?>