Help
RSS
API
Feed
Maltego
Contact
Domain > db-tool.parorrey.com
×
More information on this domain is in
AlienVault OTX
Is this malicious?
Yes
No
DNS Resolutions
Date
IP Address
2026-02-16
88.198.195.29
(
ClassC
)
Port 80
HTTP/1.1 301 Moved PermanentlyDate: Mon, 16 Feb 2026 02:13:51 GMTServer: ApacheLocation: https://db-tool.parorrey.com/Content-Length: 347Content-Type: text/html; charsetiso-8859-1 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN http://www.w3.org/TR/html4/strict.dtd>html>head>title>301 Moved Permanently/title>/head>body>h1>Moved Permanently/h1>p>The document has moved a hrefhttps://db-tool.parorrey.com/>here/a>./p>hr>address>Apache Server at db-tool.parorrey.com Port 80/address>/body>/html>
Port 443
HTTP/1.1 200 OKDate: Mon, 16 Feb 2026 02:13:51 GMTServer: ApacheUpgrade: h2Connection: UpgradeVary: Accept-EncodingTransfer-Encoding: chunkedContent-Type: text/html; charsetutf-8 !DOCTYPE html>html> head> title>MySQL Database Query Tool - Displaying Search Results with Google Charts/title> meta namedescription contentPI MySQL Database Query tool works in browser & allows to connect to any MySQL database, build query and display results with Google Charts. This PHP app connects with MySQL Database and uses jQuery to build UI and show results. classyoast-seo-meta-tag /> link hrefhttps://fonts.googleapis.com/css?familyRoboto:300,400,500,700 relstylesheet> link relstylesheet hrefhttps://use.fontawesome.com/releases/v5.5.0/css/all.css integritysha384-B4dIYHKNBt8Bc12p+WXckhzcICo0wtJAoU8YZTY5qE0Id1GSseTk6S+L3BlXeVIU crossoriginanonymous> base hrefhttps://db-tool.parorrey.com/> script srchttps://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js>/script> script srcjs/moment.js>/script> link relstylesheet hrefstyles.css> link relapple-touch-icon sizes180x180 href/images/apple-touch-icon.png>link relicon typeimage/png sizes32x32 href/images/favicon-32x32.png>link relicon typeimage/png sizes16x16 href/images/favicon-16x16.png>link relmanifest href/site.webmanifest> script typetext/javascript srchttps://www.gstatic.com/charts/loader.js>/script> script srcjs/functions.js>/script> /head> body> div idheader>img srcimages/MySQLDBTool-logo.png srcsetimages/MySQLDBTool-logo-2x.png 2x altMySQL DB Tool width75 height75/>h1>MySQL Database Query Tool/h1>/div> div classtestbox> form action/ idquery_form> div classcolumns idcredentials> div classerror-msg hide >i classfa fa-times-circle>/i>Error: No value has been provided!/div> fieldset> legend>MySQL Data:/legend> div classitem> input idmysql_host typetext namemysql_host placeholderMySQL Host valuesql569.your-server.de required/> /div> div classitem> input idmysql_database typetext namemysql_database placeholderMySQL Database valuedbtool required/> /div> div classitem> input idmysql_username typetext namemysql_username placeholderMySQL Username valuedbtool_r required/> /div> div classitem> input idmysql_password typetext namemysql_password placeholderMySQL Password valueyKiqG82FzF8wSzip required/> /div> /fieldset> /div> div classbtn-block idfetch_tables> button typebutton href/ idbt_table>Fetch Tables/button> div classsuccess-msg hide>i classfa fa-check>/i>Tables were fetched successfully!/div> div classerror-msg hide>i classfa fa-times-circle>/i>Error: Tables were not fetched successfully. DB connection error./div> /div> div classcolumns> fieldset> legend>Select Table & Fields:/legend> div classitem stylefloat: none;> select iddb_table namedb_table required/> option value>Choose a Table:/option> /select> /div> div idquery_box classfull> div classbox-4 idselect> h3>SELECT:/h3> table idtable_fields>/table> /div> div classbox-4 idwhere> h3>WHERE:/h3> table idwhere_fields>/table> /div> div classbox-4 idgroup_by> h3>GROUP BY:/h3> table idgroup_fields>/table> /div> div classbox-4 idorder_by> h3>ORDER BY:/h3> table idorder_fields>/table> /div> /div> /fieldset> /div> br/> br/> div classcolumns> fieldset> legend>MySQL Query:/legend> div classfull> textarea idmysql_query namemysql_query placeholderMySQL Query rows8>/textarea> div classradio_box idlimit_box> span>Limit: /span> label classradio-inline> input typeradio namelimit value50 checked>50 /label> label classradio-inline> input typeradio idlimit namelimit value100>100 /label> label classradio-inline> input typeradio idlimit namelimit value500>500 /label> label classradio-inline> input typeradio idlimit namelimit value1000>1000 /label> label classradio-inline> input typeradio idlimit namelimit valueall>All /label>/div> /div> /fieldset> /div> div classbtn-block> button typebutton href/ idbt_search disabled>Search/button> /div> /form> /div> div idchart_columns>div classwarning-msg hide >i classfa fa-warning>/i>Warning: All series on a given axis must be of the same data type. Current selected columns are: /div> div idfetch_chart>div classerror-msg hide >i classfa fa-times-circle>/i>Error: Charts were not drawn successfully./div> /div> div classmap_box hide > h3>Chart Options:/h3> div classcolumns> div classitem> div classradio_box idchart_box> strong>Type:/strong> label classradio-inline> input typeradio namechart_type valueLineChart checked>Line /label> label classradio-inline> input typeradio namechart_type valueAreaChart>Area /label> label classradio-inline> input typeradio namechart_type valueColumnChart>Column /label> label classradio-inline> input typeradio namechart_type valueBarChart>Bar /label> /div> /div> div classitem> label forchart_bg_color>Chart Background Color: /label> select idchart_bg_color namechart_bg_color required/> option value#FFFFFF>White/option> option value#FFFCF4>Cosmic Latte/option> option value#FDF9F3>Antique White/option> option value#FBF2E7>Champagne/option> option value#FBEAF2>Classic Rose/option> option value#E1E0F6>Soap/option> option value#EAF1F8>Azureish White/option> option value#f1f8e9>Panache/option> /select>/div> /div> br> div idchart_div styleheight: 500px;>/div> /div> /div>div>div aligncenter>style>.buy { background-color: #FF602B; border-radius: 8px; border-style: none; box-sizing: border-box; color: #FFFFFF; cursor: pointer; display: inline-block; font-size: 14px; font-weight: 500; height: 40px; width: 290px; line-height: 20px; list-style: none; margin: 10px auto; outline: none; padding: 10px 16px; position: relative; text-align: center; text-decoration: none; transition: color 100ms; vertical-align: baseline; user-select: none; -webkit-user-select: none; touch-action: manipulation;}.buy > a, .buy:hover, .buy:focus { color: #FFFFFF; text-decoration: none;} /style> button classbuy rolebutton>a hrefhttps://www.parorrey.com/solutions/mysql-database-query-tool/ target_blank>Buy This MySQL Database Query App/a>/button>/div> footer> p>copyright © 2026 a hrefhttps://www.parorrey.com/ target_blank>PI Media/a>/p>/footer>/div> script> $(document).ready(function(){ google.charts.load(current, {packages:corechart}); var selected_query_fields ; var selected_query_alias ; var selected_query_types ; $(#bt_table).click(function(){ var emptyFields; $(#credentials inputtypetext).each(function () { if ( $.trim($(this).val()) ) { emptyFields.push( $(this).attr(placeholder)); }}); if( emptyFields.length > 0 ) { $(#credentials .error-msg).html(Missing value(s): b>+emptyFields.join(, )+/b>).fadeIn(300).delay(3000).fadeOut(300); } }); function fetchTables(obj_data){ var columns; var dataOpt obj_data; $(#db_table option:not(:first)).remove(); for(var i0; i dataOpt.length;i++){//creates option tag var opt_name $.parseJSON(JSON.stringify(dataOpt)); var selectedTable; $(option/>, { value: opt_nameitable, html: opt_nameitable }).appendTo(#db_table); $(#db_table).on(change, function (e) { const aggregate_func COUNT, SUM, AVG, MIN, MAX; const date_func DAY, MONTH, YEAR, CURRENT_DATE, CURRENT_TIME; const text_func COUNT, MIN, MAX; const numeric int, double, float, integer, bigint, decimal, smallint, numeric; const datetime date, datetime, timestamp, year; const text_type tinytext, text, mediumtext, longtext, varchar, char, enum; const operators , >, , >, , >, LIKE, IN, BETWEEN; var optionSelected $(option:selected, this); var valueSelected this.value; var from_table this.value; var indexSelected ($(#db_table).prop(selectedIndex) - 1); //alert(valueSelected: +valueSelected+ indexSelected: +indexSelected); $(#table_fields).html(); $(#where_fields).html(); $(#group_fields).html(); $(#order_fields).html(); if(indexSelected > 0){ var columns opt_nameindexSelectedcolumns; //for loop for select box for(var k0; k columns.length;k++){ var type columnskType.replace(/\(.*$/, ); $(tr>td>label for+columnskField+ styleword-wrap:break-word>input typecheckbox id+columnskField+ name+columnskField+ value+columnskField+ data+type+ />+columnskField+/label>/td>td classtd_db_functions>select iddb_function_+columnskField+ namedb_function_+columnskField+>option value>Select:/option>/select>/td>td idtd_alias_+columnskField+>input typetext idalias_+columnskField+ placeholderalias namealias_+columnskField+ value />/td>/tr>).appendTo(#table_fields); $(#table_fields select).attr(disabled,true); $(#table_fields :text).attr(disabled,true); if( numeric.includes(type) ) { for(var j0; j aggregate_func.length;j++){ $(option/>, { value: aggregate_funcj, html: aggregate_funcj }).appendTo(#db_function_+columnskField); } } else if( datetime.includes(type) ) { for(var j0; j date_func.length;j++){ $(option/>, { value: date_funcj, html: date_funcj }).appendTo(#db_function_+columnskField); } }else if( text_type.includes(type) ) { for(var j0; j text_func.length;j++){ $(option/>, { value: text_funcj, html: text_funcj }).appendTo(#db_function_+columnskField); } }else{ $(#db_function_+columnskField).remove(); $(#alias_+columnskField).remove(); } } //for loop for where box for(var k0; k columns.length;k++){ var type columnskType.replace(/\(.*$/, ); var where_fields tr>td>label forwhere_+columnskField+ styleword-wrap:break-word>+ input typecheckbox idwhere_+columnskField+ namewhere_+columnskField+ value+columnskField+/>+columnskField+/label>/td>+ /*td idtd_where_functions_+columnskField+>select idwhere_functions_+columnskField+ namewhere_functions_+columnskField+>option value>Function:/option>/select>/td>+*/ td idtd_operator_+columnskField+>select idoperator_+columnskField+ nameoperator_+columnskField+>option value>Operator:/option>/select>/td>+ td idtd_condition_+columnskField+>input typetext idcondition_+columnskField+ placeholdercondition namecondition_+columnskField+ value />/td>td idtd_where_and_+columnskField+>; if(k columns.length -1) where_fields + select idwhere_and_+columnskField+ namewhere_and_+columnskField+>option value selected>Select:/option>option valueAND>AND/option>option valueOR>OR/option>option valueNOT>NOT/option>/select>; where_fields + /td>/tr>; $(where_fields).appendTo(#where_fields); $(#where select).attr(disabled,true); $(#where :text).attr(disabled,true); if( numeric.includes(type) ) { for(var j0; j operators.length;j++){ $(option/>, { value: operatorsj, html: operatorsj }).appendTo(#operator_+columnskField); } }else if( datetime.includes(type) ) { for(var j0; j operators.length;j++){ $(option/>, { value: operatorsj, html: operatorsj }).appendTo(#operator_+columnskField); } }else if( text_type.includes(type) ) { for(var j0; j operators.length;j++){ $(option/>, { value: operatorsj, html: operatorsj }).appendTo(#operator_+columnskField); } } else{ $(#operator_+columnskField).remove(); $(#condition_+columnskField).remove(); //$(#where_functions_+columnskField).remove(); } } //for loop for group by box for(var k0; k columns.length;k++){ var type columnskType.replace(/\(.*$/, ); $(tr>td>label forgroup_+columnskField+ styleword-wrap:break-word>input typecheckbox idgroup_+columnskField+ namegroup_+columnskField+ value+columnskField+ data+type+ />+columnskField+/label>/td>td idgroup_functions_+columnskField+>select idgroup_function_+columnskField+ namegroup_function_+columnskField+>option value>Select:/option>/select>/td>/tr>).appendTo(#group_fields); $(#group_by select).attr(disabled,true); if( numeric.includes(type) ) { for(var j0; j aggregate_func.length;j++){ $(option/>, { value: aggregate_funcj, html: aggregate_funcj }).appendTo(#group_function_+columnskField); } } else if( datetime.includes(type) ) { for(var j0; j date_func.length;j++){ $(option/>, { value: date_funcj, html: date_funcj }).appendTo(#group_function_+columnskField); } }else if( text_type.includes(type) ) { for(var j0; j text_func.length;j++){ $(option/>, { value: text_funcj, html: text_funcj }).appendTo(#group_function_+columnskField); } }else{ $(#group_function_+columnskField).remove(); } } //for loop for order by box for(var k0; k columns.length;k++){ var type columnskType.replace(/\(.*$/, ); $(tr>td>label fororder_+columnskField+ styleword-wrap:break-word>input typecheckbox idorder_+columnskField+ nameorder_+columnskField+ value+columnskField+ data+type+ />+columnskField+/label>/td>td idorder_functions_+columnskField+>select idorder_function_+columnskField+ nameorder_function_+columnskField+>option value>Select:/option>/select>/td>td>select idorder_asc_+columnskField+ nameorder_asc_+columnskField+>option valueASC selected>ASC/option>option valueDESC>DESC/option>/select>/td>/tr>).appendTo(#order_fields); $(#order_by select).attr(disabled,true); if( numeric.includes(type) ) { for(var j0; j aggregate_func.length;j++){ $(option/>, { value: aggregate_funcj, html: aggregate_funcj }).appendTo(#order_function_+columnskField); } } else if( datetime.includes(type) ) { for(var j0; j date_func.length;j++){ $(option/>, { value: date_funcj, html: date_funcj }).appendTo(#order_function_+columnskField); } }else if( text_type.includes(type) ) { for(var j0; j text_func.length;j++){ $(option/>, { value: text_funcj, html: text_funcj }).appendTo(#order_function_+columnskField); } }else{ $(#order_function_+columnskField).remove(); } } } var select_array ; var select_func_array ; var where_array ; var where_operator_array ; var group_array ; var order_array ; $(#table_fields inputtypecheckbox).change(function (e) { $(#db_function_+$(this). attr(id)).attr(disabled,true); $(#db_function_+$(this). attr(id)).val().change(); $(#alias_+$(this). attr(id)).attr(disabled,true); $(#alias_+$(this). attr(id)).val(); //select_func_array.pop() select_array ; // loop through siblings $(#table_fields :checkbox:checked).each(function () { select_array.push($(this).val() ); $(#db_function_+$(this). attr(id)).attr(disabled,false); $(#alias_+$(this). attr(id)).attr(disabled,false); }); }); $(#where_fields inputtypecheckbox).change(function (e) { where_array ; $(#operator_+$(this).val()).attr(disabled, true); $(#operator_+$(this).val()).val().change(); $(#condition_+$(this).val()).attr(disabled, true); $(#condition_+$(this).val()).val(); $(#where_and_+$(this).val()).attr(disabled, true); $(#where_and_+$(this).val()).val().change(); // loop through siblings (customize selector to your needs) $(#where :checkbox:checked).each(function () { where_array.push($(this).val()); $(#operator_+$(this).val()).attr(disabled, false); $(#condition_+$(this).val()).attr(disabled, false); $(#where_and_+$(this).val()).attr(disabled, false); }); }); $(#where_fields select).on(change, function() { $(#where_fields :checkbox:checked).each(function () { where_operator_array.push($(this).val()); }); }); $(#group_fields inputtypecheckbox).change(function (e) { group_array ; $(#group_function_+$(this).val()).attr(disabled, true); $(#group_function_+$(this).val()).val().change(); // loop through siblings (customize selector to your needs) $(#group_fields :checkbox:checked).each(function () { group_array.push($(this).val()); $(#group_function_+$(this).val()).attr(disabled, false); }); }); $(#order_fields inputtypecheckbox).change(function (e) { order_array ; $(#order_function_+$(this).val()).attr(disabled, true); $(#order_function_+$(this).val()).val().change(); $(#order_asc_+$(this).val()).attr(disabled, true); $(#order_asc_+$(this).val()).val(ASC); $(#order_asc_+$(this).val()).change(); // loop through siblings (customize selector to your needs) $(#order_fields :checkbox:checked).each(function () { order_array.push($(this).val()); $(#order_function_+$(this).val()).attr(disabled, false); $(#order_asc_+$(this).val()).attr(disabled, false); }); }); $(#query_box inputtypecheckbox, #limit_box inputtyperadio, #query_box select, #query_box inputtypetext).change(function (e) { var select_part; var select_func_part; var table_part; var where_part; var group_part; var order_part; var limit_part; var limit $(inputnamelimit:checked).val(); selected_query_fields ; selected_query_alias ; selected_query_types ; if(select_array.length > 0) { select_part SELECT ; selected_query_columns ; for(var i0; i select_array.length;i++){ var selected_func $(#db_function_+ select_arrayi ).find(:selected).val(); var selected_alias $(#alias_+ select_arrayi ).val(); if( selected_func ! ) { select_part + \n +selected_func+(+select_arrayi+); if( selected_alias ! ) { select_part + AS +selected_alias; } }else if( selected_alias ! ) { select_part + \n +select_arrayi + AS +selected_alias; }else { select_part + \n +select_arrayi; } selected_query_fields.push(select_arrayi); selected_query_alias.push(selected_alias); selected_query_types.push( $(#+select_arrayi).attr(data) ); if(i (select_array.length - 1) ) select_part + , ; } } if(from_table ! 0 && select_array.length ! 0) table_part \nFROM + from_table; if(where_array.length > 0 && select_array.length ! 0) { where_part \nWHERE ; for(var i0; i where_array.length;i++){ var where_operator $(#operator_+ where_arrayi ).find(:selected).val(); var where_condition $(#condition_+ where_arrayi ).val(); var where_and $(#where_and_+ where_arrayi ).find(:selected).val(); if( where_operator ! && where_condition!) { where_part + where_arrayi+ +where_operator+ +where_condition; } if(i (where_array.length - 1) && where_and! ) where_part + +where_and+ ; } } //if(where_array.length ! 0 && select_array.length ! 0) where_part \nWHERE + where_array.join(, ); if(group_array.length > 0 && select_array.length ! 0) { group_part \nGROUP BY ; for(var i0; i group_array.length;i++){ var group_function $(#group_function_+ group_arrayi ).find(:selected).val(); if( group_function ! ) { group_part + group_function+(+group_arrayi+); } else{ group_part + group_arrayi; } if(i (group_array.length - 1) ) group_part + , ; } } // if(group_array.length ! 0 && select_array.length ! 0) group_part \nGROUP BY + group_array.join(, ); if(order_array.length > 0 && order_array.length ! 0) { order_part \nORDER BY ; for(var i0; i order_array.length;i++){ var order_function $(#order_function_+ order_arrayi ).find(:selected).val(); var order_asc $(#order_asc_+ order_arrayi ).find(:selected).val(); if( order_function ! ) { order_part + order_function+(+order_arrayi+) + + order_asc; } else{ order_part + order_arrayi + + order_asc; } if(i (order_array.length - 1) ) order_part + , ; } } // if(order_array.length ! 0 && select_array.length ! 0) order_part \nORDER BY + order_array.join(, ); if(limit ! all && select_array.length ! 0) limit_part \nLIMIT 0, + limit; else limit_part ; var sql_query select_part + table_part + where_part + group_part + order_part + limit_part; $(#mysql_query).html(sql_query); if(sql_query ! ) { $(#bt_search).attr(disabled,false); $(.map_box).removeClass(hide).show(); $(#chart_columns .warning-msg).hide(); // console.log(selected types: +JSON.stringify(selected_query_types)); if( selected_query_types.length > 1 && text_type.includes(selected_query_types1) ){ var msg i classfa fa-warning>/i> Warning: Data column(s) for axis #0 cannot be of type string. Current selected column is: ; msg + selected_query_fields1+ coulmn type is +selected_query_types1; $(#chart_columns .warning-msg).html(msg).fadeIn(300); } else if( selected_query_types.length > 2 && selected_query_types1 ! selected_query_types2){ var msg i classfa fa-warning>/i> Warning: All series on a given axis must be of the same data type. Current selected columns are: ; for(var i1; i selected_query_types.length; i++){ msg + selected_query_fieldsi+ coulmn type is +selected_query_typesi; if(i selected_query_types.length - 1) msg + , ; } $(#chart_columns .warning-msg).html(msg).fadeIn(300); } } else { $(#bt_search).attr(disabled,true); } }); }); } } function searchResults(obj_data){ var dataOpt obj_data; for(var i0; i dataOpt.length;i++){ var results $.parseJSON(JSON.stringify(dataOpt)); } } $(#bt_table).click(function(){ $(#db_table option:not(:first)).remove(); var formData { //Fetch form data host: $(#mysql_host).val(), database: $(#mysql_database).val(), username: $(#mysql_username).val(), password: $(#mysql_password).val(), type: tables }; var url https://db-tool.parorrey.com/api.php; // Process the call $.ajax({ type : POST, // Define the type of HTTP verb we want to use url : url, // The URL where we want to POST data : formData, // Our data object dataType : json, // What type of data do we expect back. beforeSend : function() { // before sending an Ajax request. }, success:function(response){ var obj eval(response); if(obj.successtrue) { if(obj.data){ $(#fetch_tables .success-msg).fadeIn(300).delay(3000).fadeOut(300); fetchTables(obj.data); } } }, complete : function() { }, error:function (xhr, ajaxOptions, thrownError){ $(#fetch_tables .error-msg).fadeIn(300).delay(3000).fadeOut(300); // If any error occurs in request } }); }); //search request $(#bt_search).click(function(){ //alert( fields:+JSON.stringify(selected_query_fields)); var formData { //Fetch form data host: $(#mysql_host).val(), database: $(#mysql_database).val(), username: $(#mysql_username).val(), password: $(#mysql_password).val(), mysql_query: $(#mysql_query).val(), table: $(#db_table).find(:selected).val(), // data: {fields: JSON.stringify(selected_query_columns)}, fields: selected_query_fields.join(,), fields_alias: selected_query_alias.join(,), fields_types: selected_query_types.join(,), type: search }; var url https://db-tool.parorrey.com/api.php; var chart_args ; chart_argsbg_color $(#chart_bg_color).find(:selected).val(); chart_argstype $(inputnamechart_type:checked).val(); //alert(selected_query_columns: +JSON.stringify(selected_query_columns)); // Process the call $.ajax({ type : POST, // Define the type of HTTP verb we want to use url : url, // The URL where we want to POST data : formData, // Our data object dataType : json, // What type of data do we expect back. beforeSend : function() { // before sending an Ajax request. }, success:function(response){ var obj eval(response); if(obj.successtrue) { if(obj.data){ var title $(#db_table).find(:selected).val().replace(/_/g, ); drawChart(title, obj.data, chart_args); //searchResults(obj.data); $(#chart_box inputtyperadio, #chart_bg_color).change(function (e) { chart_argsbg_color $(#chart_bg_color).find(:selected).val(); chart_argstype $(inputnamechart_type:checked).val(); drawChart(title, obj.data, chart_args); }); } } }, complete : function() { }, error:function (xhr, ajaxOptions, thrownError){ $(#fetch_chart .error-msg).append(thrownError).fadeIn(300).delay(3000).fadeOut(300); // If any error occurs } });}); }); /script> /body>/html>
View on OTX
|
View on ThreatMiner
Please enable JavaScript to view the
comments powered by Disqus.
Data with thanks to
AlienVault OTX
,
VirusTotal
,
Malwr
and
others
. [
Sitemap
]