digi-gov.com / 127.0.0.1 / db_meter_readings / tbl_water_bill_new

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 (272 total, Query took 0.0029 seconds.)

SELECT * FROM `tbl_water_bill_new`

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

Filter rows:

			bn_id	sched_id	type_id	app_id	cust_id	mter_id	rem_id	chm_id	ACCOUNT NO	ACCOUNT NAME	ADDRESS	CLASS	METER NO	ROUTE NO	SC	SC DIS	AVE CUM	CUT OFF CUM	PREV RDNG	PRES RDNG	CONSUMPTION	CURRENT BILL	PREV BAL	OTHER CHARGE	SC AMOUNT	POWER COST AMOUNT	TOTAL AMOUNT	REMARKS	STATUS	READ	DATE SAVED	DATE UPLOADED	BILL NO	size_id	zone_id	book_id	other_bill	discounted
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 1	1	61	1	6	6	6	0	0	LIO-0439	CATARAJA, ELENA	Liong	RESIDENTIAL	LIO-0439		FALSE	0	28	0	878	890	12	200	1115	0	0	0	1315	NULL	BILLED	True	2025-02-28 00:00:00	2025-03-03 00:00:00	202503001069	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 2	2	61	1	25	25	25	0	0	LIO-0450	SINGH, JENNY R.	Liong	RESIDENTIAL	LIO-0450		FALSE	0	51	0	316	371	55	1310	1190	0	0	0	2500	NULL	BILLED	True	2025-02-27 00:00:00	2025-03-03 00:00:00	202503001070	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 3	3	61	1	36	36	36	0	0	LIO-0455	MAMAC, ROMEL	Liong	RESIDENTIAL	LIO-0455		FALSE	0	0	0	451	463	12	200	0	0	0	0	200	NULL	BILLED	True	2025-02-28 00:00:00	2025-03-03 00:00:00	202503001071	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 4	4	61	1	38	37	38		0	LIO-0456	SAYSON, BENROSE	Liong	RESIDENTIAL	LIO-0456		FALSE	0	8	0	479	NULL	0	0	160	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202503001072	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 5	5	61	1	68	60	68	0	0	LIO-0316	PASIGNASIGNA, JUNAH MAE	Liong	RESIDENTIAL	LIO-0316		FALSE	0	-782	0	1621	1643	22	410	160	0	0	0	570	NULL	BILLED	True	2025-02-27 00:00:00	2025-03-03 00:00:00	202503001073	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 6	6	61	1	70	62	70	0	0	LIO-0317	PASIGNASIGNA, GEMMA	Liong	RESIDENTIAL	LIO-0317		FALSE	0	22	0	1040	1066	26	510	410	0	0	0	920	NULL	BILLED	True	2025-02-27 00:00:00	2025-03-03 00:00:00	202503001074	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 7	7	61	1	73	65	73		0	LIO-0318	PASIGNASIGNA, ALBERTA	Liong	RESIDENTIAL	LIO-0318		FALSE	0	-2803	0	2803	NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202503001075	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 8	8	61	1	80	72	80	1	0	LIO-0323	PATILUNA, ROEL	Liong	RESIDENTIAL	LIO-0323		FALSE	0	6	0	1605	1612	7	160	270	0	0	0	430	NORMAL READING	BILLED	True	2025-02-27 00:00:00	2025-03-03 00:00:00	202503001076	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 9	9	61	1	84	75	84		0	LIO-0463	SINGSON, MARIBETH	Liong	RESIDENTIAL	LIO-0463		FALSE	0	0	0	0	NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202503001077	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 10	10	61	1	85	76	85	0	0	LIO-0325	PAYOD, DIEGO	Liong	RESIDENTIAL	LIO-0325		FALSE	0	49	0	8941	8989	48	1100	1130	0	0	0	2230	NULL	BILLED	True	2025-02-28 00:00:00	2025-03-03 00:00:00	202503001078	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 11	11	61	1	91	82	91	0	0	LIO-0328	PESALBON, ERNING	Liong	RESIDENTIAL	LIO-0328		FALSE	0	28	0	1849	1881	32	660	560	0	0	0	1220	NULL	BILLED	True	2025-02-28 00:00:00	2025-03-03 00:00:00	202503001079	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 12	12	61	1	112	103	112		0	LIO-0340	QUIRANTE, BELINDA/JOSEPH CLARENCE	Liong	RESIDENTIAL	LIO-0340		FALSE	0	0	0	0	NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202503001080	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 13	13	61	1	114	105	114	0	0	LIO-0341	QUIRANTE, AVELINO	Liong	RESIDENTIAL	LIO-0341		FALSE	0	21	0	5043	5066	23	435	385	0	0	0	820	NULL	BILLED	True	2025-02-27 00:00:00	2025-03-03 00:00:00	202503001081	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 14	14	61	1	115	106	115	0	0	LIO-0342	RAÑADA, MARY ROSE	Liong	RESIDENTIAL	LIO-0342		FALSE	0	8	0	533	541	8	160	160	0	0	0	320	NULL	BILLED	True	2025-02-27 00:00:00	2025-03-03 00:00:00	202503001082	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 15	15	61	1	117	108	117	0	0	LIO-0343	REDERA, ANTONIO	Liong	RESIDENTIAL	LIO-0343		FALSE	0	13	0	1209	1225	16	280	220	0	0	0	500	NULL	BILLED	True	2025-02-28 00:00:00	2025-03-03 00:00:00	202503001083	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 16	16	61	1	122	113	122	0	0	LIO-0346	RICONALLA, RIZA	Liong	RESIDENTIAL	LIO-0346		FALSE	0	9	0	2614	2621	7	160	160	0	0	0	320	NULL	BILLED	True	2025-02-28 00:00:00	2025-03-03 00:00:00	202503001084	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 17	17	61	1	156	147	156		0	ILA-0235	MARCO, FREDESWINDA	Ilaya	RESIDENTIAL	ILA-0235		FALSE	0	25	0	411	NULL	0	0	685	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202503001085	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 18	18	61	1	171	162	171	0	0	LIO-0360	PRISCILLA SALVADOR	Liong	RESIDENTIAL	LIO-0360		FALSE	0	58	0	2559	2623	64	1600	1400	0	0	0	3000	NULL	BILLED	True	2025-02-28 00:00:00	2025-03-03 00:00:00	202503001086	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 19	19	61	1	183	174	183		0	LIO-0363	ROXAS, CHONA/ALLAN-M1	Liong	RESIDENTIAL	LIO-0363		FALSE	0	0	0	0	NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202503001087	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 20	20	61	1	205	195	205	0	0	LIO-0367	SAGAYNO, JASMIN	Liong	RESIDENTIAL	LIO-0367		FALSE	0	9	0	157	167	10	160	160	0	0	0	320	NULL	BILLED	True	2025-02-27 00:00:00	2025-03-03 00:00:00	202503001088	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 21	21	61	1	210	201	210		0	LIO-0368	SALA, JULES	Liong	RESIDENTIAL	LIO-0368		FALSE	0	0	0	0	NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202503001089	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 22	22	61	1	218	209	218	0	0	LIO-0370	SAMMUEL, CASIPONG	Liong	RESIDENTIAL	LIO-0370		FALSE	0	23	0	2052	2077	25	485	435	0	0	0	920	NULL	BILLED	True	2025-02-27 00:00:00	2025-03-03 00:00:00	202503001090	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 23	23	61	1	237	228	237	0	0	LIO-0371	SANDOVAL, ANA-M1	Liong	RESIDENTIAL	LIO-0371		FALSE	0	11	0	1846	1857	11	180	180	0	0	0	360	NULL	BILLED	True	2025-02-28 00:00:00	2025-03-03 00:00:00	202503001091	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 24	24	61	1	246	237	246	0	0	LIO-0372	SANDOVAL, ANA-M2	Liong	RESIDENTIAL	LIO-0372		FALSE	0	0	0	498	498	0	160	160	0	0	0	320	NULL	BILLED	True	2025-02-28 00:00:00	2025-03-03 00:00:00	202503001092	2	2	1	0	FALSE
Edit	Copy	Delete DELETE FROM tbl_water_bill_new WHERE `tbl_water_bill_new`.`bn_id` = 25	25	61	1	254	245	254	0	0	LIO-0374	SANTILLAN, MARITES	Liong	RESIDENTIAL	LIO-0374		FALSE	0	20	0	133	158	25	485	360	0	0	0	845	NULL	BILLED	True	2025-02-27 00:00:00	2025-03-03 00:00:00	202503001093	2	2	1	0	FALSE

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.