function cout_sql_res($SIDU, $res) { $SIDU['col'] = $res[5]; $SIDU['data'] = $res[6]; @init_pg_col_align($SIDU['data'], $SIDU['col']); if ($_GET['chart']) { @cout_sql_chart($SIDU); } @init_col_width($SIDU); @cout_data($SIDU, $link, $conn, 1); }
function init_tab(&$SIDU, $link, $conn) { if ($conn[1] == "my") { //0name 1type 2null 3defa 4maxchar 5extra 6comm 7pk 8align 9pos $res = @tm("SQL", "SELECT COLUMN_NAME,COLUMN_TYPE,IS_NULLABLE,COLUMN_DEFAULT,\nifnull(CHARACTER_MAXIMUM_LENGTH,NUMERIC_PRECISION),EXTRA,COLUMN_COMMENT,\nCOLUMN_KEY,if(NUMERIC_PRECISION IS NULL,'','i'),ORDINAL_POSITION\nFROM information_schema.COLUMNS\nWHERE TABLE_SCHEMA='{$SIDU['1']}' AND TABLE_NAME='{$SIDU['4']}'\nORDER BY ORDINAL_POSITION"); while ($row = @mysql_fetch_row($res)) { $col[] = $row; if ($row[7] == 'PRI') { $SIDU['pk'][] = $row[9] - 1; } } $num = @mysql_fetch_row(@tm("SQL", "SELECT COUNT(*) FROM `{$link['1']}`.`{$link['4']}`")); } elseif ($conn[1] == 'sl') { $res = @tm("SQL", "pragma table_info({$link['4']})"); while ($row = @sqlite_fetch_array($res)) { if ($row['type'] == 'integer') { $row['type'] = 'int'; } if ($row['pk']) { $SIDU['pk'][] = $row['cid']; } $col[] = @array($row['name'], $row['type'], $row['notnull'] ? 'NULL' : 'YES', $row['dflt_value'], '', '', '', $row['pk'] ? 'PRI' : '', "", $row['cid'] + 1); } $num = @sqlite_fetch_array(@tm("SQL", "SELECT COUNT(*) FROM {$link['4']}")); } else { $tab = @pg_fetch_row(@tm("SQL", "SELECT a.oid,a.relnamespace,a.relhasoids,obj_description(a.oid,'pg_class')\nFROM pg_class a,pg_namespace b WHERE a.relkind='{$link['3']}' AND a.relnamespace=b.oid\nAND a.relname='{$link['4']}' AND b.nspname='{$link['2']}'")); $SIDU['tabinfo'] = $tab; $defa = @sql2arr("SELECT adnum,adsrc FROM pg_attrdef WHERE adrelid={$tab['0']}", 2); $defaRaw = $defa; foreach ($defa as $k => $v) { if (@substr($v, 0, 9) != "nextval('") { $rowx = @explode("::", $v); if (@substr($rowx[0], 0, 1) == "'" && @substr($rowx[0], -1) == "'") { $rowx[0] = @substr($rowx[0], 1, -1); } $rowx[0] = @str_replace("''", "'", $rowx[0]); $defa[$k] = $rowx[0]; } } if ($SIDU['page']['oid'] && $tab[2] == 't') { $col[0] = @array("oid", "oid", 't'); $hasOID = "oid,"; } else { $colX = -1; } $typ = @sql2arr("SELECT oid,typname FROM pg_type", 2); $res = @tm("SQL", "SELECT attname,atttypid,attnotnull,atthasdef,\nCASE attlen WHEN -1 THEN atttypmod ELSE attlen END,\n'','','','',attnum,format_type(atttypid,atttypmod) FROM pg_attribute\nWHERE attrelid={$tab['0']} AND attnum>0 AND attisdropped=FALSE ORDER BY attnum"); while ($row = @pg_fetch_row($res)) { $row[3] = $row[3] == 't' ? $defa[$row[9]] : ''; $row[1] = $typ[$row[1]]; if ($row[1] == "numeric") { $row[1] = $row[10]; } elseif ($row[1] == 'int2') { $row[1] = "smallint"; } elseif ($row[1] == 'int4') { $row[1] = "int"; } elseif ($row[1] == 'int8') { $row[1] = "bigint"; } elseif ($row[1] == 'bpchar') { $row[1] = "char"; } if ($row[4] > 4 && ($row[1] == 'varchar' || $row[1] == 'char')) { $row[1] .= "(" . ($row[4] - 4) . ")"; } if (@substr($row[3], 0, 9) == "nextval('") { $row[1] = $row[1] == "int" ? "serial" : "bigserial"; } $row[11] = $defaRaw[$row[9]]; //only used for default ''::varchar etc $col[] = $row; } $res = @tm("SQL", "SELECT conkey,contype FROM pg_constraint\nWHERE connamespace={$tab['1']} AND conrelid={$tab['0']}"); while ($row = @pg_fetch_row($res)) { //pk uk fk $pucf = @explode(",", @substr($row[0], 1, -1)); foreach ($pucf as $v) { $col[$v + $colX][7] = $col[$v + $colX][7] ? $col[$v + $colX][7] . ",{$row['1']}" : $row[1]; if ($row[1] == 'p') { $SIDU['pk'][] = $v + $colX; } } } $num = @pg_fetch_row(@tm("SQL", "SELECT COUNT(*) FROM \"{$link['2']}\".\"{$link['4']}\"")); } $SIDU[10] += $num[0]; $SIDU['col'] = $col; if ($_GET['desc']) { //desc if ($conn[1] == 'pg') { //set col comm $res = @tm("SQL", "SELECT objsubid,description FROM pg_description\nWHERE objoid={$tab['0']} AND objsubid>0"); while ($row = @pg_fetch_row($res)) { $SIDU['col'][$row[0] + $colX][6] = $row[1]; } } return; } $SIDU['gridShow'] = $_POST['gridShow']; $MODE = @explode('.', $_COOKIE['SIDUMODE']); //0lang 1gridmode 2pgsize=sidu9 $SIDU['gridMode'] = $MODE[1]; if ($MODE[2] < -1 || !$MODE[2]) { $MODE[2] = 15; } $SIDU[9] = $MODE[2]; $SIDU[8] = @ceil($_POST['sidu8']); if ($SIDU[8] < 0) { $SIDU[8] = 0; } $SIDU[7] = $_POST['sidu7']; //sort if (@substr($SIDU[7], 0, 4) == 'del:') { $SIDU[7] = @substr($SIDU[7], 4); if ($SIDU[5] == $SIDU[7] || $SIDU[5] == "{$SIDU['7']} desc") { $SIDU[5] = $SIDU[7] = ''; } elseif ($SIDU[6] == $SIDU[7] || $SIDU[6] == "{$SIDU['7']} desc") { $SIDU[6] = $SIDU[7] = ''; } else { $SIDU[7] = ''; } } $SIDU['f'] = @strip($_POST['f'], 1, 0, 1); @sidu_sort($SIDU[5], $SIDU[6], $SIDU[7], $SIDU['page']['sortData']); $strSort = $SIDU[5] ? " ORDER BY {$SIDU['5']}" . ($SIDU[6] ? ",{$SIDU['6']}" : "") : ($SIDU[6] ? " ORDER BY {$SIDU['6']}" : ""); foreach ($SIDU['f'] as $k => $v) { if ($k === 'sql' && $v) { $whereSQL = " AND " . $SIDU['f']['sql']; } elseif ($v != '') { $where .= " AND " . $SIDU['col'][$k][0] . " {$v}"; } } $where .= $whereSQL; if (!$strSort && (!$where || !@stripos($where, " order by "))) { $strSort = " ORDER BY 1 DESC"; } if ($where) { $where = " WHERE " . @substr($where, 5); if ($conn[1] == 'my') { $res = @tm("SQL", "SELECT COUNT(*) FROM `{$SIDU['1']}`.`{$SIDU['4']}`{$where}"); $row = @mysql_fetch_row($res); } elseif ($conn[1] == 'pg') { $res = @tm("SQL", "SELECT COUNT(*) FROM \"{$SIDU['2']}\".\"{$SIDU['4']}\"{$where}"); $row = @pg_fetch_row($res); } else { $res = @tm("SQL", "SELECT COUNT(*) FROM {$SIDU['4']}{$where}"); $row = @sqlite_fetch_array($res); } $SIDU[10] = $row[0]; } if ($_POST['cmd'] == 'p1') { $SIDU[8] = 0; } elseif ($SIDU[9] != -1) { if ($_POST['cmd'] == 'pback') { $SIDU[8] -= $SIDU[9]; } elseif ($_POST['cmd'] == 'pnext') { $SIDU[8] += $SIDU[9]; } elseif ($_POST['cmd'] == 'plast') { $SIDU[8] = $SIDU[10] - $SIDU[9]; } if ($SIDU[8] > $SIDU[10]) { $SIDU[8] = $SIDU[10] - $SIDU[9]; } if ($SIDU[8] < 0) { $SIDU[8] = 0; } } if ($SIDU[9] != -1) { $limit = " LIMIT {$SIDU['9']}" . ($SIDU[8] ? " OFFSET {$SIDU['8']}" : ""); } if ($conn[1] == 'my') { $res = @tm("SQL", "SELECT * FROM `{$SIDU['1']}`.`{$SIDU['4']}`{$where}{$strSort}{$limit}"); while ($row = @mysql_fetch_row($res)) { $arr[] = $row; } } elseif ($conn[1] == 'pg') { $res = @tm("SQL", "SELECT {$hasOID}* FROM \"{$SIDU['2']}\".\"{$SIDU['4']}\"{$where}{$strSort}{$limit}"); while ($row = @pg_fetch_row($res)) { $arr[] = $row; } } else { $res = @tm("SQL", "SELECT * FROM {$SIDU['4']}{$where}{$strSort}{$limit}"); while ($row = @sqlite_fetch_array($res, SQLITE_NUM)) { $arr[] = $row; } } $SIDU['data'] = $arr; if ($conn[1] != 'my') { @init_pg_col_align($SIDU['data'], $SIDU['col']); } if ($_POST['hideCol'] != '') { $_POST['g'][$_POST['hideCol']] = -1; } @init_col_width($SIDU); }