Add Export SQL option for a raw query

[williamdes]

Describe the bug

Execute

select 1 a union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 union all 
select 1 

Go to export below results
No sql option on export page ..

Similar to #14775

[adityasanil]

I face this issue literally everyday and would like to fix this.

[williamdes]

@adityasanil Yes, go ahead, you can open a pull-request if you find how to solve the issue!
I will help you if you need :)

[josemmo]

For anyone trying to fix this, the bug seems to be related to the "single_table" parameter.

ExportSql.php will only initialize itself if the following conditions are met:

phpmyadmin/libraries/classes/Plugins/Export/ExportSql.php

Lines 72 to 81 in 1303def

	$hide_sql = false;
	$hide_structure = false;
	if ($plugin_param['export_type'] == 'table'
	&& ! $plugin_param['single_table']
	) {
	$hide_structure = true;
	$hide_sql = true;
	}
	if (! $hide_sql) {

But "single_table" is never set to true when executing the given query as Query::getAll can't find any tables (see line 4940):

phpmyadmin/libraries/classes/Display/Results.php

Lines 4935 to 4942 in 4d9da96

	if (($analyzed_sql_results['querytype'] == self::QUERY_TYPE_SELECT)
	&& ! isset($printview)
	&& empty($analyzed_sql_results['procedure'])
	) {
	if (count($analyzed_sql_results['select_tables']) == 1) {
	$_url_params['single_table'] = 'true';
	}

---

Anyway, the export neither works as expected when choosing other options (e.g. XML) as it incorrectly assumes we're working on the first table of the current database instead of the one from the query.

[amarjitsingh52922]

@williamdes is anyone working on this issue? if not i would like to work on it

[williamdes]

@amarjitsingh52922 You can work on this issue, would be great if you find a fix !

[saurass]

@williamdes @ibennetch I have done some work related to this, I am opening a PR here for further help and improvements : )