Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?

Possible Duplicate:
mysql_escape_string VS mysql_real_escape_string

I need to get company_name (given by user through a form) entered into my mysql database. When I use

$company = mysqli_real_escape_string($_POST['company_name'])

I get an error

Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given in     /opt/lampp/htdocs/Abacus-Version-2/admin/Company/insert_company.php on line 58

But everything seems to fine while using

$company = mysql_real_escape_string($_POST['company_name'])

What can I do in such cases?

Related Posts:

  1. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  2. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  3. MySqli Commands out of sync; you can’t run this command now
  4. Commands out of sync; you can’t run this command now
  5. mysqli::query(): Couldn’t fetch mysqli
  6. Deprecated: mysql_query() [duplicate]
  7. Having a problem getting mysqli_query to execute
  8. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  9. How to use mysqli_query() in PHP?
  10. How to log in to phpMyAdmin with WAMP, what is the username and password?
  11. Fatal error: Call to undefined function mysql_connect()
  12. PDOException SQLSTATE[HY000] [2002] No such file or directory
  13. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  14. PDOException SQLSTATE[HY000] [2002] No such file or directory
  15. Mysql query- How to use contains?
  16. Invalid column count in CSV input on line 1 Error
  17. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
  18. Invalid column count in CSV input on line 1 Error
  19. mysqli_real_connect(): (HY000/2002): No such file or directory
  20. Fatal error: Call to undefined function mysqli_connect()
  21. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  22. PDO with INSERT INTO through prepared statements
  23. phpMyAdmin: secret passphrase?
  24. PDO bindParam() with prepared statement isn’t working
  25. Forbidden :You don’t have permission to access /phpmyadmin on this server
  26. mysqli_real_connect(): (HY000/2002): No such file or directory
  27. Fatal error: Call to undefined function mysqli_connect()
  28. Creating a search form in PHP to search a database?
  29. How can I do ‘insert if not exists’ in MySQL?
  30. Trying to get property of non-object in
  31. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  32. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  33. Call to undefined method mysqli_stmt::get_result
  34. Call to undefined method mysqli_stmt::get_result
  35. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  36. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  37. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  38. How can I do ‘insert if not exists’ in MySQL?
  39. Fatal error: Cannot use object of type mysqli_result
  40. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  41. mysql_field_name to the new mysqli
  42. Object of class DateTime could not be converted to string
  43. What does it mean to escape a string?
  44. Convert from MySQL datetime to another format with PHP
  45. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  46. mysqli_select_db() expects parameter 1 to be mysqli, string given
  47. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  48. Uncaught Error: Call to undefined function mysql_escape_string()
  49. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  50. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  51. Call to a member function on null?
  52. Warning: mysqli_query() expects at least 2 parameters, 1 given. What? [duplicate]
  53. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  54. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  55. MySQL query to get column names?
  56. What does MYSQLI_NUM mean and do?
  57. Mysql where id is in array
  58. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  59. What is the advantage of using try {} catch {} versus if {} else {}
  60. select * from table where column = value ^ column2= value
  61. Object of class mysqli_result could not be converted to string
  62. No query results for model [App\Products] Laravel
  63. Fatal error: Call to a member function fetch_assoc() on a non-object
  64. Fatal error: Call to a member function query() on null
  65. mysqlworkbench giving version error on exporting database
  66. How to make DROP INDEX IF EXISTS for mysql?
  67. What is the meaning of sprintf(): Too few arguments
  68. Can I store images in MySQL 
  69. MySQL Daemon Failed to Start – centos 6
  70. Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given… what I do wrong? 
  71. How to insert TIMESTAMP into my MySQL table?
  72. How to remove index.php from WordPress site URL
  73. PHP Like thing similar to MySQL Like, for if statement?
  74. How get value from URL
  75. Call to a member function fetch_assoc() on boolean in [duplicate]
  76. How to use Memcached with PHP7?
  77. select count(*) from table of mysql in php
  78. PHP variables don’t evaluate in the query [duplicate]
  79. 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
  80. currently unable to handle this request HTTP ERROR 500
  81. Elegant way to search for UTF-8 files with BOM?
  82. Is SAJAX dead? What to replace with?
  83. How do I fix “Undefined variable” error in PHP?
  84. How do you parse and process HTML/XML in PHP?
  85. how to get id from URL using php
  86. “Fatal error: Cannot redeclare function”
  87. php get all url variables
  88. How to run PHP locally on MacOS
  89. Display array values in PHP
  90. Php create a file if not exists
  91. Page redirect after certain time PHP
  92. Delete post revisions on post publish
  93. How to write one comment and publish on every post using database or plugin?
  94. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  95. How to use mysql LIKE with wpdb?
  96. speed up pagination for huge database
  97. Store GA Client ID in User DB
  98. Need help with format of nested array in MySQL
  99. Site doesnt work once PHP changed to 7.1
  100. can’t delete a row from post_meta table

Leave a Comment