mysql_real_escape_string.phpt 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. --TEST--
  2. mysql_real_escape_string()
  3. --SKIPIF--
  4. <?php
  5. require_once('skipif.inc');
  6. require_once('skipifconnectfailure.inc');
  7. ?>
  8. --FILE--
  9. <?php
  10. include "connect.inc";
  11. $tmp = NULL;
  12. $link = NULL;
  13. if (NULL !== ($tmp = @mysql_real_escape_string()))
  14. printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  15. require('table.inc');
  16. if (NULL !== ($tmp = @mysql_real_escape_string('foo', $link, $link)))
  17. printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  18. var_dump(mysql_real_escape_string("Am I a unicode string in PHP 6?", $link));
  19. var_dump(mysql_real_escape_string('\\', $link));
  20. var_dump(mysql_real_escape_string('"', $link));
  21. var_dump(mysql_real_escape_string("'", $link));
  22. var_dump(mysql_real_escape_string("\n", $link));
  23. var_dump(mysql_real_escape_string("\r", $link));
  24. var_dump($tmp = mysql_real_escape_string("foo" . chr(0) . "bar", $link));
  25. assert($tmp === mysql_real_escape_string("foo" . chr(0) . "bar"));
  26. print "done!";
  27. ?>
  28. --EXPECTF--
  29. Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
  30. %unicode|string%(31) "Am I a unicode string in PHP 6?"
  31. %unicode|string%(2) "\\"
  32. %unicode|string%(2) "\""
  33. %unicode|string%(2) "\'"
  34. %unicode|string%(2) "\n"
  35. %unicode|string%(2) "\r"
  36. %unicode|string%(8) "foo\0bar"
  37. done!