Hi, I would like to know is there a way to see the results of the last query that returned at least a row using phpMyAdmin. In import.php line 605 there is condition to check for this situation but I can't find the way to generate this situation to check it.
Regards Supun.
Le 2013-07-23 12:58, Supun Nakandala a écrit :
Hi, I would like to know is there a way to see the results of the last query that returned at least a row using phpMyAdmin. In import.php line 605 there is condition to check for this situation but I can't find the way to generate this situation to check it.
Regards Supun.
Supun, I'm not sure that this logic works, even in the QA_4_0 and QA_3_5 branches. I tried to force a value in $last_query_with_results by feeding it a query such as "select * from film", then imported another file.
I was not able to see the results of the query I forced.
Maybe another developer can give some insight.
On Tue, Jul 23, 2013 at 10:28 PM, Supun Nakandala <supun.nakandala@gmail.com
wrote:
Hi, I would like to know is there a way to see the results of the last query that returned at least a row using phpMyAdmin. In import.php line 605 there is condition to check for this situation but I can't find the way to generate this situation to check it.
Supun,
Looking at the relevant code, the feature looks unimportant to me. I couldn't figure out how to reproduce it in normal working scenario. But, if you just need to see the relevant code working, put the following at line 93 in 'import.lib.php'
$import_run_buffer = array('sql' => "SELECT * FROM city", 'full' => "SELECT * FROM city");
go to 'sql' tab and run any query, but you will see the full result of "SELECT * FROM city", which ought to be the last query with results as you have put it manually.