mysql_query only with link identifier

[icelandic]

Hello All,

 

I want mysql_query to result in an warning/error if the link identifier from the mysql_connect is NOT used in the MySQL query.

 

Example:

$conn = mysql_connect("localhost", "username", "password");
mysql_select_db("dbname", $conn);

$result = mysql_query("SELECT * FROM tablename', $conn);  //No error
$result = mysql_query("SELECT * FROM tablename');  //Could not connect to db error

 

I'm working with objects and only want to be able to query inside the object, but for some reason, the connection stays open outside the object.

 

Any ideas?

[mikesta707]

make your own function

<?php
function my_mysql_query($query, $link){
if (empty($link) && !isset($link)){
die("NO");
}
mysql_query($query, $link);
}
?>

 

[icelandic]

The problem I'm trying to solve is keeping the connection in the $conn variable, not in the open.  Even if I make my own function, another developer can write:

 

$result = mysql_query("SELECT * FROM tablename'); 

 

outside the object and would have access to the connection. 

[icelandic]

*bump

[icelandic]

*another bump

[mikesta707]

I don't think you can change the built in functions that PHP has. if you don't want to give access to your connection to anyone, you can close your connection after every query, but the mysql_query function will always have a default value for the link variable