Uncaught Error: Call to undefined function mysql_escape_string()

To help you out here… (too long for a comment)

Your require("config.php"); should contain the following:

Sidenote: Use the proper settings for your host.

$link = mysqli_connect("localhost", "username", "mpassword", "database") or die($link);

Then changing your escape functions to use the mysqli_ version of it and passing the connection parameter to it:

$name = mysqli_real_escape_string($link, $_POST['name']);
$lname = mysqli_real_escape_string($link, $_POST['lname']);
$uname = mysqli_real_escape_string($link, $_POST['uname']);
$email1 = mysqli_real_escape_string($link, $email1);
$email2 = mysqli_real_escape_string($link, $email2);
$pass1 = mysqli_real_escape_string($link, $pass1);
$pass2 = mysqli_real_escape_string($link, $pass2);

Again, same thing for the query. Using the i version and passing connection to it as the first parameter.

mysqli_query($link, "INSERT INTO ...

Check for errors on your query using mysqli_error($link);

So you could modify the query to read as

$query = mysqli_query($link, "INSERT INTO ...

and doing

if(!$query){
   echo "Error: " . mysqli_error($link);
   }

Also read the following on Stack in regards to API mixing:

  • Can I mix MySQL APIs in PHP?
  • You can’t. mysql_ with mysqli_ or PDO etc. do NOT intermix together. You must use the same one from connecting to querying.

Footnotes.

Passwords

I also noticed that you may be storing passwords in plain text. This is not recommended. If you intend on going LIVE with this at some point, do NOT store passwords as plain text in your database.

Consult the following.

Other links:

Related Posts:

  1. How to log in to phpMyAdmin with WAMP, what is the username and password?
  2. Array to String PHP?
  3. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  4. Fatal error: Call to undefined function mysql_connect()
  5. PDOException SQLSTATE[HY000] [2002] No such file or directory
  6. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  7. PDOException SQLSTATE[HY000] [2002] No such file or directory
  8. Mysql query- How to use contains?
  9. How do I check if a string contains a specific word?
  10. Deprecated: mysql_connect()
  11. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  12. Invalid column count in CSV input on line 1 Error
  13. Invalid column count in CSV input on line 1 Error
  14. how to replace quotation marks with \”
  15. PHP random string generator
  16. Is a new line = \n OR \r\n?
  17. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  18. PDO with INSERT INTO through prepared statements
  19. phpMyAdmin: secret passphrase?
  20. PDO bindParam() with prepared statement isn’t working
  21. Mixing a PHP variable with a string literal
  22. Forbidden :You don’t have permission to access /phpmyadmin on this server
  23. Converting string to Date and DateTime
  24. Creating a search form in PHP to search a database?
  25. How can I do ‘insert if not exists’ in MySQL?
  26. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  27. PHP: variables in strings without concatenation
  28. MySqli Commands out of sync; you can’t run this command now
  29. Trying to get property of non-object in
  30. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  31. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  32. Multi-line strings in PHP
  33. Commands out of sync; you can’t run this command now
  34. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  35. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  36. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  37. How can I do ‘insert if not exists’ in MySQL?
  38. Object of class DateTime could not be converted to string
  39. What does it mean to escape a string?
  40. Convert from MySQL datetime to another format with PHP
  41. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  42. mysqli::query(): Couldn’t fetch mysqli
  43. Php include not working? function not being included
  44. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  45. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  46. Call to a member function on null?
  47. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  48. How can I capture the result of var_dump to a string?
  49. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  50. MySQL query to get column names?
  51. What does MYSQLI_NUM mean and do?
  52. How to convert string to boolean php
  53. Mysql where id is in array
  54. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  55. What is the advantage of using try {} catch {} versus if {} else {}
  56. select * from table where column = value ^ column2= value
  57. Check if URL has certain string with PHP
  58. Deprecated: mysql_query() [duplicate]
  59. Limit String Length
  60. No query results for model [App\Products] Laravel
  61. Fatal error: Call to a member function query() on null
  62. mysqlworkbench giving version error on exporting database
  63. How to make DROP INDEX IF EXISTS for mysql?
  64. What is the meaning of sprintf(): Too few arguments
  65. Having a problem getting mysqli_query to execute
  66. Insert string at specified position
  67. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  68. How to run a PHP function from an HTML form?
  69. Can I store images in MySQL 
  70. MySQL Daemon Failed to Start – centos 6
  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. PHP Call to undefined function
  76. How to use Memcached with PHP7?
  77. Remove empty array elements
  78. select count(*) from table of mysql in php
  79. How can you use php in a javascript function
  80. 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
  81. Cannot use object of type stdClass as array?
  82. mysqli_real_connect(): (HY000/2002): No such file or directory
  83. Deleting an element from an array in PHP
  84. Cannot simply use PostgreSQL table name (“relation does not exist”)
  85. How do I expire a PHP session after 30 minutes?
  86. In_array not working
  87. PHP Fatal error: Call to undefined function mssql_connect()
  88. how to ping ip addresses in php and give results
  89. do_shortcode not working
  90. How to extract and access data from JSON with PHP?
  91. How to convert array to SimpleXML
  92. WordPress query single post by slug
  93. Paypal IPN Verification Postback with HTTPS
  94. cannot change admin password, wordpress on godaddy
  95. How to cache/speed WordPress queries for logged in users?
  96. $wpdb->delete column values IN ARRAY()?
  97. Use variable in SQL statement
  98. PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  99. WordPress WPDB::insert 13th param is always blank (only if format)
  100. MySQL query in WordPress with AJAX

tech