Location: PHPKode > projects > MySQL Sidu DB Web GUI > sidu37/inc.page.php
<?php
session_start();
extract($_POST); extract($_GET);
include 'inc.func.php';
@check_global_ip_access();//exit if ip blocked
include 'inc.func.enc65.php';
//db =0id 1db 2sch 3typ 4tab 5sort1 6sort2 7sort &oid--sad oid not designed into the id-link
//tab=0id 1db 2sch 3typ 4tab 5sort1 6sort2 7sort 8fm 9to ; fm|to ; f[0..x|sql] ; g[size|show][0..x] &oid
//sql=id,sql,hide,ttl_sql,ttl_err,ttl_time,Rows
//cookie:--better put into session. but sf.net does not support session?
//conn[txt]--please read conn.php
//MODE=0lang.1gridMode.2pgSize.3tree.4sortObj.5sortData.6menuTextSQL.7menuText.8his.9hisErr.10hisSQL.11hisData.12dataEasy(pg).13oid(pg)
//CONN=0id.1eng.2host.3user.4enc(pass).5port.6dbs.7penc.8charset
//SQL =hide@address.com@...
if (isset($_GET['id'])) $SIDU=explode(',',$_GET['id']);
$SIDU['conn']=@get_sidu_conn();
$SIDU['cook']=@get_sidu_cook();//SIDUSQL
@check_sidu_conn($SIDU);//exit if no conn
$SIDU['dbL']=@db_conn($SIDU['conn'][$SIDU[0]],$SIDU[1]);
@initSIDU();
if ($SIDU['page']['lang']<>'en') include "lang/{$SIDU[page][lang]}.php";
else include 'lang/en.php';
$SIDU['sidu_ver']='3.7';
$SIDU['sql_kw']=explode(',','ABORT,ABS,ABSOLUTE,ACCESSIBLE,ACTION,ADD,ADD_MONTHS,ADMIN,AFTER,AGGREGATE,ALIAS,ALL,ALLOCATE,ALTER,ANALYSE,ANALYZE,AND,ANY,ARE,ARRAY,ARRAY_AGG,AS,ASC,ASENSITIVE,ASSERTION,ASYMMETRIC,ASYNC,AT,ATOMIC,ATTACH,ATTRIBUTE,AUTHORIZATION,AUTOINCREMENT,AVG,BEFORE,BEGIN,BETWEEN,BIGINT,BINARY,BIT,BIT_LENGTH,BLOB,BOOLEAN,BOTH,BREADTH,BY,CALL,CALLED,CARDINALITY,CASCADE,CASCADED,CASE,CAST,CATALOG,CEIL,CEILING,CHANGE,CHAR,CHARACTER,CHARACTER_LENGTH,CHAR_LENGTH,CHECK,CLASS,CLASSES,CLOB,CLOSE,CLUSTER,COALESCE,COLLATE,COLLATION,COLLECT,COLUMN,COMMIT,COMPLETION,CONCURRENTLY,CONDITION,CONFLICT,CONNECT,CONNECTION,CONNECTION_BY_ROOT,CONNECT_BY_ISCYCLE,CONNECT_BY_ISLEAF,CONSTRAINT,CONSTRAINTS,CONSTRUCTOR,CONTINUE,CONVERT,CORR,CORRESPONDING,COUNT,COVAR_POP,COVAR_SAMP,CREATE,CROSS,CUBE,CUME_DIST,CURRENT,CURRENT_CATALOG,CURRENT_DATE,CURRENT_DATETIME,CURRENT_DEFAULT_TRANSFORM_GROUP,CURRENT_PATH,CURRENT_ROLE,CURRENT_SCHEMA,CURRENT_TIME,CURRENT_TIMESTAMP,CURRENT_TRANSFORM_GROUP_FOR_TYPE,CURRENT_USER,CURSOR,CYCLE,DATA,DATABASE,DATABASES,DATALINK,DATA_TYPE,DATE,DATETIME,DAY,DAY_HOUR,DAY_MICROSECOND,DAY_MILLISECOND,DAY_MINUTE,DAY_SECOND,DEALLOCATE,DEC,DECIMAL,DECLARE,DEFAULT,DEFERRABLE,DEFERRED,DELAYED,DELETE,DENSE_RANK,DEPTH,DEREF,DESC,DESCRIBE,DESCRIPTOR,DESTROY,DESTRUCTOR,DETACH,DETERMINISTIC,DIAGNOSTICS,DICTIONARY,DIFFERENCE,DISCONNECT,DISTINCT,DISTINCTROW,DIV,DLNEWCOPY,DLPREVIOUSCOPY,DLURLCOMPLETE,DLURLCOMPLETEONLY,DLURLCOMPLETEWRITE,DLURLPATH,DLURLPATHONLY,DLURLPATHWRITE,DLURLSCHEME,DLURLSERVER,DLVALUE,DO,DOMAIN,DOUBLE,DROP,DUAL,DUPLICATE,DYNAMIC,EACH,ELEMENT,ELSE,ELSEIF,ENCLOSED,END,END-EXEC,EQUALS,ESCAPE,ESCAPED,EVALUATE,EVERY,EXCEPT,EXCEPTION,EXCLUDE,EXCLUSIVE,EXEC,EXECUTE,EXISTS,EXIT,EXP,EXPLAIN,EXTERNAL,EXTRACT,FAIL,FALSE,FETCH,FILE,FILTER,FIRST,FIRST_VALUE,FLOAT,FLOAT4,FLOAT8,FLOOR,FOR,FORCE,FOREIGN,FOUND,FREE,FREEZE,FROM,FULL,FULLTEXT,FUNCTION,FUSION,GENERAL,GET,GLOB,GLOBAL,GO,GOTO,GRANT,GROUP,GROUPING,HAVING,HIGH_PRIORITY,HOLD,HOST,HOUR,HOUR_MICROSECOND,HOUR_MILLISECOND,HOUR_MINUTE,HOUR_SECOND,IDENTITY,IF,IGNORE,IGNORE_SERVER_IDS,ILIKE,IMMEDIATE,IMPORT,IN,INDEX,INDEXED,INDICATOR,INFILE,INHERIT,INITIALIZE,INITIALLY,INNER,INOUT,INPUT,INSENSITIVE,INSERT,INSTEAD,INT,INT1,INT2,INT3,INT4,INT8,INTEGER,INTERSECT,INTERSECTION,INTERVAL,INTO,IS,ISNULL,ISOLATION,ITERATE,JOIN,KEY,KEYS,KILL,LAG,LANGUAGE,LARGE,LAST,LAST_VALUE,LATERAL,LDB,LEAD,LEADING,LEAVE,LEFT,LESS,LEVEL,LIKE,LIKE_REGEX,LIMIT,LINEAR,LINES,LIST,LN,LOAD,LOCAL,LOCALTIME,LOCALTIMESTAMP,LOCAL_TRANSACTION_ID,LOCATOR,LOCK,LONG,LONGBLOB,LONGTEXT,LOOP,LOWER,LOW_PRIORITY,MAP,MASTER_HEARTBEAT_PERIOD,MASTER_SSL_VERIFY_SERVER_CERT,MATCH,MAX,MAXVALUE,MAX_CARDINALITY,MEDIUMBLOB,MEDIUMINT,MEDIUMTEXT,MEMBER,MERGE,METHOD,MIDDLEINT,MILLISECOND,MIN,MINUTE,MINUTE_MICROSECOND,MINUTE_MILLISECOND,MINUTE_SECOND,MOD,MODIFIES,MODIFY,MODULE,MONETARY,MONTH,MULTISET,MULTISET_OF,NA,NAMES,NATIONAL,NATURAL,NCHAR,NCLOB,NEW,NEXT,NO,NONE,NORMALIZE,NOT,NOTNULL,NO_WRITE_TO_BINLOG,NTH_VALUE,NTILE,NULLIF,NUMERIC,OBJECT,OCCURRENCES_REGEX,OCTET_LENGTH,OF,OFF,OFFSET,OID,OLD,ON,ONLY,OPEN,OPERATION,OPERATORS,OPTIMIZATION,OPTIMIZE,OPTION,OPTIONALLY,OR,ORDER,OTHERS,OUT,OUTER,OUTFILE,OUTPUT,OVER,OVERLAPS,OVERLAY,PAD,PARAMETER,PARAMETERS,PARTIAL,PARTITION,PATH,PENDANT,PERCENTILE_CONT,PERCENTILE_DISC,PERCENT_RANK,PLACING,PLAN,POSITION,POSITION_REGEX,POSTFIX,POWER,PRAGMA,PRECISION,PREFIX,PREORDER,PREPARE,PRESERVE,PRIMARY,PRIOR,PRIVATE,PRIVILEGES,PROCEDURE,PROTECTED,PROXY,PUBLIC,PURGE,QUERY,RAISE,RANGE,RANK,READ,READS,READ_WRITE,REAL,RECURSIVE,REF,REFERENCES,REFERENCING,REGEXP,REGISTER,REGR_AVGX,REGR_AVGY,REGR_COUNT,REGR_INTERCEPT,REGR_R2,REGR_SLOPE,REGR_SXX,REGR_SXY,REGR_SYY,REINDEX,RELATIVE,RELEASE,RENAME,REPEAT,REPLACE,REQUIRE,RESIGNAL,RESTRICT,RESULT,RETURN,RETURNING,RETURNS,REVOKE,RIGHT,RLIKE,ROLE,ROLLBACK,ROLLUP,ROUTINE,ROW,ROWNUM,ROWS,ROW_NUMBER,SAVEPOINT,SCHEMA,SCHEMAS,SCOPE,SCROLL,SEARCH,SECOND,SECOND_MICROSECOND,SECOND_MILLISECOND,SECTION,SELECT,SENSITIVE,SEPARATOR,SEQUENCE,SEQUENCE_OF,SERIALIZABLE,SESSION,SESSION_USER,SET,SETEQ,SETS,SET_OF,SHARED,SHOW,SIBLINGS,SIGNAL,SIMILAR,SIZE,SLOW,SMALLINT,SOME,SPACE,SPATIAL,SPECIFIC,SPECIFICTYPE,SQL,SQLCODE,SQLERROR,SQLEXCEPTION,SQLSTATE,SQLWARNING,SQL_BIG_RESULT,SQL_CALC_FOUND_ROWS,SQL_SMALL_RESULT,SQRT,SSL,START,STARTING,STATE,STATEMENT,STATIC,STATISTICS,STDDEV_POP,STDDEV_SAMP,STRAIGHT_JOIN,STRING,STRUCTURE,SUBCLASS,SUBMULTISET,SUBSET,SUBSETEQ,SUBSTRING,SUBSTRING_REGEX,SUM,SUPERCLASS,SUPERSET,SUPERSETEQ,SYMMETRIC,SYSDATE,SYSDATETIME,SYSTEM,SYSTEM_USER,SYSTIME,SYS_CONNECT_BY_PATH,SYS_DATE,SYS_DATETIME,SYS_TIME,SYS_TIMESTAMP,SYS_USER,TABLE,TABLESAMPLE,TEMP,TEMPORARY,TERMINATE,TERMINATED,TEST,THAN,THEN,THERE,TIME,TIMESTAMP,TIMEZONE_HOUR,TIMEZONE_MINUTE,TINYBLOB,TINYINT,TINYTEXT,TO,TRAILING,TRANSACTION,TRANSLATE,TRANSLATE_REGEX,TRANSLATION,TREAT,TRIGGER,TRIM,TRIM_ARRAY,TRUE,TRUNCATE,TYPE,UESCAPE,UNDER,UNDO,UNION,UNIQUE,UNKNOWN,UNLOCK,UNNEST,UNSIGNED,UPDATE,UPPER,USAGE,USE,USER,USING,UTC_DATE,UTC_TIME,UTC_TIMESTAMP,UTIME,VACUUM,VALUE,VALUES,VARBINARY,VARCHAR,VARCHARACTER,VARIABLE,VARIADIC,VARYING,VAR_POP,VAR_SAMP,VCLASS,VERBOSE,VIEW,VIRTUAL,VISIBLE,WAIT,WHEN,WHENEVER,WHERE,WHILE,WIDTH_BUCKET,WINDOW,WITH,WITHIN,WITHOUT,WORK,WRAPPER,WRITE,XML,XMLAGG,XMLATTRIBUTES,XMLBINARY,XMLCAST,XMLCOMMENT,XMLCONCAT,XMLDOCUMENT,XMLELEMENT,XMLEXISTS,XMLFOREST,XMLITERATE,XMLNAMESPACES,XMLPARSE,XMLPI,XMLQUERY,XMLROOT,XMLSERIALIZE,XMLTABLE,XMLTEXT,XMLVALIDATE,XOR,YEAR,YEAR_MONTH,ZEROFILL,ZONE');

function SIDU_PK(){return '2012-SIDU-0909';}//SIDU Product Key - please update
function SIDU_IP(){return '';}//SIDU Global Firewall eg '^127.0.0.1$;^192.168'
?>
Return current item: MySQL Sidu DB Web GUI