digi-gov.com / 127.0.0.1 / lgis_dum_app / online_application_docs

There are no favorite tables.

New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
- lgis_app
- lgis_dum_app
lgu_repository
mysql
online_hr
performance
- performance_management
- performance_schema
qpsii
queue
repository
service_request_db

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 17 (18 total, Query took 0.0004 seconds.)

SELECT * FROM `online_application_docs`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id	cash_id	app_id	docs_id	file_size	file_name	file_path	file_full_path	entry_type	ts	stat	guidx	payment_refno
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 1	1	NULL	NULL	8	137857	Bogo_City_logo.png	c20cfc6db371b83dfce26b8fb39b70cdb5b65a7572ff47bf79...	NULL	Community Tax Certificate - Individual	2024-08-20 13:25:41	0	m01zcza5jqevk5xlxf	NULL
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 2	2	NULL	NULL	31	137857	Bogo_City_logo.png	3ed7f4e9e95ca32fb05978c5df3c213be144e952ddcb07e13b...	NULL	Contract of Lease	2024-08-20 13:25:48	0	m01zcza5jqevk5xlxf	NULL
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 3	3	NULL	NULL	20	137857	Bogo_City_logo.png	b7c4acd7393be160d8a22a8522773d185a4504e40bea31d486...	NULL	SSS Registration	2024-08-20 13:25:56	0	m01zcza5jqevk5xlxf	NULL
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 4	4	NULL	NULL	18	137857	Bogo_City_logo.png	45691a9b07a7046046d74f9f655ee1ec81f5cc0a5c4e9ce7a9...	NULL	BIR Registration	2024-08-20 13:26:02	0	m01zcza5jqevk5xlxf	NULL
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 5	5	NULL	NULL	31	137857	Bogo_City_logo.png	caa25f9a5884e68cd9d50cde22c0920b39db7e67d589be96eb...	NULL	Contract of Lease	2024-08-20 13:29:01	0	m01zhir2ikq6ruhj4u9	NULL
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 6	6	NULL	NULL	38	137857	Bogo_City_logo.png	dda930b97fc25c33aee9d2431f01df48158487e31f0a762d8d...	NULL	Authorization Letter	2024-08-20 13:29:09	0	m01zhir2ikq6ruhj4u9	NULL
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 7	7	NULL	NULL	39	137857	Bogo_City_logo.png	c40e10e2740fdbfd4c7f22f52c548b6a543649f523f2163ec7...	NULL	Vicinity Map	2024-08-20 13:29:16	0	m01zhir2ikq6ruhj4u9	NULL
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 8	8	NULL	NULL	18	137857	Bogo_City_logo.png	75718bb8f8ec0b956a9b3b6041a1a00138fa8ff6b5cffce6e3...	NULL	BIR Registration	2024-08-20 13:29:22	0	m01zhir2ikq6ruhj4u9	NULL
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 10	10	NULL	1	NULL	137857	Bogo_City_logo.png	bf6b8c91a5b6a5a4aed2373ef6fcede9af9f1b1d32eac5d03c...	NULL	GCASH	2024-08-20 15:09:38	0	NULL	Ref-01235
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 11	11	NULL	1	NULL	7672	motorcar.png	7b9f7071b70105050243aa90eb3429c9e83164015b367f7e4e...	NULL	GCASH	2024-08-20 15:10:36	0	NULL	Ref-01236
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 12	12	NULL	1	NULL	11484	motorbike.png	c06cf959b437dd2de3c1f3812d3ab17dd751c1f0ed41500394...	NULL	GCASH	2024-08-27 15:33:41	0	NULL	Ref-0141
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 13	13	3	2	NULL	9440	images.jfif	c266c98ea0c703a389fec59451616062ff35acc983659e1e79...	NULL	GCASH	2024-09-03 10:39:17	0	NULL	asd
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 14	14	4	2	NULL	11484	motorbike.png	c3f12c220786c3ab2bff26e4a89ea0f8fa8a6441094f4dec53...	NULL	GCASH	2024-09-03 10:40:15	0	NULL	sample
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 15	15	5	2	NULL	19112	vehicle.png	91144b94fe13e52dc6600a0245a504b868cced11ded390b435...	NULL	GCASH	2024-09-03 11:07:31	0	NULL	131
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 16	16	6	2	NULL	9440	images.jfif	e67483cc58470f30085bc54a3c43cd90f50c8b73b4994de822...	NULL	GCASH	2024-09-03 11:15:33	0	NULL	1111
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 17	17	6	2	NULL	7672	motorcar.png	e67483cc58470f30085bc54a3c43cd90f50c8b73b4994de822...	NULL	GCASH	2024-09-03 11:15:33	0	NULL	1111
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 18	18	NULL	2	NULL	137857	Bogo_City_logo.png	40afd3c365b4bf8d37a2d206d0751ab3d2e9b628dcfb80a7d7...	NULL	GCASH	2024-09-03 13:14:23	0	NULL	asdg
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 19	19	10	2	NULL	434246	pxfuel.jpg	649d76ddeb20f5c99451d6dd5bff9583867337d2657ad91de6...	NULL	GCASH	2024-09-03 13:19:12	0	NULL	mmy

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.