digi-gov.com / 127.0.0.1 / lgis_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 - 24 (242 total, Query took 0.0006 seconds.)

SELECT * FROM `online_application_docs`

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

Filter rows:

			id	app_id	docs_id	file_size	file_name	file_path	file_full_path	entry_type	ts	stat	guidx
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 1	1	NULL	27	45944	ACCOUNTING.png	99e04129ae8fe8c9ec3569577b1fe91da6a63ce67f7467cad6...	NULL	Filled-Up Application Form	2022-12-02 14:22:29	0	lb649av3bx18ftw34v
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 2	2	NULL	14	757	ARROW.png	48a1da4fb9d0be7435348ef20d5b934b2517a9cd342993ee98...	NULL	DTI Registration	2022-12-02 14:22:37	0	lb649av3bx18ftw34v
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 3	3	NULL	29	79982	blss2.jpg	7df77026de9868bc98387fc5f838f6608b9a06b9853e372f03...	NULL	Barangay Business Clearance	2022-12-02 14:22:44	0	lb649av3bx18ftw34v
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 4	4	NULL	35	358676	Camp 4.png	7295a0411ab9b884b9f7d4eaff925199438d7868b7c1db89ed...	NULL	Pag-ibig Registration	2022-12-02 14:22:51	0	lb649av3bx18ftw34v
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 5	5	NULL	36	5936	bulacao.jpg	a0f5242df347c3376575378f8d07d1823faa7fa4ee3de28124...	NULL	PhilHealth Registration	2022-12-02 14:22:58	0	lb649av3bx18ftw34v
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 6	6	NULL	36	144855	LDRRMO.jpg	2baf27b352aac3fdce9df7026c8655d6b7078d3e886fa3148c...	NULL	PhilHealth Registration	2022-12-06 09:32:14	0	lbbjfl56yum71y5bn0p
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 7	7	NULL	29	81269	anuimation.jpg	643c1fde5e47c817c72193d2f90950ed35977b1931a83d23a1...	NULL	Barangay Business Clearance	2022-12-09 10:59:03	0	lbfx25bs4klno4h4wlb
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 8	8	NULL	29	6	sample.txt	534d3a083801ad5a6529169c12465547602eb9856920935df8...	NULL	Barangay Business Clearance	2022-12-12 15:15:33	0	lbkg5ukqrwwgh5gqxn
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 9	9	NULL	29	173125	nagacebu_brand_logo.png	e816c59664f004b6eadc4c85a670c0cbb59e4d8edd5a024f4a...	NULL	Barangay Business Clearance	2022-12-20 09:48:10	0	lbvkbxblkdlbkidrn3
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 10	10	NULL	21	1644469	BP CERT058.jpg	48ef7856d6dcb15dc30e500e297bfe38dc53f71aec357fc18f...	NULL	Old Business Permit	2022-12-27 11:32:30	0	lc5mxwf17oj0dbwwha3
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 11	11	NULL	14	93129	BN_CERTIFICATE-HKJG460114208225.pdf	fde8a8108092331cf77ed9ac376cf6fa280825dc01c5987147...	NULL	DTI Registration	2022-12-31 23:04:17	0	lcc2i8k0r081jh61tje
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 12	12	NULL	21	42837	Screenshot 2023-01-03 123051.jpg	99b5277e3809e1aed8fb3e7263fede66f007e8932afa2c5e3b...	NULL	Old Business Permit	2023-01-03 12:32:24	0	lcfjokcokpcwevdplpa
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 13	13	NULL	29	31089	Screenshot 2023-01-03 123126.jpg	47e6f023a460151597dc2bb56012c7abc0c91073118f007fe8...	NULL	Barangay Business Clearance	2023-01-03 12:33:49	0	lcfjokcokpcwevdplpa
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 14	14	NULL	4	38871	Screenshot 2023-01-03 123019.jpg	74798f644975b2a9b0ceecdf4c948197c1491263adf6bf2d16...	NULL	Fire Safety Inspection Certificate	2023-01-03 12:34:12	0	lcfjokcokpcwevdplpa
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 15	15	NULL	29	91609	BARANGAY CLEARANCE.jpg	cad715e048941e6c2213cb980cbbe6cc8de981c83e70de584f...	NULL	Barangay Business Clearance	2023-01-04 22:39:26	0	lchqrqhvim1v2wmejqm
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 16	16	NULL	31	56964	CONTRACT LEASE.jpg	bb3346cb058d801bd4b665bc307cfccad4230d055ad74acbcb...	NULL	Contract of Lease	2023-01-04 22:40:36	0	lchqrqhvim1v2wmejqm
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 17	17	NULL	8	262447	COMMUNITY TAX CERT.jpg	f5bb2a52597b7172350140a425c91cb8e59a5da792997e3b1b...	NULL	Community Tax Certificate - Individual	2023-01-04 22:42:53	0	lchqrqhvim1v2wmejqm
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 18	18	NULL	21	108701	BUSINESS PERMIT.jpg	97131c9b2767f787bac6a3c1cb0c94fff91aa577395f7ce269...	NULL	Old Business Permit	2023-01-04 22:43:47	0	lchqrqhvim1v2wmejqm
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 19	19	NULL	4	129496	FIRE INSPECTION CERT.jpg	e42dbe3e184cf9c0fa0aa016a4316cb4ed5305598ddebd2d82...	NULL	Fire Safety Inspection Certificate	2023-01-04 22:44:25	0	lchqrqhvim1v2wmejqm
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 20	20	NULL	21	436734	Excelsior Consultancy Services Business Permit 202...	9e96f7191345c96bd37a551d67ce237f988aea28d8e89629de...	NULL	Old Business Permit	2023-01-05 10:11:25	0	lcifi4nnej9o0n7biqj
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 21	21	NULL	36	354127	ECS Philhealth.pdf	d318b4dd3f4ce5ed49c698f01078ae5dc993eaad22ade1706b...	NULL	PhilHealth Registration	2023-01-05 10:11:48	0	lcifi4nnej9o0n7biqj
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 22	22	NULL	33	10765	Hannahs tabunok sales 2022.xlsx	b4f62125fa07769a7c68aa2b78941cc7ec1bcfcce3e8a09177...	NULL	Monthly Gross Income Statement or ITR	2023-01-05 13:46:44	0	lcii4uahyy5cf1zgl7
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 23	23	NULL	21	288261	business permit tabunok 2022.jpg	d1f9ffe3cc85c72d22147d3982b36ecad6eb3993eeaefde8b9...	NULL	Old Business Permit	2023-01-05 13:50:16	0	lcii4uahyy5cf1zgl7
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 24	24	NULL	4	340221	fire safety tabunok.jpg	3c4452ddb2356dbddc13feef7a091772a8da9917ac56f2c03b...	NULL	Fire Safety Inspection Certificate	2023-01-05 13:50:51	0	lcii4uahyy5cf1zgl7
Edit	Copy	Delete DELETE FROM online_application_docs WHERE `online_application_docs`.`id` = 25	25	NULL	4	340221	fire safety tabunok.jpg	4366d0e0db6cc7d8c153b6c698c23675b7c57b0b3a7741ee6e...	NULL	Fire Safety Inspection Certificate	2023-01-05 13:50:52	0	lcii4uahyy5cf1zgl7

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.