@@ -30,7 +30,7 @@ discard block |
||
30 | 30 | |
31 | 31 | //$this->prtrace($trail); |
32 | 32 | |
33 | - $trail_html .= '<div class="trail" data-controller="'.$this->controller_name.'"><table><tr>'; |
|
33 | + $trail_html .= '<div class="trail" data-controller="' . $this->controller_name . '"><table><tr>'; |
|
34 | 34 | |
35 | 35 | foreach ($trail as $crumb) { |
36 | 36 | $trail_html .= '<td class="crumb">'; |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | $crumblink .= "<span class=\"icon\"><img src=\"{$icon}\" alt=\"{$iconalt}\" /></span>"; |
58 | 58 | } |
59 | 59 | |
60 | - $crumblink .= '<span class="label">'.htmlspecialchars($crumb['text']).'</span></a>'; |
|
60 | + $crumblink .= '<span class="label">' . htmlspecialchars($crumb['text']) . '</span></a>'; |
|
61 | 61 | |
62 | 62 | if (isset($crumb['help'])) { |
63 | 63 | $trail_html .= $this->misc->printHelp($crumblink, $crumb['help'], false); |
@@ -157,7 +157,7 @@ discard block |
||
157 | 157 | //$this->prtrace($tabs); |
158 | 158 | |
159 | 159 | if (count($tabs) > 0) { |
160 | - $width = (int) (100 / count($tabs)).'%'; |
|
160 | + $width = (int) (100 / count($tabs)) . '%'; |
|
161 | 161 | |
162 | 162 | $viewVars = [ |
163 | 163 | 'width' => $width, |
@@ -219,15 +219,15 @@ discard block |
||
219 | 219 | $server_id = $misc->getServerId(); |
220 | 220 | $reqvars = $misc->getRequestVars('table'); |
221 | 221 | |
222 | - $topbar_html = '<div class="topbar" data-controller="'.$this->controller_name.'"><table style="width: 100%"><tr><td>'; |
|
222 | + $topbar_html = '<div class="topbar" data-controller="' . $this->controller_name . '"><table style="width: 100%"><tr><td>'; |
|
223 | 223 | |
224 | 224 | if ($server_info && isset($server_info['platform']) && isset($server_info['username'])) { |
225 | 225 | /* top left informations when connected */ |
226 | 226 | $topbar_html .= sprintf($lang['strtopbar'], |
227 | - '<span class="platform">'.htmlspecialchars($server_info['platform']).'</span>', |
|
228 | - '<span class="host">'.htmlspecialchars((empty($server_info['host'])) ? 'localhost' : $server_info['host']).'</span>', |
|
229 | - '<span class="port">'.htmlspecialchars($server_info['port']).'</span>', |
|
230 | - '<span class="username">'.htmlspecialchars($server_info['username']).'</span>'); |
|
227 | + '<span class="platform">' . htmlspecialchars($server_info['platform']) . '</span>', |
|
228 | + '<span class="host">' . htmlspecialchars((empty($server_info['host'])) ? 'localhost' : $server_info['host']) . '</span>', |
|
229 | + '<span class="port">' . htmlspecialchars($server_info['port']) . '</span>', |
|
230 | + '<span class="username">' . htmlspecialchars($server_info['username']) . '</span>'); |
|
231 | 231 | |
232 | 232 | $topbar_html .= '</td>'; |
233 | 233 | |
@@ -237,7 +237,7 @@ discard block |
||
237 | 237 | 'sql' => [ |
238 | 238 | 'attr' => [ |
239 | 239 | 'href' => [ |
240 | - 'url' => SUBFOLDER.'/src/views/sqledit', |
|
240 | + 'url' => SUBFOLDER . '/src/views/sqledit', |
|
241 | 241 | 'urlvars' => array_merge($reqvars, [ |
242 | 242 | 'action' => 'sql', |
243 | 243 | ]), |
@@ -250,7 +250,7 @@ discard block |
||
250 | 250 | 'history' => [ |
251 | 251 | 'attr' => [ |
252 | 252 | 'href' => [ |
253 | - 'url' => SUBFOLDER.'/src/views/history', |
|
253 | + 'url' => SUBFOLDER . '/src/views/history', |
|
254 | 254 | 'urlvars' => array_merge($reqvars, [ |
255 | 255 | 'action' => 'pophistory', |
256 | 256 | ]), |
@@ -262,7 +262,7 @@ discard block |
||
262 | 262 | 'find' => [ |
263 | 263 | 'attr' => [ |
264 | 264 | 'href' => [ |
265 | - 'url' => SUBFOLDER.'/src/views/sqledit', |
|
265 | + 'url' => SUBFOLDER . '/src/views/sqledit', |
|
266 | 266 | 'urlvars' => array_merge($reqvars, [ |
267 | 267 | 'action' => 'find', |
268 | 268 | ]), |
@@ -275,7 +275,7 @@ discard block |
||
275 | 275 | 'logout' => [ |
276 | 276 | 'attr' => [ |
277 | 277 | 'href' => [ |
278 | - 'url' => SUBFOLDER.'/src/views/servers', |
|
278 | + 'url' => SUBFOLDER . '/src/views/servers', |
|
279 | 279 | 'urlvars' => [ |
280 | 280 | 'action' => 'logout', |
281 | 281 | 'logoutServer' => "{$server_info['host']}:{$server_info['port']}:{$server_info['sslmode']}", |
@@ -300,8 +300,8 @@ discard block |
||
300 | 300 | |
301 | 301 | $topbar_html .= '</td>'; |
302 | 302 | |
303 | - $sql_window_id = htmlentities('sqledit:'.$server_id); |
|
304 | - $history_window_id = htmlentities('history:'.$server_id); |
|
303 | + $sql_window_id = htmlentities('sqledit:' . $server_id); |
|
304 | + $history_window_id = htmlentities('history:' . $server_id); |
|
305 | 305 | |
306 | 306 | $topbar_html .= "<script type=\"text/javascript\"> |
307 | 307 | $('#toplink_sql').click(function() { |
@@ -366,7 +366,7 @@ discard block |
||
366 | 366 | $vars = $this->misc->getSubjectParams($subject); |
367 | 367 | ksort($vars['params']); |
368 | 368 | |
369 | - return "{$vars['url']}?".http_build_query($vars['params'], '', '&'); |
|
369 | + return "{$vars['url']}?" . http_build_query($vars['params'], '', '&'); |
|
370 | 370 | } |
371 | 371 | |
372 | 372 | /** |
@@ -389,7 +389,7 @@ discard block |
||
389 | 389 | |
390 | 390 | $trail['root'] = [ |
391 | 391 | 'text' => $appName, |
392 | - 'url' => SUBFOLDER.'/src/views/servers', |
|
392 | + 'url' => SUBFOLDER . '/src/views/servers', |
|
393 | 393 | 'icon' => 'Introduction', |
394 | 394 | ]; |
395 | 395 | |
@@ -463,7 +463,7 @@ discard block |
||
463 | 463 | ]; |
464 | 464 | } elseif (isset($_REQUEST['matview']) && !$done) { |
465 | 465 | $trail['matview'] = [ |
466 | - 'title' => 'M'.$lang['strview'], |
|
466 | + 'title' => 'M' . $lang['strview'], |
|
467 | 467 | 'text' => $_REQUEST['matview'], |
468 | 468 | 'url' => $this->getHREFSubject('matview'), |
469 | 469 | 'help' => 'pg.matview', |
@@ -486,7 +486,7 @@ discard block |
||
486 | 486 | switch ($subject) { |
487 | 487 | case 'function': |
488 | 488 | $trail[$subject] = [ |
489 | - 'title' => $lang['str'.$subject], |
|
489 | + 'title' => $lang['str' . $subject], |
|
490 | 490 | 'text' => $_REQUEST[$subject], |
491 | 491 | 'url' => $this->getHREFSubject('function'), |
492 | 492 | 'help' => 'pg.function', |
@@ -525,9 +525,9 @@ discard block |
||
525 | 525 | break; |
526 | 526 | } |
527 | 527 | $trail[$subject] = [ |
528 | - 'title' => array_key_exists('str'.$subject, $lang) ? $lang['str'.$subject] : $subject, |
|
528 | + 'title' => array_key_exists('str' . $subject, $lang) ? $lang['str' . $subject] : $subject, |
|
529 | 529 | 'text' => $_REQUEST[$subject], |
530 | - 'help' => 'pg.'.$subject, |
|
530 | + 'help' => 'pg.' . $subject, |
|
531 | 531 | 'icon' => $icon, |
532 | 532 | ]; |
533 | 533 | } |
@@ -56,7 +56,7 @@ discard block |
||
56 | 56 | $footer_html .= $this->printReload(true, false); |
57 | 57 | } |
58 | 58 | if (!$this->_no_bottom_link) { |
59 | - $footer_html .= '<a data-footertemplate="'.$template.'" href="#" class="bottom_link">'.$lang['strgotoppage'].'</a>'; |
|
59 | + $footer_html .= '<a data-footertemplate="' . $template . '" href="#" class="bottom_link">' . $lang['strgotoppage'] . '</a>'; |
|
60 | 60 | } |
61 | 61 | |
62 | 62 | $footer_html .= $this->view->fetch($template); |
@@ -79,7 +79,7 @@ discard block |
||
79 | 79 | $reload = "<script type=\"text/javascript\">\n"; |
80 | 80 | //$reload .= " alert('will reload');"; |
81 | 81 | if ($database) { |
82 | - $reload .= "\tparent.frames && parent.frames.browser && parent.frames.browser.location.replace=\"".SUBFOLDER."/src/views/browser.php\";\n"; |
|
82 | + $reload .= "\tparent.frames && parent.frames.browser && parent.frames.browser.location.replace=\"" . SUBFOLDER . "/src/views/browser.php\";\n"; |
|
83 | 83 | } else { |
84 | 84 | $reload .= "\tif(parent.frames && parent.frames.browser) { console.log('will reload frame browser'); parent.frames.browser.location.reload();} else { console.log('will do location replace'); location.replace(location.href);}\n"; |
85 | 85 | //$reload .= "\tparent.frames.detail.location.href=\"".SUBFOLDER . "/src/views/intro\";\n"; |
@@ -117,7 +117,7 @@ discard block |
||
117 | 117 | { |
118 | 118 | echo "<script type=\"text/javascript\">\n"; |
119 | 119 | echo "//<![CDATA[\n"; |
120 | - echo " window.name = '{$name}", ($addServer ? ':'.htmlspecialchars($this->misc->getServerId()) : ''), "';\n"; |
|
120 | + echo " window.name = '{$name}", ($addServer ? ':' . htmlspecialchars($this->misc->getServerId()) : ''), "';\n"; |
|
121 | 121 | echo "//]]>\n"; |
122 | 122 | echo "</script>\n"; |
123 | 123 | } |
@@ -131,7 +131,7 @@ |
||
131 | 131 | } |
132 | 132 | } else { |
133 | 133 | $msg = isset($attrs['nodata']) ? $attrs['nodata'] : $lang['strnoobjects']; |
134 | - $tree_xml .= "<tree text=\"{$msg}\" onaction=\"tree.getSelected().getParent().reload()\" icon=\"".$this->misc->icon('ObjectNotFound').'" />'."\n"; |
|
134 | + $tree_xml .= "<tree text=\"{$msg}\" onaction=\"tree.getSelected().getParent().reload()\" icon=\"" . $this->misc->icon('ObjectNotFound') . '" />' . "\n"; |
|
135 | 135 | } |
136 | 136 | |
137 | 137 | $tree_xml .= "</tree>\n"; |
@@ -305,7 +305,7 @@ discard block |
||
305 | 305 | |
306 | 306 | echo '<p>', sprintf($lang['strconfdropftsconfig'], $misc->printVal($_REQUEST['ftscfg'])), "</p>\n"; |
307 | 307 | |
308 | - echo '<form action="'.SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n"; |
|
308 | + echo '<form action="' . SUBFOLDER . "/src/views/fulltext.php\" method=\"post\">\n"; |
|
309 | 309 | echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$lang['strcascade']}</label></p>\n"; |
310 | 310 | echo "<p><input type=\"hidden\" name=\"action\" value=\"dropconfig\" />\n"; |
311 | 311 | echo '<input type="hidden" name="database" value="', htmlspecialchars($_REQUEST['database']), "\" />\n"; |
@@ -338,7 +338,7 @@ discard block |
||
338 | 338 | |
339 | 339 | echo '<p>', sprintf($lang['strconfdropftsdict'], $misc->printVal($_REQUEST['ftsdict'])), "</p>\n"; |
340 | 340 | |
341 | - echo '<form action="'.SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n"; |
|
341 | + echo '<form action="' . SUBFOLDER . "/src/views/fulltext.php\" method=\"post\">\n"; |
|
342 | 342 | echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$lang['strcascade']}</label></p>\n"; |
343 | 343 | echo "<p><input type=\"hidden\" name=\"action\" value=\"dropdict\" />\n"; |
344 | 344 | echo '<input type="hidden" name="database" value="', htmlspecialchars($_REQUEST['database']), "\" />\n"; |
@@ -401,7 +401,7 @@ discard block |
||
401 | 401 | $this->printTitle($lang['strftscreateconfig'], 'pg.ftscfg.create'); |
402 | 402 | $this->printMsg($msg); |
403 | 403 | |
404 | - echo '<form action="'.SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n"; |
|
404 | + echo '<form action="' . SUBFOLDER . "/src/views/fulltext.php\" method=\"post\">\n"; |
|
405 | 405 | echo "<table>\n"; |
406 | 406 | /* conf name */ |
407 | 407 | echo "\t<tr>\n\t\t<th class=\"data left required\">{$lang['strname']}</th>\n"; |
@@ -417,7 +417,7 @@ discard block |
||
417 | 417 | while (!$ftscfgs->EOF) { |
418 | 418 | $data->fieldClean($ftscfgs->fields['schema']); |
419 | 419 | $data->fieldClean($ftscfgs->fields['name']); |
420 | - $tplname = $ftscfgs->fields['schema'].'.'.$ftscfgs->fields['name']; |
|
420 | + $tplname = $ftscfgs->fields['schema'] . '.' . $ftscfgs->fields['name']; |
|
421 | 421 | $tpls[$tplname] = serialize([ |
422 | 422 | 'name' => $ftscfgs->fields['name'], |
423 | 423 | 'schema' => $ftscfgs->fields['schema'], |
@@ -438,7 +438,7 @@ discard block |
||
438 | 438 | while (!$ftsparsers->EOF) { |
439 | 439 | $data->fieldClean($ftsparsers->fields['schema']); |
440 | 440 | $data->fieldClean($ftsparsers->fields['name']); |
441 | - $parsername = $ftsparsers->fields['schema'].'.'.$ftsparsers->fields['name']; |
|
441 | + $parsername = $ftsparsers->fields['schema'] . '.' . $ftsparsers->fields['name']; |
|
442 | 442 | |
443 | 443 | $ftsparsers_[$parsername] = serialize([ |
444 | 444 | 'parser' => $ftsparsers->fields['name'], |
@@ -548,7 +548,7 @@ discard block |
||
548 | 548 | // Fetch all FTS parsers from the database |
549 | 549 | $ftsparsers = $data->getFtsParsers(); |
550 | 550 | |
551 | - echo '<form action="'.SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n"; |
|
551 | + echo '<form action="' . SUBFOLDER . "/src/views/fulltext.php\" method=\"post\">\n"; |
|
552 | 552 | echo "<table>\n"; |
553 | 553 | |
554 | 554 | echo "\t<tr>\n"; |
@@ -861,7 +861,7 @@ discard block |
||
861 | 861 | $this->printTitle($lang['strftscreatedict'], 'pg.ftsdict.create'); |
862 | 862 | $this->printMsg($msg); |
863 | 863 | |
864 | - echo '<form action="'.SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n"; |
|
864 | + echo '<form action="' . SUBFOLDER . "/src/views/fulltext.php\" method=\"post\">\n"; |
|
865 | 865 | echo "<table>\n"; |
866 | 866 | echo "\t<tr>\n\t\t<th class=\"data left required\">{$lang['strname']}</th>\n"; |
867 | 867 | echo "\t\t<td class=\"data1\"><input name=\"formName\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"", |
@@ -877,7 +877,7 @@ discard block |
||
877 | 877 | while (!$ftstpls->EOF) { |
878 | 878 | $data->fieldClean($ftstpls->fields['schema']); |
879 | 879 | $data->fieldClean($ftstpls->fields['name']); |
880 | - $tplname = $ftstpls->fields['schema'].'.'.$ftstpls->fields['name']; |
|
880 | + $tplname = $ftstpls->fields['schema'] . '.' . $ftstpls->fields['name']; |
|
881 | 881 | $tpls[$tplname] = serialize([ |
882 | 882 | 'name' => $ftstpls->fields['name'], |
883 | 883 | 'schema' => $ftstpls->fields['schema'], |
@@ -1015,7 +1015,7 @@ discard block |
||
1015 | 1015 | $_POST['formName'] = $_REQUEST['ftsdict']; |
1016 | 1016 | } |
1017 | 1017 | |
1018 | - echo '<form action="'.SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n"; |
|
1018 | + echo '<form action="' . SUBFOLDER . "/src/views/fulltext.php\" method=\"post\">\n"; |
|
1019 | 1019 | echo "<table>\n"; |
1020 | 1020 | |
1021 | 1021 | echo "\t<tr>\n"; |
@@ -1088,7 +1088,7 @@ discard block |
||
1088 | 1088 | $this->printTrail('ftscfg'); // TODO: proper breadcrumbs |
1089 | 1089 | $this->printTitle($lang['strdrop'], 'pg.ftscfg.alter'); |
1090 | 1090 | |
1091 | - echo '<form action="'.SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n"; |
|
1091 | + echo '<form action="' . SUBFOLDER . "/src/views/fulltext.php\" method=\"post\">\n"; |
|
1092 | 1092 | |
1093 | 1093 | // Case of multiaction drop |
1094 | 1094 | if (isset($_REQUEST['ma'])) { |
@@ -1154,7 +1154,7 @@ discard block |
||
1154 | 1154 | $_POST['ftscfg'] = $_REQUEST['ftscfg']; |
1155 | 1155 | } |
1156 | 1156 | |
1157 | - echo '<form action="'.SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n"; |
|
1157 | + echo '<form action="' . SUBFOLDER . "/src/views/fulltext.php\" method=\"post\">\n"; |
|
1158 | 1158 | |
1159 | 1159 | echo "<table>\n"; |
1160 | 1160 | echo "\t<tr>\n"; |
@@ -1259,7 +1259,7 @@ discard block |
||
1259 | 1259 | |
1260 | 1260 | $mappings = $data->getFtsMappings($_POST['ftscfg']); |
1261 | 1261 | |
1262 | - echo '<form action="'.SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n"; |
|
1262 | + echo '<form action="' . SUBFOLDER . "/src/views/fulltext.php\" method=\"post\">\n"; |
|
1263 | 1263 | echo "<table>\n"; |
1264 | 1264 | echo "\t<tr>\n"; |
1265 | 1265 | echo "\t\t<th class=\"data left required\">{$lang['strftsmapping']}</th>\n"; |
@@ -80,7 +80,7 @@ discard block |
||
80 | 80 | |
81 | 81 | $output = ob_get_clean(); |
82 | 82 | |
83 | - $this->printHeader($lang['strtables'].' - '.$_REQUEST['table'], null, true, $header_template); |
|
83 | + $this->printHeader($lang['strtables'] . ' - ' . $_REQUEST['table'], null, true, $header_template); |
|
84 | 84 | $this->printBody(); |
85 | 85 | |
86 | 86 | echo $output; |
@@ -98,7 +98,7 @@ discard block |
||
98 | 98 | $lang = $this->lang; |
99 | 99 | $data = $misc->getDatabaseAccessor(); |
100 | 100 | |
101 | - $attPre = function (&$rowdata, $actions) use ($data) { |
|
101 | + $attPre = function(&$rowdata, $actions) use ($data) { |
|
102 | 102 | $rowdata->fields['+type'] = $data->formatType($rowdata->fields['type'], $rowdata->fields['atttypmod']); |
103 | 103 | $attname = $rowdata->fields['attname']; |
104 | 104 | $table = $_REQUEST['table']; |
@@ -111,31 +111,31 @@ discard block |
||
111 | 111 | return $actions; |
112 | 112 | }; |
113 | 113 | |
114 | - $cstrRender = function ($s, $p) use ($misc, $data) { |
|
114 | + $cstrRender = function($s, $p) use ($misc, $data) { |
|
115 | 115 | $str = ''; |
116 | 116 | foreach ($p['keys'] as $k => $c) { |
117 | 117 | if (is_null($p['keys'][$k]['consrc'])) { |
118 | 118 | $atts = $data->getAttributeNames($_REQUEST['table'], explode(' ', $p['keys'][$k]['indkey'])); |
119 | - $c['consrc'] = ($c['contype'] == 'u' ? 'UNIQUE (' : 'PRIMARY KEY (').implode(',', $atts).')'; |
|
119 | + $c['consrc'] = ($c['contype'] == 'u' ? 'UNIQUE (' : 'PRIMARY KEY (') . implode(',', $atts) . ')'; |
|
120 | 120 | } |
121 | 121 | |
122 | 122 | if ($c['p_field'] == $s) { |
123 | 123 | switch ($c['contype']) { |
124 | 124 | case 'p': |
125 | - $str .= '<a href="constraints.php?'.$misc->href.'&table='.urlencode($c['p_table']).'&schema='.urlencode($c['p_schema']).'"><img src="'. |
|
126 | - $misc->icon('PrimaryKey').'" alt="[pk]" title="'.htmlentities($c['consrc'], ENT_QUOTES, 'UTF-8').'" /></a>'; |
|
125 | + $str .= '<a href="constraints.php?' . $misc->href . '&table=' . urlencode($c['p_table']) . '&schema=' . urlencode($c['p_schema']) . '"><img src="' . |
|
126 | + $misc->icon('PrimaryKey') . '" alt="[pk]" title="' . htmlentities($c['consrc'], ENT_QUOTES, 'UTF-8') . '" /></a>'; |
|
127 | 127 | break; |
128 | 128 | case 'f': |
129 | - $str .= '<a href="tblproperties.php?'.$misc->href.'&table='.urlencode($c['f_table']).'&schema='.urlencode($c['f_schema']).'"><img src="'. |
|
130 | - $misc->icon('ForeignKey').'" alt="[fk]" title="'.htmlentities($c['consrc'], ENT_QUOTES, 'UTF-8').'" /></a>'; |
|
129 | + $str .= '<a href="tblproperties.php?' . $misc->href . '&table=' . urlencode($c['f_table']) . '&schema=' . urlencode($c['f_schema']) . '"><img src="' . |
|
130 | + $misc->icon('ForeignKey') . '" alt="[fk]" title="' . htmlentities($c['consrc'], ENT_QUOTES, 'UTF-8') . '" /></a>'; |
|
131 | 131 | break; |
132 | 132 | case 'u': |
133 | - $str .= '<a href="constraints.php?'.$misc->href.'&table='.urlencode($c['p_table']).'&schema='.urlencode($c['p_schema']).'"><img src="'. |
|
134 | - $misc->icon('UniqueConstraint').'" alt="[uniq]" title="'.htmlentities($c['consrc'], ENT_QUOTES, 'UTF-8').'" /></a>'; |
|
133 | + $str .= '<a href="constraints.php?' . $misc->href . '&table=' . urlencode($c['p_table']) . '&schema=' . urlencode($c['p_schema']) . '"><img src="' . |
|
134 | + $misc->icon('UniqueConstraint') . '" alt="[uniq]" title="' . htmlentities($c['consrc'], ENT_QUOTES, 'UTF-8') . '" /></a>'; |
|
135 | 135 | break; |
136 | 136 | case 'c': |
137 | - $str .= '<a href="constraints.php?'.$misc->href.'&table='.urlencode($c['p_table']).'&schema='.urlencode($c['p_schema']).'"><img src="'. |
|
138 | - $misc->icon('CheckConstraint').'" alt="[check]" title="'.htmlentities($c['consrc'], ENT_QUOTES, 'UTF-8').'" /></a>'; |
|
137 | + $str .= '<a href="constraints.php?' . $misc->href . '&table=' . urlencode($c['p_table']) . '&schema=' . urlencode($c['p_schema']) . '"><img src="' . |
|
138 | + $misc->icon('CheckConstraint') . '" alt="[check]" title="' . htmlentities($c['consrc'], ENT_QUOTES, 'UTF-8') . '" /></a>'; |
|
139 | 139 | } |
140 | 140 | } |
141 | 141 | } |
@@ -163,7 +163,7 @@ discard block |
||
163 | 163 | 'column' => [ |
164 | 164 | 'title' => $lang['strcolumn'], |
165 | 165 | 'field' => Decorator::field('attname'), |
166 | - 'url' => "colproperties.php?subject=column&{$misc->href}&table=".urlencode($_REQUEST['table']).'&', |
|
166 | + 'url' => "colproperties.php?subject=column&{$misc->href}&table=" . urlencode($_REQUEST['table']) . '&', |
|
167 | 167 | 'vars' => ['column' => 'attname'], |
168 | 168 | ], |
169 | 169 | 'type' => [ |
@@ -202,22 +202,22 @@ discard block |
||
202 | 202 | $actions = [ |
203 | 203 | 'browse' => [ |
204 | 204 | 'title' => $lang['strbrowse'], |
205 | - 'url' => "display.php?{$misc->href}&subject=column&return=table&table=".urlencode($_REQUEST['table']).'&', |
|
205 | + 'url' => "display.php?{$misc->href}&subject=column&return=table&table=" . urlencode($_REQUEST['table']) . '&', |
|
206 | 206 | 'vars' => ['column' => 'attname'], |
207 | 207 | ], |
208 | 208 | 'alter' => [ |
209 | 209 | 'title' => $lang['stralter'], |
210 | - 'url' => "colproperties.php?action=properties&{$misc->href}&table=".urlencode($_REQUEST['table']).'&', |
|
210 | + 'url' => "colproperties.php?action=properties&{$misc->href}&table=" . urlencode($_REQUEST['table']) . '&', |
|
211 | 211 | 'vars' => ['column' => 'attname'], |
212 | 212 | ], |
213 | 213 | 'privileges' => [ |
214 | 214 | 'title' => $lang['strprivileges'], |
215 | - 'url' => "privileges.php?subject=column&{$misc->href}&table=".urlencode($_REQUEST['table']).'&', |
|
215 | + 'url' => "privileges.php?subject=column&{$misc->href}&table=" . urlencode($_REQUEST['table']) . '&', |
|
216 | 216 | 'vars' => ['column' => 'attname'], |
217 | 217 | ], |
218 | 218 | 'drop' => [ |
219 | 219 | 'title' => $lang['strdrop'], |
220 | - 'url' => "tblproperties.php?action=confirm_drop&{$misc->href}&table=".urlencode($_REQUEST['table']).'&', |
|
220 | + 'url' => "tblproperties.php?action=confirm_drop&{$misc->href}&table=" . urlencode($_REQUEST['table']) . '&', |
|
221 | 221 | 'vars' => ['column' => 'attname'], |
222 | 222 | ], |
223 | 223 | ]; |
@@ -520,7 +520,7 @@ discard block |
||
520 | 520 | $_POST['tablespace'] = $table->fields['tablespace']; |
521 | 521 | } |
522 | 522 | |
523 | - echo '<form action="'.SUBFOLDER."/src/views/tblproperties.php\" method=\"post\">\n"; |
|
523 | + echo '<form action="' . SUBFOLDER . "/src/views/tblproperties.php\" method=\"post\">\n"; |
|
524 | 524 | echo "<table>\n"; |
525 | 525 | echo "<tr><th class=\"data left required\">{$lang['strname']}</th>\n"; |
526 | 526 | echo '<td class="data1">'; |
@@ -599,7 +599,7 @@ discard block |
||
599 | 599 | $this->printTabs('table', 'export'); |
600 | 600 | $this->printMsg($msg); |
601 | 601 | |
602 | - echo '<form action="'.SUBFOLDER."/src/views/dataexport.php\" method=\"post\">\n"; |
|
602 | + echo '<form action="' . SUBFOLDER . "/src/views/dataexport.php\" method=\"post\">\n"; |
|
603 | 603 | echo "<table>\n"; |
604 | 604 | echo "<tr><th class=\"data\">{$lang['strformat']}</th><th class=\"data\" colspan=\"2\">{$lang['stroptions']}</th></tr>\n"; |
605 | 605 | // Data only |
@@ -662,7 +662,7 @@ discard block |
||
662 | 662 | // Don't show upload option if max size of uploads is zero |
663 | 663 | $max_size = $misc->inisizeToBytes(ini_get('upload_max_filesize')); |
664 | 664 | if (is_float($max_size) && $max_size > 0) { |
665 | - echo '<form action="'.SUBFOLDER."/src/views/dataimport.php\" method=\"post\" enctype=\"multipart/form-data\">\n"; |
|
665 | + echo '<form action="' . SUBFOLDER . "/src/views/dataimport.php\" method=\"post\" enctype=\"multipart/form-data\">\n"; |
|
666 | 666 | echo "<table>\n"; |
667 | 667 | echo "\t<tr>\n\t\t<th class=\"data left required\">{$lang['strformat']}</th>\n"; |
668 | 668 | echo "\t\t<td><select name=\"format\">\n"; |
@@ -741,8 +741,8 @@ discard block |
||
741 | 741 | $this->printTitle($lang['straddcolumn'], 'pg.column.add'); |
742 | 742 | $this->printMsg($msg); |
743 | 743 | |
744 | - echo '<script src="'.SUBFOLDER.'/js/tables.js" type="text/javascript"></script>'; |
|
745 | - echo '<form action="'.SUBFOLDER."/src/views/tblproperties.php\" method=\"post\">\n"; |
|
744 | + echo '<script src="' . SUBFOLDER . '/js/tables.js" type="text/javascript"></script>'; |
|
745 | + echo '<form action="' . SUBFOLDER . "/src/views/tblproperties.php\" method=\"post\">\n"; |
|
746 | 746 | |
747 | 747 | // Output table header |
748 | 748 | echo "<table>\n"; |
@@ -808,7 +808,7 @@ discard block |
||
808 | 808 | echo "<input type=\"submit\" value=\"{$lang['stradd']}\" />\n"; |
809 | 809 | echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n"; |
810 | 810 | echo "</form>\n"; |
811 | - echo '<script type="text/javascript">predefined_lengths = new Array('.implode(',', $escaped_predef_types).");checkLengths(document.getElementById('type').value,'');</script>\n"; |
|
811 | + echo '<script type="text/javascript">predefined_lengths = new Array(' . implode(',', $escaped_predef_types) . ");checkLengths(document.getElementById('type').value,'');</script>\n"; |
|
812 | 812 | break; |
813 | 813 | case 2: |
814 | 814 | // Check inputs |
@@ -857,7 +857,7 @@ discard block |
||
857 | 857 | echo '<p>', sprintf($lang['strconfdropcolumn'], $misc->printVal($_REQUEST['column']), |
858 | 858 | $misc->printVal($_REQUEST['table'])), "</p>\n"; |
859 | 859 | |
860 | - echo '<form action="'.SUBFOLDER."/src/views/tblproperties.php\" method=\"post\">\n"; |
|
860 | + echo '<form action="' . SUBFOLDER . "/src/views/tblproperties.php\" method=\"post\">\n"; |
|
861 | 861 | echo "<input type=\"hidden\" name=\"action\" value=\"drop\" />\n"; |
862 | 862 | echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n"; |
863 | 863 | echo '<input type="hidden" name="column" value="', htmlspecialchars($_REQUEST['column']), "\" />\n"; |
@@ -146,7 +146,7 @@ discard block |
||
146 | 146 | 'table' => [ |
147 | 147 | 'title' => $lang['strtable'], |
148 | 148 | 'field' => Decorator::field('relname'), |
149 | - 'url' => SUBFOLDER."/redirect/table?{$misc->href}&", |
|
149 | + 'url' => SUBFOLDER . "/redirect/table?{$misc->href}&", |
|
150 | 150 | 'vars' => ['table' => 'relname'], |
151 | 151 | ], |
152 | 152 | 'owner' => [ |
@@ -444,7 +444,7 @@ discard block |
||
444 | 444 | $this->printTitle($lang['strcreatetable'], 'pg.table.create'); |
445 | 445 | $this->printMsg($msg); |
446 | 446 | |
447 | - echo '<form action="'.SUBFOLDER.'/src/views/'.$this->script.'" method="post">'; |
|
447 | + echo '<form action="' . SUBFOLDER . '/src/views/' . $this->script . '" method="post">'; |
|
448 | 448 | echo "\n"; |
449 | 449 | echo "<table>\n"; |
450 | 450 | echo "\t<tr>\n\t\t<th class=\"data left required\">{$lang['strname']}</th>\n"; |
@@ -508,8 +508,8 @@ discard block |
||
508 | 508 | $this->printTitle($lang['strcreatetable'], 'pg.table.create'); |
509 | 509 | $this->printMsg($msg); |
510 | 510 | |
511 | - echo '<script src="'.SUBFOLDER.'/js/tables.js" type="text/javascript"></script>'; |
|
512 | - echo '<form action="'.SUBFOLDER."/src/views/tables.php\" method=\"post\">\n"; |
|
511 | + echo '<script src="' . SUBFOLDER . '/js/tables.js" type="text/javascript"></script>'; |
|
512 | + echo '<form action="' . SUBFOLDER . "/src/views/tables.php\" method=\"post\">\n"; |
|
513 | 513 | |
514 | 514 | // Output table header |
515 | 515 | echo "<table>\n"; |
@@ -563,7 +563,7 @@ discard block |
||
563 | 563 | foreach ($predefined_size_types as $value) { |
564 | 564 | $escaped_predef_types[] = "'{$value}'"; |
565 | 565 | } |
566 | - echo '<script type="text/javascript">predefined_lengths = new Array('.implode(',', $escaped_predef_types).");</script>\n\t</td>"; |
|
566 | + echo '<script type="text/javascript">predefined_lengths = new Array(' . implode(',', $escaped_predef_types) . ");</script>\n\t</td>"; |
|
567 | 567 | } |
568 | 568 | |
569 | 569 | // Output array type selector |
@@ -576,7 +576,7 @@ discard block |
||
576 | 576 | htmlspecialchars($_REQUEST['length'][$i]), "\" /></td>\n"; |
577 | 577 | echo "\t\t<td><input type=\"checkbox\" name=\"notnull[{$i}]\"", (isset($_REQUEST['notnull'][$i])) ? ' checked="checked"' : '', " /></td>\n"; |
578 | 578 | echo "\t\t<td style=\"text-align: center\"><input type=\"checkbox\" name=\"uniquekey[{$i}]\"" |
579 | - .(isset($_REQUEST['uniquekey'][$i]) ? ' checked="checked"' : '')." /></td>\n"; |
|
579 | + .(isset($_REQUEST['uniquekey'][$i]) ? ' checked="checked"' : '') . " /></td>\n"; |
|
580 | 580 | echo "\t\t<td style=\"text-align: center\"><input type=\"checkbox\" name=\"primarykey[{$i}]\" " |
581 | 581 | .(isset($_REQUEST['primarykey'][$i]) ? ' checked="checked"' : '') |
582 | 582 | ." /></td>\n"; |
@@ -713,7 +713,7 @@ discard block |
||
713 | 713 | |
714 | 714 | unset($tbltmp); |
715 | 715 | |
716 | - echo '<form action="'.SUBFOLDER."/src/views/tables.php\" method=\"post\">\n"; |
|
716 | + echo '<form action="' . SUBFOLDER . "/src/views/tables.php\" method=\"post\">\n"; |
|
717 | 717 | echo "<table>\n\t<tr>\n\t\t<th class=\"data left required\">{$lang['strname']}</th>\n"; |
718 | 718 | echo "\t\t<td class=\"data\"><input name=\"name\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"", htmlspecialchars($_REQUEST['name']), "\" /></td>\n\t</tr>\n"; |
719 | 719 | echo "\t<tr>\n\t\t<th class=\"data left required\">{$lang['strcreatetablelikeparent']}</th>\n"; |
@@ -805,7 +805,7 @@ discard block |
||
805 | 805 | |
806 | 806 | $attrs = $data->getTableAttributes($_REQUEST['table']); |
807 | 807 | |
808 | - echo '<form action="'.SUBFOLDER."/src/views/tables.php\" method=\"post\" id=\"selectform\">\n"; |
|
808 | + echo '<form action="' . SUBFOLDER . "/src/views/tables.php\" method=\"post\" id=\"selectform\">\n"; |
|
809 | 809 | if ($attrs->recordCount() > 0) { |
810 | 810 | // JavaScript for select all feature |
811 | 811 | echo "<script type=\"text/javascript\">\n"; |
@@ -942,7 +942,7 @@ discard block |
||
942 | 942 | $fksprops = false; |
943 | 943 | } |
944 | 944 | |
945 | - echo '<form action="'.SUBFOLDER."/src/views/tables.php\" method=\"post\" id=\"ac_form\">\n"; |
|
945 | + echo '<form action="' . SUBFOLDER . "/src/views/tables.php\" method=\"post\" id=\"ac_form\">\n"; |
|
946 | 946 | if ($attrs->recordCount() > 0) { |
947 | 947 | echo "<table>\n"; |
948 | 948 | |
@@ -1012,7 +1012,7 @@ discard block |
||
1012 | 1012 | |
1013 | 1013 | echo "<input type=\"hidden\" name=\"action\" value=\"insertrow\" />\n"; |
1014 | 1014 | echo '<input type="hidden" name="fields" value="', htmlentities(serialize($fields), ENT_QUOTES, 'UTF-8'), "\" />\n"; |
1015 | - echo '<input type="hidden" name="protection_counter" value="'.$_SESSION['counter']."\" />\n"; |
|
1015 | + echo '<input type="hidden" name="protection_counter" value="' . $_SESSION['counter'] . "\" />\n"; |
|
1016 | 1016 | echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n"; |
1017 | 1017 | echo "<p><input type=\"submit\" name=\"insert\" value=\"{$lang['strinsert']}\" />\n"; |
1018 | 1018 | echo "<input type=\"submit\" name=\"insertandrepeat\" accesskey=\"r\" value=\"{$lang['strinsertandrepeat']}\" />\n"; |
@@ -1082,7 +1082,7 @@ discard block |
||
1082 | 1082 | $this->printTrail('schema'); |
1083 | 1083 | $this->printTitle($lang['strempty'], 'pg.table.empty'); |
1084 | 1084 | |
1085 | - echo '<form action="'.SUBFOLDER."/src/views/tables.php\" method=\"post\">\n"; |
|
1085 | + echo '<form action="' . SUBFOLDER . "/src/views/tables.php\" method=\"post\">\n"; |
|
1086 | 1086 | foreach ($_REQUEST['ma'] as $v) { |
1087 | 1087 | $a = unserialize(htmlspecialchars_decode($v, ENT_QUOTES)); |
1088 | 1088 | echo '<p>', sprintf($lang['strconfemptytable'], $misc->printVal($a['table'])), "</p>\n"; |
@@ -1095,7 +1095,7 @@ discard block |
||
1095 | 1095 | |
1096 | 1096 | echo '<p>', sprintf($lang['strconfemptytable'], $misc->printVal($_REQUEST['table'])), "</p>\n"; |
1097 | 1097 | |
1098 | - echo '<form action="'.SUBFOLDER."/src/views/tables.php\" method=\"post\">\n"; |
|
1098 | + echo '<form action="' . SUBFOLDER . "/src/views/tables.php\" method=\"post\">\n"; |
|
1099 | 1099 | echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n"; |
1100 | 1100 | } // END not mutli empty |
1101 | 1101 | |
@@ -1152,7 +1152,7 @@ discard block |
||
1152 | 1152 | $this->printTrail('schema'); |
1153 | 1153 | $this->printTitle($lang['strdrop'], 'pg.table.drop'); |
1154 | 1154 | |
1155 | - echo '<form action="'.SUBFOLDER."/src/views/tables.php\" method=\"post\">\n"; |
|
1155 | + echo '<form action="' . SUBFOLDER . "/src/views/tables.php\" method=\"post\">\n"; |
|
1156 | 1156 | foreach ($_REQUEST['ma'] as $v) { |
1157 | 1157 | $a = unserialize(htmlspecialchars_decode($v, ENT_QUOTES)); |
1158 | 1158 | echo '<p>', sprintf($lang['strconfdroptable'], $misc->printVal($a['table'])), "</p>\n"; |
@@ -1164,7 +1164,7 @@ discard block |
||
1164 | 1164 | |
1165 | 1165 | echo '<p>', sprintf($lang['strconfdroptable'], $misc->printVal($_REQUEST['table'])), "</p>\n"; |
1166 | 1166 | |
1167 | - echo '<form action="'.SUBFOLDER."/src/views/tables.php\" method=\"post\">\n"; |
|
1167 | + echo '<form action="' . SUBFOLDER . "/src/views/tables.php\" method=\"post\">\n"; |
|
1168 | 1168 | echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n"; |
1169 | 1169 | } // END if multi drop |
1170 | 1170 |
@@ -330,7 +330,7 @@ |
||
330 | 330 | $html = ''; |
331 | 331 | $msg = htmlspecialchars(\PHPPgAdmin\HelperTrait::br2ln($msg)); |
332 | 332 | if ($msg != '') { |
333 | - $html .= '<p class="message">'.nl2br($msg).'</p>'."\n"; |
|
333 | + $html .= '<p class="message">' . nl2br($msg) . '</p>' . "\n"; |
|
334 | 334 | } |
335 | 335 | if ($do_print) { |
336 | 336 | echo $html; |
@@ -120,7 +120,7 @@ discard block |
||
120 | 120 | * |
121 | 121 | * @param ADORecordSet $rs The recordset returned by the script execetor |
122 | 122 | */ |
123 | - $sqlCallback = function ($query, $rs, $lineno) use ($data, $misc, $lang, $_connection) { |
|
123 | + $sqlCallback = function($query, $rs, $lineno) use ($data, $misc, $lang, $_connection) { |
|
124 | 124 | |
125 | 125 | // Check if $rs is false, if so then there was a fatal error |
126 | 126 | if ($rs === false) { |
@@ -186,7 +186,7 @@ discard block |
||
186 | 186 | |
187 | 187 | $rs = $data->conn->Execute($this->query); |
188 | 188 | |
189 | - echo '<form method="post" id="sqlform" action="'.$_SERVER['REQUEST_URI'].'">'; |
|
189 | + echo '<form method="post" id="sqlform" action="' . $_SERVER['REQUEST_URI'] . '">'; |
|
190 | 190 | echo '<textarea width="90%" name="query" id="query" rows="5" cols="100" resizable="true">'; |
191 | 191 | |
192 | 192 | echo htmlspecialchars($this->query); |
@@ -97,7 +97,7 @@ discard block |
||
97 | 97 | 'schema' => [ |
98 | 98 | 'title' => $lang['strschema'], |
99 | 99 | 'field' => Decorator::field('nspname'), |
100 | - 'url' => SUBFOLDER."/redirect/schema?{$misc->href}&", |
|
100 | + 'url' => SUBFOLDER . "/redirect/schema?{$misc->href}&", |
|
101 | 101 | 'vars' => ['schema' => 'nspname'], |
102 | 102 | ], |
103 | 103 | 'owner' => [ |
@@ -283,7 +283,7 @@ discard block |
||
283 | 283 | $this->printTitle($lang['strcreateschema'], 'pg.schema.create'); |
284 | 284 | $this->printMsg($msg); |
285 | 285 | |
286 | - echo '<form action="'.SUBFOLDER.'/src/views/schemas.php" method="post">'."\n"; |
|
286 | + echo '<form action="' . SUBFOLDER . '/src/views/schemas.php" method="post">' . "\n"; |
|
287 | 287 | echo "<table style=\"width: 100%\">\n"; |
288 | 288 | echo "\t<tr>\n\t\t<th class=\"data left required\">{$lang['strname']}</th>\n"; |
289 | 289 | echo "\t\t<td class=\"data1\"><input name=\"formName\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"", |
@@ -368,7 +368,7 @@ discard block |
||
368 | 368 | $_POST['owner'] = $schema->fields['ownername']; |
369 | 369 | } |
370 | 370 | |
371 | - echo '<form action="'.SUBFOLDER.'/src/views/schemas.php" method="post">'."\n"; |
|
371 | + echo '<form action="' . SUBFOLDER . '/src/views/schemas.php" method="post">' . "\n"; |
|
372 | 372 | echo "<table>\n"; |
373 | 373 | |
374 | 374 | echo "\t<tr>\n"; |
@@ -446,7 +446,7 @@ discard block |
||
446 | 446 | $this->printTrail('schema'); |
447 | 447 | $this->printTitle($lang['strdrop'], 'pg.schema.drop'); |
448 | 448 | |
449 | - echo '<form action="'.SUBFOLDER.'/src/views/schemas.php" method="post">'."\n"; |
|
449 | + echo '<form action="' . SUBFOLDER . '/src/views/schemas.php" method="post">' . "\n"; |
|
450 | 450 | //If multi drop |
451 | 451 | if (isset($_REQUEST['ma'])) { |
452 | 452 | foreach ($_REQUEST['ma'] as $v) { |
@@ -515,7 +515,7 @@ discard block |
||
515 | 515 | $this->printTabs('schema', 'export'); |
516 | 516 | $this->printMsg($msg); |
517 | 517 | |
518 | - echo '<form action="'.SUBFOLDER.'/src/views/dbexport.php" method="post">'."\n"; |
|
518 | + echo '<form action="' . SUBFOLDER . '/src/views/dbexport.php" method="post">' . "\n"; |
|
519 | 519 | |
520 | 520 | echo "<table>\n"; |
521 | 521 | echo "<tr><th class=\"data\">{$lang['strformat']}</th><th class=\"data\" colspan=\"2\">{$lang['stroptions']}</th></tr>\n"; |