How can the error message "Warning: mysql_query() expects parameter 1 to be string, resource given" be resolved in PHP code?

The error message "Warning: mysql_query() expects parameter 1 to be string, resource given" occurs when the mysql_query() function is expecting a string parameter, but a resource is being passed instead. To resolve this issue, you need to ensure that the first parameter passed to mysql_query() is a valid SQL query string. Here is a PHP code snippet that demonstrates how to fix this issue by passing a string parameter to mysql_query(): 

// Establish a connection to the MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check if the connection is successful
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Define the SQL query as a string
$query = "SELECT * FROM table_name";

// Execute the SQL query using mysql_query() with the correct string parameter
$result = mysqli_query($connection, $query);

// Check if the query was successful
if ($result) {
    // Process the query result
    while ($row = mysqli_fetch_assoc($result)) {
        // Do something with the data
    }
} else {
    echo "Error: " . mysqli_error($connection);
}

// Close the database connection
mysqli_close($connection);

Keywords

mysql_query parameter string resource PHP code

Related Questions