DataexportController::doDefault() - Code Metrics - Inspection of "- Fixes falsy values displayed as NULL (#196)." - HuasoFoundries/phpPgAdmin6 - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 5397c5...a7725b )

by Felipe

created 2018-05-30 00:27 UTC

DataexportController::doDefault() C

↳ Parent: DataexportController

Complexity

Conditions	8
Paths	32

Size

Total Lines	52
Code Lines	39

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	52
rs	6.8493
c	0
b	0
f	0
cc	8
eloc	39
nc	32
nop	1

How to fix Long Method

<?php

/**
 * PHPPgAdmin v6.0.0-beta.46
 */

namespace PHPPgAdmin\Controller;

/**
 * Base controller class.
 *
 * @package PHPPgAdmin
 */
class DataexportController extends BaseController
{
    public $extensions = [
        'sql'  => 'sql',
        'copy' => 'sql',
        'csv'  => 'csv',
        'tab'  => 'txt',
        'html' => 'html',
        'xml'  => 'xml',
    ];
    public $controller_title = 'strexport';

    /**
     * Default method to render the controller according to the action parameter.
     */
    public function render()
    {
        set_time_limit(0);

        // if (!isset($_REQUEST['table']) && !isset($_REQUEST['query']))
        // What must we do in this case? Maybe redirect to the homepage?

        $format = 'N/A';
        // If format is set, then perform the export
        if (!isset($_REQUEST['what'])) {
            return $this->doDefault();
        }

        $this->prtrace("REQUEST['what']", $_REQUEST['what']);

        // Include application functions
        $this->setNoOutput(true);
        $clean = false;
        $oids  = false;
        switch ($_REQUEST['what']) {
            case 'dataonly':
                // Check to see if they have pg_dump set up and if they do, use that
                // instead of custom dump code
                if ($this->misc->isDumpEnabled() && ('copy' == $_REQUEST['d_format'] || 'sql' == $_REQUEST['d_format'])) {
                    $this->prtrace('DUMP ENABLED, d_format is', $_REQUEST['d_format']);
                    $dbexport_controller = new \PHPPgAdmin\Controller\DbexportController($this->getContainer());

                    return $dbexport_controller->render();
                }
                $this->prtrace('d_format is', $_REQUEST['d_format'], 'd_oids is', isset($_REQUEST['d_oids']));
                $format = $_REQUEST['d_format'];
                $oids   = isset($_REQUEST['d_oids']);

                break;
            case 'structureonly':
                // Check to see if they have pg_dump set up and if they do, use that
                // instead of custom dump code
                if ($this->misc->isDumpEnabled()) {
                    $dbexport_controller = new \PHPPgAdmin\Controller\DbexportController($this->getContainer());

                    return $dbexport_controller->render();
                }
                $clean = isset($_REQUEST['s_clean']);

                break;
            case 'structureanddata':
                // Check to see if they have pg_dump set up and if they do, use that
                // instead of custom dump code
                if ($this->misc->isDumpEnabled()) {
                    $dbexport_controller = new \PHPPgAdmin\Controller\DbexportController($this->getContainer());

                    return $dbexport_controller->render();
                }
                $format = $_REQUEST['sd_format'];
                $clean  = isset($_REQUEST['sd_clean']);
                $oids   = isset($_REQUEST['sd_oids']);

                break;
        }

        return $this->mimicDumpFeature($format, $clean, $oids);
    }

    protected function mimicDumpFeature($format, $clean, $oids)
    {
        $data = $this->misc->getDatabaseAccessor();

        set_time_limit(0);

        // if (!isset($_REQUEST['table']) && !isset($_REQUEST['query']))
        // What must we do in this case? Maybe redirect to the homepage?

        $format = 'N/A';
        // If format is set, then perform the export
        if (!isset($_REQUEST['what'])) {
            return $this->doDefault();
        }

        $this->prtrace("REQUEST['what']", $_REQUEST['what']);

        // Include application functions
        $this->setNoOutput(true);
        $clean    = false;
        $response = $this
            ->container
            ->responseobj;

        // Make it do a download, if necessary
        if ('download' == $_REQUEST['output']) {
            // Set headers.  MSIE is totally broken for SSL downloading, so
            // we need to have it download in-place as plain text
            if (strstr($_SERVER['HTTP_USER_AGENT'], 'MSIE') && isset($_SERVER['HTTPS'])) {
                $response = $response
                    ->withHeader('Content-type', 'text/plain');
            } else {
                $response = $response
                    ->withHeader('Content-type', 'application/download');

                if (isset($this->extensions[$format])) {
                    $ext = $this->extensions[$format];
                } else {
                    $ext = 'txt';
                }
                $response = $response
                    ->withHeader('Content-Disposition', 'attachment; filename=dump.'.$ext);
            }
        } else {
            $response = $response
                ->withHeader('Content-type', 'text/plain');
        }

        if (isset($_REQUEST['query'])) {
            $_REQUEST['query'] = trim(urldecode($_REQUEST['query']));
        }

        // Set the schema search path
        if (isset($_REQUEST['search_path'])) {
            $data->setSearchPath(array_map('trim', explode(',', $_REQUEST['search_path'])));
        }

        $subject = $this->coalesceArr($_REQUEST, 'subject', 'table')['subject'];

        $object = $this->coalesceArr($_REQUEST, $subject)[$subject];

        // Set up the dump transaction
        $status = $data->beginDump();
        $this->prtrace('subject', $subject);
        $this->prtrace('object', $object);

        // If the dump is not dataonly then dump the structure prefix
        if ('dataonly' != $_REQUEST['what']) {
            $tabledefprefix = $data->getTableDefPrefix($object, $clean);
            $this->prtrace('tabledefprefix', $tabledefprefix);
            echo $tabledefprefix;
        }

        // If the dump is not structureonly then dump the actual data
        if ('structureonly' != $_REQUEST['what']) {
            // Get database encoding
            $dbEncoding = $data->getDatabaseEncoding();


            // Set fetch mode to NUM so that duplicate field names are properly returned
            $data->conn->setFetchMode(ADODB_FETCH_NUM);

            // Execute the query, if set, otherwise grab all rows from the table
            if ($object) {
                $rs = $data->dumpRelation($object, $oids);
            } else {
                $rs = $data->conn->Execute($_REQUEST['query']);
            }
            $this->prtrace('$_REQUEST[query]', $_REQUEST['query']);

            if ('copy' == $format) {
                $data->fieldClean($object);
                echo "COPY \"{$_REQUEST['table']}\"";
                if ($oids) {
                    echo ' WITH OIDS';
                }

                echo " FROM stdin;\n";
                while (!$rs->EOF) {
                    $first = true;
                    //while (list($k, $v) = each($rs->fields)) {
                    foreach ($rs->fields as $k => $v) {
                        // Escape value
                        $v = $data->escapeBytea($v);

                        // We add an extra escaping slash onto octal encoded characters
                        $v = preg_replace('/\\\\([0-7]{3})/', '\\\\\1', $v);
                        if ($first) {
                            echo (is_null($v)) ? '\\N' : $v;
                            $first = false;
                        } else {
                            echo "\t", (is_null($v)) ? '\\N' : $v;
                        }
                    }
                    echo "\n";
                    $rs->moveNext();
                }
                echo "\\.\n";
            } elseif ('html' == $format) {
                echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n";
                echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n";
                echo "<head>\r\n";
                echo "\t<title></title>\r\n";
                echo "\t<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n";
                echo "</head>\r\n";
                echo "<body>\r\n";
                echo "<table class=\"phppgadmin\">\r\n";
                echo "\t<tr>\r\n";
                if (!$rs->EOF) {
                    // Output header row
                    $j = 0;
                    foreach ($rs->fields as $k => $v) {
                        $finfo = $rs->fetchField($j++);
                        if ($finfo->name == $data->id && !$oids) {
                            continue;
                        }

                        echo "\t\t<th>", $this->misc->printVal($finfo->name, true), "</th>\r\n";
                    }
                }
                echo "\t</tr>\r\n";
                while (!$rs->EOF) {
                    echo "\t<tr>\r\n";
                    $j = 0;
                    foreach ($rs->fields as $k => $v) {
                        $finfo = $rs->fetchField($j++);
                        if ($finfo->name == $data->id && !$oids) {
                            continue;
                        }

                        echo "\t\t<td>", $this->misc->printVal($v, true, $finfo->type), "</td>\r\n";
                    }
                    echo "\t</tr>\r\n";
                    $rs->moveNext();
                }
                echo "</table>\r\n";
                echo "</body>\r\n";
                echo "</html>\r\n";
            } elseif ('xml' == $format) {
                echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n";
                echo "<data>\n";
                if (!$rs->EOF) {
                    // Output header row
                    $j = 0;
                    echo "\t<header>\n";
                    foreach ($rs->fields as $k => $v) {
                        $finfo = $rs->fetchField($j++);
                        $name  = htmlspecialchars($finfo->name);
                        $type  = htmlspecialchars($finfo->type);
                        echo "\t\t<column name=\"{$name}\" type=\"{$type}\" />\n";
                    }
                    echo "\t</header>\n";
                }
                echo "\t<records>\n";
                while (!$rs->EOF) {
                    $j = 0;
                    echo "\t\t<row>\n";
                    foreach ($rs->fields as $k => $v) {
                        $finfo = $rs->fetchField($j++);
                        $name  = htmlspecialchars($finfo->name);
                        if (!is_null($v)) {
                            $v = htmlspecialchars($v);
                        }

                        echo "\t\t\t<column name=\"{$name}\"", (is_null($v) ? ' null="null"' : ''), ">{$v}</column>\n";
                    }
                    echo "\t\t</row>\n";
                    $rs->moveNext();
                }
                echo "\t</records>\n";
                echo "</data>\n";
            } elseif ('sql' == $format) {
                $data->fieldClean($object);
                while (!$rs->EOF) {
                    echo "INSERT INTO \"{$object}\" (";
                    $first = true;
                    $j     = 0;
                    foreach ($rs->fields as $k => $v) {
                        $finfo = $rs->fetchField($j++);
                        $k     = $finfo->name;
                        // SQL (INSERT) format cannot handle oids
                        //                        if ($k == $data->id) continue;
                        // Output field
                        $data->fieldClean($k);
                        if ($first) {
                            echo "\"{$k}\"";
                        } else {
                            echo ", \"{$k}\"";
                        }

                        if (!is_null($v)) {
                            // Output value
                            // addCSlashes converts all weird ASCII characters to octal representation,
                            // EXCEPT the 'special' ones like \r \n \t, etc.
                            $v = addcslashes($v, "\0..\37\177..\377");
                            // We add an extra escaping slash onto octal encoded characters
                            $v = preg_replace('/\\\\([0-7]{3})/', '\\\1', $v);
                            // Finally, escape all apostrophes
                            $v = str_replace("'", "''", $v);
                        }
                        if ($first) {
                            $values = (is_null($v) ? 'NULL' : "'{$v}'");
                            $first  = false;
                        } else {
                            $values .= ', '.((is_null($v) ? 'NULL' : "'{$v}'"));

                        }
                    }
                    echo ") VALUES ({$values});\n";
                    $rs->moveNext();
                }
            } else {
                switch ($format) {
                    case 'tab':
                        $sep = "\t";

                        break;
                    case 'csv':
                    default:
                        $sep = ',';

                        break;
                }
                if (!$rs->EOF) {
                    // Output header row
                    $first = true;
                    foreach ($rs->fields as $k => $v) {
                        $finfo = $rs->fetchField($k);
                        $v     = $finfo->name;
                        if (!is_null($v)) {
                            $v = str_replace('"', '""', $v);
                        }

                        if ($first) {
                            echo "\"{$v}\"";
                            $first = false;
                        } else {
                            echo "{$sep}\"{$v}\"";
                        }
                    }
                    echo "\r\n";
                }
                while (!$rs->EOF) {
                    $first = true;
                    foreach ($rs->fields as $k => $v) {
                        if (!is_null($v)) {
                            $v = str_replace('"', '""', $v);
                        }

                        if ($first) {
                            echo (is_null($v)) ? '"\\N"' : "\"{$v}\"";
                            $first = false;
                        } else {
                            echo is_null($v) ? "{$sep}\"\\N\"" : "{$sep}\"{$v}\"";
                        }
                    }
                    echo "\r\n";
                    $rs->moveNext();
                }
            }
        }

        // If the dump is not dataonly then dump the structure suffix
        if ('dataonly' != $_REQUEST['what']) {
            // Set fetch mode back to ASSOC for the table suffix to work
            $data->conn->setFetchMode(ADODB_FETCH_ASSOC);
            $tabledefsuffix = $data->getTableDefSuffix($object);
            $this->prtrace('tabledefsuffix', $tabledefsuffix);
            echo $tabledefsuffix;
        }

        // Finish the dump transaction
        $status = $data->endDump();

        return $response;
    }

    public function doDefault($msg = '')
    {
        if (!isset($_REQUEST['query']) || empty($_REQUEST['query'])) {
            $_REQUEST['query'] = $_SESSION['sqlquery'];
        }

        $this->printHeader();
        $this->printBody();
        $this->printTrail(isset($_REQUEST['subject']) ? $_REQUEST['subject'] : 'database');
        $this->printTitle($this->lang['strexport']);
        if (isset($msg)) {
            $this->printMsg($msg);
        }

        echo '<form action="'.\SUBFOLDER."/src/views/dataexport\" method=\"post\">\n";
        echo "<table>\n";
        echo "<tr><th class=\"data\">{$this->lang['strformat']}:</th><td><select name=\"d_format\">\n";
        // COPY and SQL require a table
        if (isset($_REQUEST['table'])) {
            echo "<option value=\"copy\">COPY</option>\n";
            echo "<option value=\"sql\">SQL</option>\n";
        }
        echo "<option value=\"csv\">CSV</option>\n";
        echo "<option value=\"tab\">{$this->lang['strtabbed']}</option>\n";
        echo "<option value=\"html\">XHTML</option>\n";
        echo "<option value=\"xml\">XML</option>\n";
        echo '</select></td></tr>';
        echo "</table>\n";

        echo "<h3>{$this->lang['stroptions']}</h3>\n";
        echo "<p><input type=\"radio\" id=\"output1\" name=\"output\" value=\"show\" checked=\"checked\" /><label for=\"output1\">{$this->lang['strshow']}</label>\n";
        echo "<br/><input type=\"radio\" id=\"output2\" name=\"output\" value=\"download\" /><label for=\"output2\">{$this->lang['strdownload']}</label></p>\n";

        echo "<p><input type=\"hidden\" name=\"action\" value=\"export\" />\n";
        echo "<input type=\"hidden\" name=\"what\" value=\"dataonly\" />\n";
        if (isset($_REQUEST['table'])) {
            echo '<input type="hidden" name="subject" value="table" />'."\n";
            echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
        } else {
            echo '<input type="hidden" name="subject" value="table" />'."\n";
        }
        $this->prtrace('$_REQUEST[query]', $_REQUEST['query'], htmlspecialchars(urlencode($_REQUEST['query'])));
        $this->prtrace('$_SESSION[sqlquery]', $_SESSION['sqlquery'], htmlspecialchars(urlencode($_SESSION['sqlquery'])));
        echo '<input type="hidden" name="query" value="', htmlspecialchars(urlencode($_REQUEST['query'])), "\" />\n";
        if (isset($_REQUEST['search_path'])) {
            echo '<input type="hidden" name="search_path" value="', htmlspecialchars($_REQUEST['search_path']), "\" />\n";
        }
        echo $this->misc->form;
        echo "<input type=\"submit\" value=\"{$this->lang['strexport']}\" /></p>\n";
        echo "</form>\n";

        $this->printFooter();
    }
}


1			<?php
2
3			/**
4			* PHPPgAdmin v6.0.0-beta.46
5			*/
6
7			namespace PHPPgAdmin\Controller;
8
9			/**
10			* Base controller class.
11			*
12			* @package PHPPgAdmin
13			*/
14			class DataexportController extends BaseController
15			{
16			public $extensions = [
17			'sql' => 'sql',
18			'copy' => 'sql',
19			'csv' => 'csv',
20			'tab' => 'txt',
21			'html' => 'html',
22			'xml' => 'xml',
23			];
24			public $controller_title = 'strexport';
25
26			/**
27			* Default method to render the controller according to the action parameter.
28			*/
29			public function render()
30			{
31			set_time_limit(0);
32
33			// if (!isset($_REQUEST['table']) && !isset($_REQUEST['query']))
34			// What must we do in this case? Maybe redirect to the homepage?
35
36			$format = 'N/A';
37			// If format is set, then perform the export
38			if (!isset($_REQUEST['what'])) {
39			return $this->doDefault();
40			}
41
42			$this->prtrace("REQUEST['what']", $_REQUEST['what']);
43
44			// Include application functions
45			$this->setNoOutput(true);
46			$clean = false;
47			$oids = false;
48			switch ($_REQUEST['what']) {
49			case 'dataonly':
50			// Check to see if they have pg_dump set up and if they do, use that
51			// instead of custom dump code
52			if ($this->misc->isDumpEnabled() && ('copy' == $_REQUEST['d_format'] \|\| 'sql' == $_REQUEST['d_format'])) {
53			$this->prtrace('DUMP ENABLED, d_format is', $_REQUEST['d_format']);
54			$dbexport_controller = new \PHPPgAdmin\Controller\DbexportController($this->getContainer());
55
56			return $dbexport_controller->render();
57			}
58			$this->prtrace('d_format is', $_REQUEST['d_format'], 'd_oids is', isset($_REQUEST['d_oids']));
59			$format = $_REQUEST['d_format'];
60			$oids = isset($_REQUEST['d_oids']);
61
62			break;
63			case 'structureonly':
64			// Check to see if they have pg_dump set up and if they do, use that
65			// instead of custom dump code
66			if ($this->misc->isDumpEnabled()) {
67			$dbexport_controller = new \PHPPgAdmin\Controller\DbexportController($this->getContainer());
68
69			return $dbexport_controller->render();
70			}
71			$clean = isset($_REQUEST['s_clean']);
72
73			break;
74			case 'structureanddata':
75			// Check to see if they have pg_dump set up and if they do, use that
76			// instead of custom dump code
77			if ($this->misc->isDumpEnabled()) {
78			$dbexport_controller = new \PHPPgAdmin\Controller\DbexportController($this->getContainer());
79
80			return $dbexport_controller->render();
81			}
82			$format = $_REQUEST['sd_format'];
83			$clean = isset($_REQUEST['sd_clean']);
84			$oids = isset($_REQUEST['sd_oids']);
85
86			break;
87			}
88
89			return $this->mimicDumpFeature($format, $clean, $oids);
90			}
91
92			protected function mimicDumpFeature($format, $clean, $oids)
93			{
94			$data = $this->misc->getDatabaseAccessor();
95
96			set_time_limit(0);
97
98			// if (!isset($_REQUEST['table']) && !isset($_REQUEST['query']))
99			// What must we do in this case? Maybe redirect to the homepage?
100
101			$format = 'N/A';
102			// If format is set, then perform the export
103			if (!isset($_REQUEST['what'])) {
104			return $this->doDefault();
105			}
106
107			$this->prtrace("REQUEST['what']", $_REQUEST['what']);
108
109			// Include application functions
110			$this->setNoOutput(true);
111			$clean = false;
112			$response = $this
113			->container
114			->responseobj;
115
116			// Make it do a download, if necessary
117			if ('download' == $_REQUEST['output']) {
118			// Set headers. MSIE is totally broken for SSL downloading, so
119			// we need to have it download in-place as plain text
120			if (strstr($_SERVER['HTTP_USER_AGENT'], 'MSIE') && isset($_SERVER['HTTPS'])) {
121			$response = $response
122			->withHeader('Content-type', 'text/plain');
123			} else {
124			$response = $response
125			->withHeader('Content-type', 'application/download');
126
127			if (isset($this->extensions[$format])) {
128			$ext = $this->extensions[$format];
129			} else {
130			$ext = 'txt';
131			}
132			$response = $response
133			->withHeader('Content-Disposition', 'attachment; filename=dump.'.$ext);
134			}
135			} else {
136			$response = $response
137			->withHeader('Content-type', 'text/plain');
138			}
139
140			if (isset($_REQUEST['query'])) {
141			$_REQUEST['query'] = trim(urldecode($_REQUEST['query']));
142			}
143
144			// Set the schema search path
145			if (isset($_REQUEST['search_path'])) {
146			$data->setSearchPath(array_map('trim', explode(',', $_REQUEST['search_path'])));
147			}
148
149			$subject = $this->coalesceArr($_REQUEST, 'subject', 'table')['subject'];
150
151			$object = $this->coalesceArr($_REQUEST, $subject)[$subject];
152
153			// Set up the dump transaction
154			$status = $data->beginDump();
155			$this->prtrace('subject', $subject);
156			$this->prtrace('object', $object);
157
158			// If the dump is not dataonly then dump the structure prefix
159			if ('dataonly' != $_REQUEST['what']) {
160			$tabledefprefix = $data->getTableDefPrefix($object, $clean);
161			$this->prtrace('tabledefprefix', $tabledefprefix);
162			echo $tabledefprefix;
163			}
164
165			// If the dump is not structureonly then dump the actual data
166			if ('structureonly' != $_REQUEST['what']) {
167			// Get database encoding
168			$dbEncoding = $data->getDatabaseEncoding();
			1 ignored issue – show Unused Code introduced 2018-01-10 08:54 UTC by Report Bug Copy Issue Report The assignment to `$dbEncoding` is dead and can be removed. Loading history...
169
170			// Set fetch mode to NUM so that duplicate field names are properly returned
171			$data->conn->setFetchMode(ADODB_FETCH_NUM);
172
173			// Execute the query, if set, otherwise grab all rows from the table
174			if ($object) {
175			$rs = $data->dumpRelation($object, $oids);
176			} else {
177			$rs = $data->conn->Execute($_REQUEST['query']);
178			}
179			$this->prtrace('$_REQUEST[query]', $_REQUEST['query']);
180
181			if ('copy' == $format) {
182			$data->fieldClean($object);
183			echo "COPY \"{$_REQUEST['table']}\"";
184			if ($oids) {
185			echo ' WITH OIDS';
186			}
187
188			echo " FROM stdin;\n";
189			while (!$rs->EOF) {
190			$first = true;
191			//while (list($k, $v) = each($rs->fields)) {
192			foreach ($rs->fields as $k => $v) {
193			// Escape value
194			$v = $data->escapeBytea($v);
195
196			// We add an extra escaping slash onto octal encoded characters
197			$v = preg_replace('/\\\\([0-7]{3})/', '\\\\\1', $v);
198			if ($first) {
199			echo (is_null($v)) ? '\\N' : $v;
200			$first = false;
201			} else {
202			echo "\t", (is_null($v)) ? '\\N' : $v;
203			}
204			}
205			echo "\n";
206			$rs->moveNext();
207			}
208			echo "\\.\n";
209			} elseif ('html' == $format) {
210			echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n";
211			echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n";
212			echo "<head>\r\n";
213			echo "\t<title></title>\r\n";
214			echo "\t<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n";
215			echo "</head>\r\n";
216			echo "<body>\r\n";
217			echo "<table class=\"phppgadmin\">\r\n";
218			echo "\t<tr>\r\n";
219			if (!$rs->EOF) {
220			// Output header row
221			$j = 0;
222			foreach ($rs->fields as $k => $v) {
223			$finfo = $rs->fetchField($j++);
224			if ($finfo->name == $data->id && !$oids) {
225			continue;
226			}
227
228			echo "\t\t<th>", $this->misc->printVal($finfo->name, true), "</th>\r\n";
229			}
230			}
231			echo "\t</tr>\r\n";
232			while (!$rs->EOF) {
233			echo "\t<tr>\r\n";
234			$j = 0;
235			foreach ($rs->fields as $k => $v) {
236			$finfo = $rs->fetchField($j++);
237			if ($finfo->name == $data->id && !$oids) {
238			continue;
239			}
240
241			echo "\t\t<td>", $this->misc->printVal($v, true, $finfo->type), "</td>\r\n";
242			}
243			echo "\t</tr>\r\n";
244			$rs->moveNext();
245			}
246			echo "</table>\r\n";
247			echo "</body>\r\n";
248			echo "</html>\r\n";
249			} elseif ('xml' == $format) {
250			echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n";
251			echo "<data>\n";
252			if (!$rs->EOF) {
253			// Output header row
254			$j = 0;
255			echo "\t<header>\n";
256			foreach ($rs->fields as $k => $v) {
257			$finfo = $rs->fetchField($j++);
258			$name = htmlspecialchars($finfo->name);
259			$type = htmlspecialchars($finfo->type);
260			echo "\t\t<column name=\"{$name}\" type=\"{$type}\" />\n";
261			}
262			echo "\t</header>\n";
263			}
264			echo "\t<records>\n";
265			while (!$rs->EOF) {
266			$j = 0;
267			echo "\t\t<row>\n";
268			foreach ($rs->fields as $k => $v) {
269			$finfo = $rs->fetchField($j++);
270			$name = htmlspecialchars($finfo->name);
271			if (!is_null($v)) {
272			$v = htmlspecialchars($v);
273			}
274
275			echo "\t\t\t<column name=\"{$name}\"", (is_null($v) ? ' null="null"' : ''), ">{$v}</column>\n";
276			}
277			echo "\t\t</row>\n";
278			$rs->moveNext();
279			}
280			echo "\t</records>\n";
281			echo "</data>\n";
282			} elseif ('sql' == $format) {
283			$data->fieldClean($object);
284			while (!$rs->EOF) {
285			echo "INSERT INTO \"{$object}\" (";
286			$first = true;
287			$j = 0;
288			foreach ($rs->fields as $k => $v) {
289			$finfo = $rs->fetchField($j++);
290			$k = $finfo->name;
291			// SQL (INSERT) format cannot handle oids
292			// if ($k == $data->id) continue;
293			// Output field
294			$data->fieldClean($k);
295			if ($first) {
296			echo "\"{$k}\"";
297			} else {
298			echo ", \"{$k}\"";
299			}
300
301			if (!is_null($v)) {
302			// Output value
303			// addCSlashes converts all weird ASCII characters to octal representation,
304			// EXCEPT the 'special' ones like \r \n \t, etc.
305			$v = addcslashes($v, "\0..\37\177..\377");
306			// We add an extra escaping slash onto octal encoded characters
307			$v = preg_replace('/\\\\([0-7]{3})/', '\\\1', $v);
308			// Finally, escape all apostrophes
309			$v = str_replace("'", "''", $v);
310			}
311			if ($first) {
312			$values = (is_null($v) ? 'NULL' : "'{$v}'");
313			$first = false;
314			} else {
315			$values .= ', '.((is_null($v) ? 'NULL' : "'{$v}'"));
			0 ignored issues – show Comprehensibility Best Practice introduced 2018-01-10 08:54 UTC by Report Bug Copy Issue Report The variable `$values` does not seem to be defined for all execution paths leading up to this point. Loading history...
316			}
317			}
318			echo ") VALUES ({$values});\n";
319			$rs->moveNext();
320			}
321			} else {
322			switch ($format) {
323			case 'tab':
324			$sep = "\t";
325
326			break;
327			case 'csv':
328			default:
329			$sep = ',';
330
331			break;
332			}
333			if (!$rs->EOF) {
334			// Output header row
335			$first = true;
336			foreach ($rs->fields as $k => $v) {
337			$finfo = $rs->fetchField($k);
338			$v = $finfo->name;
339			if (!is_null($v)) {
340			$v = str_replace('"', '""', $v);
341			}
342
343			if ($first) {
344			echo "\"{$v}\"";
345			$first = false;
346			} else {
347			echo "{$sep}\"{$v}\"";
348			}
349			}
350			echo "\r\n";
351			}
352			while (!$rs->EOF) {
353			$first = true;
354			foreach ($rs->fields as $k => $v) {
355			if (!is_null($v)) {
356			$v = str_replace('"', '""', $v);
357			}
358
359			if ($first) {
360			echo (is_null($v)) ? '"\\N"' : "\"{$v}\"";
361			$first = false;
362			} else {
363			echo is_null($v) ? "{$sep}\"\\N\"" : "{$sep}\"{$v}\"";
364			}
365			}
366			echo "\r\n";
367			$rs->moveNext();
368			}
369			}
370			}
371
372			// If the dump is not dataonly then dump the structure suffix
373			if ('dataonly' != $_REQUEST['what']) {
374			// Set fetch mode back to ASSOC for the table suffix to work
375			$data->conn->setFetchMode(ADODB_FETCH_ASSOC);
376			$tabledefsuffix = $data->getTableDefSuffix($object);
377			$this->prtrace('tabledefsuffix', $tabledefsuffix);
378			echo $tabledefsuffix;
379			}
380
381			// Finish the dump transaction
382			$status = $data->endDump();
383
384			return $response;
385			}
386
387			public function doDefault($msg = '')
388			{
389			if (!isset($_REQUEST['query']) \|\| empty($_REQUEST['query'])) {
390			$_REQUEST['query'] = $_SESSION['sqlquery'];
391			}
392
393			$this->printHeader();
394			$this->printBody();
395			$this->printTrail(isset($_REQUEST['subject']) ? $_REQUEST['subject'] : 'database');
396			$this->printTitle($this->lang['strexport']);
397			if (isset($msg)) {
398			$this->printMsg($msg);
399			}
400
401			echo '<form action="'.\SUBFOLDER."/src/views/dataexport\" method=\"post\">\n";
402			echo "<table>\n";
403			echo "<tr><th class=\"data\">{$this->lang['strformat']}:</th><td><select name=\"d_format\">\n";
404			// COPY and SQL require a table
405			if (isset($_REQUEST['table'])) {
406			echo "<option value=\"copy\">COPY</option>\n";
407			echo "<option value=\"sql\">SQL</option>\n";
408			}
409			echo "<option value=\"csv\">CSV</option>\n";
410			echo "<option value=\"tab\">{$this->lang['strtabbed']}</option>\n";
411			echo "<option value=\"html\">XHTML</option>\n";
412			echo "<option value=\"xml\">XML</option>\n";
413			echo '</select></td></tr>';
414			echo "</table>\n";
415
416			echo "<h3>{$this->lang['stroptions']}</h3>\n";
417			echo "<p><input type=\"radio\" id=\"output1\" name=\"output\" value=\"show\" checked=\"checked\" /><label for=\"output1\">{$this->lang['strshow']}</label>\n";
418			echo "<br/><input type=\"radio\" id=\"output2\" name=\"output\" value=\"download\" /><label for=\"output2\">{$this->lang['strdownload']}</label></p>\n";
419
420			echo "<p><input type=\"hidden\" name=\"action\" value=\"export\" />\n";
421			echo "<input type=\"hidden\" name=\"what\" value=\"dataonly\" />\n";
422			if (isset($_REQUEST['table'])) {
423			echo '<input type="hidden" name="subject" value="table" />'."\n";
424			echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
425			} else {
426			echo '<input type="hidden" name="subject" value="table" />'."\n";
427			}
428			$this->prtrace('$_REQUEST[query]', $_REQUEST['query'], htmlspecialchars(urlencode($_REQUEST['query'])));
429			$this->prtrace('$_SESSION[sqlquery]', $_SESSION['sqlquery'], htmlspecialchars(urlencode($_SESSION['sqlquery'])));
430			echo '<input type="hidden" name="query" value="', htmlspecialchars(urlencode($_REQUEST['query'])), "\" />\n";
431			if (isset($_REQUEST['search_path'])) {
432			echo '<input type="hidden" name="search_path" value="', htmlspecialchars($_REQUEST['search_path']), "\" />\n";
433			}
434			echo $this->misc->form;
435			echo "<input type=\"submit\" value=\"{$this->lang['strexport']}\" /></p>\n";
436			echo "</form>\n";
437
438			$this->printFooter();
439			}
440			}
441

HuasoFoundries / phpPgAdmin6

Push — master ( 5397c5...a7725b )

DataexportController::doDefault() C

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like