mysqli_real_escape_string.phpt 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. --TEST--
  2. mysqli_real_escape_string()
  3. --SKIPIF--
  4. <?php
  5. require_once('skipif.inc');
  6. require_once('skipifemb.inc');
  7. require_once('skipifconnectfailure.inc');
  8. ?>
  9. --FILE--
  10. <?php
  11. require_once("connect.inc");
  12. $tmp = NULL;
  13. $link = NULL;
  14. if (NULL !== ($tmp = @mysqli_real_escape_string()))
  15. printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  16. if (NULL !== ($tmp = @mysqli_real_escape_string($link)))
  17. printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  18. require('table.inc');
  19. if (NULL !== ($tmp =@mysqli_real_escape_string($link, "foo", "foo")))
  20. printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  21. if ('\\\\' !== ($tmp = mysqli_real_escape_string($link, '\\')))
  22. printf("[004] Expecting \\\\, got %s\n", $tmp);
  23. if ('\"' !== ($tmp = mysqli_real_escape_string($link, '"')))
  24. printf("[005] Expecting \", got %s\n", $tmp);
  25. if ("\'" !== ($tmp = mysqli_real_escape_string($link, "'")))
  26. printf("[006] Expecting ', got %s\n", $tmp);
  27. if ("\\n" !== ($tmp = mysqli_real_escape_string($link, "\n")))
  28. printf("[007] Expecting \\n, got %s\n", $tmp);
  29. if ("\\r" !== ($tmp = mysqli_real_escape_string($link, "\r")))
  30. printf("[008] Expecting \\r, got %s\n", $tmp);
  31. if ("foo\\0bar" !== ($tmp = mysqli_real_escape_string($link, "foo" . chr(0) . "bar")))
  32. printf("[009] Expecting %s, got %s\n", "foo\\0bar", $tmp);
  33. mysqli_close($link);
  34. if (NULL !== ($tmp = mysqli_real_escape_string($link, 'foo')))
  35. printf("[010] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  36. /* Make sure that the function alias exists */
  37. if (NULL !== ($tmp = @mysqli_escape_string()))
  38. printf("[011] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  39. print "done!";
  40. ?>
  41. --EXPECTF--
  42. Warning: mysqli_real_escape_string(): Couldn't fetch mysqli in %s on line %d
  43. done!