mysql functions in PHP functions.

Question

For example:

<? 
function getTitle(){
    $query="SELECT title FROM news WHERE author = 'admin' LIMIT 5";
    $result = mysql_query($query, $mysql_connection);
    $data = mysql_fetch_array($result,MYSQL_ASSOC);
    return $data['title'];
}
?>

And every time I want to submit a MySql query I must always include config.php inside the function, otherwise it does not work. I tried including at the beginning of the file but still no result.

Config.php file consists of connection to the database and selection of the database. No errors there.

What seems to be the problem?

Answer 1

$mysql_connection is unknown inside the function's scope.

If you are using only one connection in your script, you could theoretically also omit the connection specifier:

$result = mysql_query($query);

That way, your mySQL calls would work without any additional steps.

If you want to keep the identifier (you should if you have multiple connections open), as a quick fix, you can use

function getTitle() 
 {
   global $mysql_connection;
   .....

 }

to import the connection into the function's scope.

An advanced (and somewhat cleaner) way is to have a Singleton or static object containing the database connection. See this question for good examples:

• What is the best method for getting a database connection/object into a function in PHP?

Answer 2

That would be because you are referencing $mysql_connection which is declared in your config.php and is now out of scope. You can omit that parameter entirely as long as you're only using one connection. Just call mysql_query($query);

Answer 3

Put the following inside your function.

global $mysql_connection;

What has happened is that your $mysql_connection variable isn't in the scope of the function.

I have encountered this same issue before also.

Answer 4

This is because $mysql_connection variable isn't visible in function body. Use

global $mysql_connection

in the beginning of the function