PageRenderTime 41ms CodeModel.GetById 19ms RepoModel.GetById 1ms app.codeStats 0ms

/hphp/test/zend/bad/ext/mysql/tests/mysql_result.php

http://github.com/facebook/hiphop-php
PHP | 58 lines | 45 code | 12 blank | 1 comment | 3 complexity | 0791c4243ce59652413aa60571eba6f0 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. 

  2. require_once("connect.inc");
    3. 

  3. 

  4. $tmp    = NULL;
    5. 

  5. $link   = NULL;
    6. 

  6. 

  7. // string mysql_result ( resource result, int row [, mixed field] )
    8. 

  8. 

  9. if (!is_null($tmp = @mysql_result()))
    10. 

  10. 	printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
    11. 

  11. 

  12. if (!is_null($tmp = @mysql_result($link)))
    13. 

  13. 	printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
    14. 

  14. 

  15. require_once('table.inc');
    16. 

  16. if (!$res = mysql_query("SELECT id, label, id AS _id, CONCAT(label, 'a') _label, NULL as _foo FROM test _test ORDER BY id ASC LIMIT 1", $link)) {
    17. 

  17. 	printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link));
    18. 

  18. }
    19. 

  19. 

  20. var_dump(mysql_result($res, -1));
    21. 

  21. var_dump(mysql_result($res, 2));
    22. 

  22. 

  23. var_dump(mysql_result($res, 0, -1));
    24. 

  24. var_dump(mysql_result($res, 0, 500));
    25. 

  25. 

  26. print "valid fields\n";
    27. 

  27. var_dump(mysql_result($res, 0));
    28. 

  28. var_dump(mysql_result($res, 0, 1));
    29. 

  29. 

  30. var_dump(mysql_result($res, 0, 'id'));
    31. 

  31. var_dump(mysql_result($res, 0, '_test.id'));
    32. 

  32. var_dump(mysql_result($res, 0, 'label'));
    33. 

  33. var_dump(mysql_result($res, 0, '_test.label'));
    34. 

  34. print "some invalid fields\n";
    35. 

  35. var_dump(mysql_result($res, 0, 'unknown'));
    36. 

  36. var_dump(mysql_result($res, 0, '_test.'));
    37. 

  37. var_dump(mysql_result($res, 0, chr(0)));
    38. 

  38. var_dump(mysql_result($res, 0, '_test.' . chr(0)));
    39. 

  39. print "_id\n";
    40. 

  40. var_dump(mysql_result($res, 0, '_id'));
    41. 

  41. print "_label\n";
    42. 

  42. var_dump(mysql_result($res, 0, '_label'));
    43. 

  43. print "_foo\n";
    44. 

  44. var_dump(mysql_result($res, 0, '_foo'));
    45. 

  45. var_dump(mysql_result($res, 0, 'test.id'));
    46. 

  46. var_dump(mysql_result($res, 0, 'test.label'));
    47. 

  47. 

  48. mysql_free_result($res);
    49. 

  49. 

  50. var_dump(mysql_result($res, 0));
    51. 

  51. 

  52. mysql_close($link);
    53. 

  53. print "done!";
    54. 

  54. ?>
    55. 

  55. <?php error_reporting(0); ?>
    56. 

  56. <?php
    57. 

  57. require_once("clean_table.inc");
    58. 

  58. ?>
    59.