#1627 Allow php variables in queries
phpMyAdmin is a program that allows users to manage their MySQL database(s). So why exactly is it called phpMyAdmin and not MySQLAdmin or something more relatable?
When interfacing with a MySQL database using PHP, PHP queries (mysqli_query) often require the use of PHP variables. The queries executed in the SQL window of phpMyAdmin are MySQL only, they do not contain any PHP variables. One is not a reflection of the other. There is no way of testing a mysqli_query that contains PHP variables in phpMyAdmin. You could be forgiven for thinking it was possible given its name! For those learning PHP and MySQL, phpMyAdmin would be a great learning/testing tool were it possible to integrate PHP variables into MySQL queries. No harm in asking.
Discussion
We have something similar in phpMyAdmin's bookmarks, which can contain a variable part. However, I don't get your point about using PHP variables: where would these variables be defined? I believe that your request is out of scope for our product.
At the moment I am having an issue with a php mysqli_query not returning records it should be. There are no errors, syntax or otherwise and the query works fine without a where clause which leads me to believe the issue is the data contained in the php variable ($_GET['Email']) is not being properly compared to the Email stored in the table column (varchar(50) InnoDb)). I have tested the query with where clause using both (=) and 'like' in phpMyAdmin and it works fine, yet the query in php does not. Because the two queries are not like for like because of the PHP variable(s) and syntax, I am at a loss of how to explain and solve. My only theory is a php setting interfering possibly. Your comment about scope is the basis of my request. There is to my knowledge nowhere to test a mysql/mysqli query containing php variables on an actual MySQL database, if you know of any please direct me so I can investigate further.
You can ask your question on http://stackoverflow.com, tagging it with "PHP" and "MySQL".
Already did Marc. Not getting much help there either.