{"action":"opened","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11741","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11741/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11741/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11741/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11741","id":121872378,"number":11741,"title":"Execute statement only returns result count","user":{"login":"ibennetch","id":1443710,"avatar_url":"https://avatars.githubusercontent.com/u/1443710?v=3","gravatar_id":"","url":"https://api.github.com/users/ibennetch","html_url":"https://github.com/ibennetch","followers_url":"https://api.github.com/users/ibennetch/followers","following_url":"https://api.github.com/users/ibennetch/following{/other_user}","gists_url":"https://api.github.com/users/ibennetch/gists{/gist_id}","starred_url":"https://api.github.com/users/ibennetch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ibennetch/subscriptions","organizations_url":"https://api.github.com/users/ibennetch/orgs","repos_url":"https://api.github.com/users/ibennetch/repos","events_url":"https://api.github.com/users/ibennetch/events{/privacy}","received_events_url":"https://api.github.com/users/ibennetch/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-12-12T19:06:05Z","updated_at":"2015-12-12T19:06:05Z","closed_at":null,"body":"I see two related reports on Stackoverflow about phpMyAdmin not properly handling results from a prepared statement (instead of the results, we give a count of results).\r\n\r\n* http://stackoverflow.com/questions/29240965/phpmyadmin-execute-stmt-only-returns-rows\r\n* http://stackoverflow.com/questions/34201964/no-results-in-phpmyadmin\r\n\r\nFor a sample statement, we can see http://dev.mysql.com/doc/refman/5.7/en/sql-syntax-prepared-statements.html\r\n\r\n<pre>\r\nmysql> PREPARE stmt1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';\r\nmysql> SET @a = 3;\r\nmysql> SET @b = 4;\r\nmysql> EXECUTE stmt1 USING @a, @b;\r\n+------------+\r\n| hypotenuse |\r\n+------------+\r\n|          5 |\r\n+------------+\r\nmysql> DEALLOCATE PREPARE stmt1;\r\n</pre>"}}