Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given… what I do wrong? 

You are mixing mysqli and mysql function.

If your are using mysql function then instead mysqli_real_escape_string($your_variable); use

$username = mysql_real_escape_string($_POST['username']);
$pass = mysql_real_escape_string($_POST['pass']);
$pass1 = mysql_real_escape_string($_POST['pass1']);
$email = mysql_real_escape_string($_POST['email']);

If your using mysqli_* function then you have to include your connection to database into mysqli_real_escape function :

$username = mysqli_real_escape_string($your_connection, $_POST['username']);
$pass = mysqli_real_escape_string($your_connection, $_POST['pass']);
$pass1 = mysqli_real_escape_string($your_connection, $_POST['pass1']);
$email = mysqli_real_escape_string($your_connection, $_POST['email']);

Note : Use mysqli_* function since mysql has been deprecated. For information please read mysqli_*

Related Posts:

  1. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  2. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  3. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
  4. mysqli_real_connect(): (HY000/2002): No such file or directory
  5. Fatal error: Call to undefined function mysqli_connect()
  6. mysqli_real_connect(): (HY000/2002): No such file or directory
  7. Fatal error: Call to undefined function mysqli_connect()
  8. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  9. MySqli Commands out of sync; you can’t run this command now
  10. Commands out of sync; you can’t run this command now
  11. Call to undefined method mysqli_stmt::get_result
  12. Call to undefined method mysqli_stmt::get_result
  13. Fatal error: Cannot use object of type mysqli_result
  14. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  15. mysql_field_name to the new mysqli
  16. mysqli_select_db() expects parameter 1 to be mysqli, string given
  17. mysqli::query(): Couldn’t fetch mysqli
  18. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  19. Warning: mysqli_query() expects at least 2 parameters, 1 given. What? [duplicate]
  20. Deprecated: mysql_query() [duplicate]
  21. Object of class mysqli_result could not be converted to string
  22. Fatal error: Call to a member function fetch_assoc() on a non-object
  23. Having a problem getting mysqli_query to execute
  24. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  25. Call to a member function fetch_assoc() on boolean in [duplicate]
  26. PHP variables don’t evaluate in the query [duplicate]
  27. How to set 777 permission on a particular folder? [closed]
  28. regex match any whitespace
  29. PHP page redirect
  30. How do I resolve a HTTP 414 “Request URI too long” error?
  31. xajax expanding list query
  32. Data source name not found, and no default driver specified
  33. Invalid column count in CSV input on line 1 Error
  34. how to replace quotation marks with \”
  35. How do I redirect a page in jQuery?
  36. Illegal string offset Warning PHP
  37. What’s the purpose of ini_set() in php? (especially for error reporting)
  38. why use 0xffff over 65535
  39. .rar, .zip files MIME Type
  40. Send email with PHP from html form on submit with the same script
  41. Forbidden :You don’t have permission to access /phpmyadmin on this server
  42. How do I run a file on localhost?
  43. How to call a JavaScript function from PHP?
  44. Print array to a file
  45. I have a string with “\u00a0”, and I need to replace it with “” str_replace fails
  46. Finding the number of days between two dates
  47. Trying to get property of non-object in
  48. CURL ERROR: Recv failure: Connection reset by peer – PHP Curl
  49. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  50. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  51. “Cannot send session cache limiter – headers already sent”
  52. Unable to locate package libapache2-mod-php7
  53. How to find the date of a day of the week from a date using PHP?
  54. PHP multidimensional array search by value
  55. Trying to get property of non-object – Laravel 5
  56. nginx: connect() failed (111: Connection refused) while connecting to upstream – after update nginx –
  57. PHP get domain name
  58. ‘xmlParseEntityRef: no name’ warnings while loading xml into a php file
  59. Convert a date format in PHP
  60. Get user role by ID WordPress
  61. How to fix syntax error, unexpected T_IF error in php?
  62. How can I capture the result of var_dump to a string?
  63. Is Angularjs Clientside or Serverside or Both
  64. Laravel 5 Class ‘Collective\Html\HtmlServiceProvider’ not found on AWS
  65. MySQL query to get column names?
  66. Fatal error: Out of memory, but I do have plenty of memory (PHP)
  67. Changing permissions via chmod at runtime errors with “Operation not permitted”
  68. php – How do I fix this illegal offset type error
  69. Getting ’ instead of an apostrophe(‘) in PHP
  70. WooCommerce action hooks and overriding templates
  71. Updating php version on mac
  72. How to send a GET request from PHP?
  73. Unzip a file with php
  74. Difference between require, include, require_once and include_once?
  75. What does the PHP error message “Notice: Use of undefined constant” mean?
  76. select * from table where column = value ^ column2= value
  77. Why I get “ERR_RESPONSE_HEADERS_TOO_BIG” on chrome?
  78. How to write a link like which link to the same page in PHP?
  79. Laravel – Model Class not found
  80. Download files from server php
  81. No query results for model [App\Products] Laravel
  82. Sending POST data without form
  83. Resetting MySQL Root Password with XAMPP on Localhost
  84. PHP – syntax error, unexpected T_CONSTANT_ENCAPSED_STRING
  85. How can I force users to access my page over HTTPS instead of HTTP?
  86. How to install a specific version of package using Composer?
  87. A non well formed numeric value encountered
  88. Getting a 500 Internal Server Error on Laravel 5+ Ubuntu 14.04
  89. Access PHP variable in JavaScript
  90. PHP Multiple Checkbox Array
  91. Session variables not working php
  92. PHP Warning: PHP Startup: Unable to load dynamic library
  93. Do I need a !DOCTYPE declaration in a php file with html?
  94. Get JSON object from URL
  95. How to push both value and key into PHP array
  96. Find the last element of an array while using a foreach loop in PHP
  97. Popup window in PHP?
  98. How can you use php in a javascript function
  99. How to bypass (deprecated) reCAPTCHA V1?
  100. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2

Leave a Comment