Warning: mysql_query(): 3 is not a valid MySQL-Link resource

by

PHP uses resources as a special variable to hold links to external objects, such as files and database connections. Each resource is given an integer id. (Documentation)

Failed Connections

If the database connection fails you’ll likely get a “Specified variable is not a valid MySQL-Link resource” error, as Dan Breen mentioned, since the variable that is supposed to hold the resource is null.

$link = mysql_connect('localsoth','baduser','badpass'); // failed connection
$result = mysql_query("SELECT 1", $link); // throws error

Since you’re getting a specific resource ID in the error message, the database connection likely closed unexpectedly for some reason. Your program still has a variable with a resource ID, but the external object no longer exists. This may be due to a mysql_close() call somewhere before the call to mysql_query, or an external database error that closed the connection.

$link = mysql_connect();
mysql_close($link);
// $link may still contain a resource identifier, but the external object is gone
mysql_query("SELECT 1", $link);

Reusing Connections

An issue with the mysql extension and mysql_connect() is that by default if you pass the same parameters in successive calls, it will re-use the existing connection rather than create a new one (Documentation). This can be fixed by passing true to the $new_link parameter.
I encountered this myself on a test system where the data from two separate databases in production were combined on to one test server, and in testing the mysql_xxx() function calls walked over each other and broke the system.

$link1 = mysql_connect('localhost','user','pass'); // resource id 1 is given
$link2 = mysql_connect('localhost','user','pass'); // resource id 1 is given again
mysql_close($link2); // the connection at resource id 1 is closed
mysql_query("SELECT 1", $link1); // will fail, since the connection was closed

Using $new_link:

$link1 = mysql_connect('localhost','user','pass'); // resource id 1 is given
$link2 = mysql_connect('localhost','user','pass', true); // resource id 2 is given
mysql_close($link2); // the connection at resource id 2 is closed
mysql_query("SELECT 1", $link1); // the connection at resource id 1 is still open

Edit:
As an aside, I would recommend using the MySQLi extension or PDO instead, if possible. The MySQL extension is getting pretty old, and can’t take advantage of any features past MySQL version 4.1.3. Look at http://www.php.net/manual/en/mysqli.overview.php for some details on the differences between the three interfaces.

More Related Contents:

  1. PHP DateTime supported formats
  2. Can I call a PHP function in a JavaScript click handler?
  3. How to create a chat program using php and mysqli for chatting [closed]
  4. 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 ‘WHERE `id` [closed]
  5. Can I store images in MySQL [duplicate]
  6. MySQL – This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery
  7. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  8. MySQL Join two tables with comma separated values
  9. iPhone emoticons insert into MySQL but become blank value
  10. Inserting into MySQL from PHP (jQuery/AJAX)
  11. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  12. How to connect to MySQL database in PHP using mysqli extension?
  13. Laravel 5.4 field doesn’t have a default value
  14. org.json.JSONException: Value
  15. PHP Check for NULL
  16. How to store .pdf files into MySQL as BLOBs using PHP?
  17. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  18. PDO MySQL: Insert multiple rows in one query
  19. Outputting all PHP errors to database not error_log
  20. Laravel nested relationships
  21. getting the value of an extra pivot table column laravel
  22. php sample script for pagination [closed]
  23. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  24. PHP Laravel: No connection could be made because the target machine actively refused it
  25. SQL Query with binary data (PHP and MySQL)
  26. How do I format numbers to have only two decimal places?
  27. How to get last inserted id from table MySQL [duplicate]
  28. Group mysql results by category and display them into groups under each category
  29. Save array in mysql database
  30. PHP & mySQL: When exactly to use htmlentities?

Leave a Comment