digi-gov.com / 127.0.0.1 / db_meter_readings / tbl_electric_bill_new1

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

SELECT * FROM `tbl_electric_bill_new1`

[ 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	rate_per_meter
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 1	1	4	1	2	0	0		0	PM-10-0002-2024	Preda ,Nelson E	SN 02	RESIDENTIAL	wmn02	6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202411b059630f-5c91-44c6-a1f2-3b1d763e8536	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 2	2	4	1	3	0	0		0	PM-10-0003-2024	Preda ,Nelson E	SN 03	RESIDENTIAL	wmn03	6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	20241104edf065-32d5-4fc2-a7bc-f792939d930a	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 3	3	4	1	4	0	0		0	PM-10-0004-2024	Cobol ,Jessa Mae D.	SN 04	RESIDENTIAL	wmn04	6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202411ef64051c-0c3e-4f24-b64a-0c974bd3c0a6	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 4	4	4	1	5	0	0		0	PM-10-0005-2024	Medina ,Marilou B.	SN 05	RESIDENTIAL	wmn05	6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202411fa54f2ff-f08d-4f04-b8a8-02ac80ccad03	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 5	5	4	1	6	0	0		0	PM-10-0006-2024	Veloso ,Flent G.	SN 01	RESIDENTIAL	WNO1	15	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	20241161af0de4-6430-4290-8e8d-a2658104bbb8	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 6	6	4	1	7	0	0		0	PM-10-0007-2024	Ypana ,Emily Igot	SN 06	RESIDENTIAL	wmn06	6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	2024117b1bbfcc-a970-444c-9bd7-b39d25b2cb23	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 7	7	4	1	8	0	0		0	PM-10-0008-2024	Gimarino ,Ma. Regla	SN 07	RESIDENTIAL	wmn07	6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	2024110af751d9-8d19-4808-a20d-6f968ae92fe1	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 8	8	4	1	9	0	0		0	PM-10-0009-2024	Maravilles ,Loreta	SN 08	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202411ea944a2b-1f6c-41e2-9905-26b9dc6c32b9	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 9	9	4	1	10	0	0		0	PM-10-0010-2024	Basoy ,Jennifer	SN 02	RESIDENTIAL	WNO2	15	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	2024114b5ca042-9d1e-4886-8f14-b4334c64185a	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 10	10	4	1	11	0	0		0	PM-10-0011-2024	Cereneo ,Rheamae Aninon	SN 09	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202411cbbb4fd9-ac2d-421b-be89-c81cec0d1e25	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 11	11	4	1	12	0	0		0	PM-10-0012-2024	Rafuela ,Aireen	SN 10	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	20241141a60129-4ebb-4856-9b35-84fdb9f098dc	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 12	12	4	1	13	0	0		0	PM-10-0013-2024	Escoreal ,Teresita Aniñon	SN 11	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	2024110309a252-5ba8-4de9-9339-ddc0e031e7b2	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 13	13	4	1	14	0	0		0	PM-10-0014-2024	Maravilles ,Jessel Padillo	SN 12	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	20241122fa697a-2c49-43a1-b882-9b79f6ae866a	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 14	14	4	1	15	0	0		0	PM-10-0015-2024	Amit ,Florabel B.	SN 04	RESIDENTIAL	WNO4	15	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202411930a63fd-c23f-4521-b46f-7232db8111d1	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 15	15	4	1	16	0	0		0	PM-10-0016-2024	Blanco ,Ma. Gasparena	SN 13	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	2024112a519082-8a7d-4ecc-b824-fe9b718cc8ca	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 16	16	4	1	17	0	0		0	PM-10-0017-2024	Aniñon ,Carlo Niño P.	SN 14	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	2024119dc75985-85bb-4e94-acc6-b0c3d2feac7c	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 17	17	4	1	18	0	0		0	PM-10-0018-2024	Cereneo ,Anecita A.	SN 15	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	20241131f4b8fd-ab62-4eb2-9e97-d280a61ca507	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 18	18	4	1	19	0	0		0	PM-10-0019-2024	Ugbamen ,Belinda L.	SN 05	RESIDENTIAL	WN05	15	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202411ba2557f7-9f2c-4242-b2bc-0f32ddbd62a7	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 19	19	4	1	20	0	0		0	PM-10-0020-2024	Defiesta ,Rhodora A.	SN 16	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	2024117f0ba3e6-43ad-4eee-b247-6099e3004ab1	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 20	20	4	1	21	0	0		0	PM-10-0021-2024	Ybañez ,Diony G.	SN 17	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	2024114f6a14f7-2480-4458-8740-d7302a272a12	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 21	21	4	1	22	0	0		0	PM-10-0022-2024	Torquido ,Rajie M.	SN 18	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	2024119ab8be04-7fde-480f-8d84-5897cc274145	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 22	22	4	1	23	0	0		0	PM-10-0023-2024	Blanco ,Riche	SN 06	RESIDENTIAL	WN06	15	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202411249872b0-e0aa-477d-be42-cebc28f4822a	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 23	23	4	1	24	0	0		0	PM-10-0024-2024	Fernandez ,Hazel Q.	SN 19	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202411817135b0-fdc0-4301-92a7-cef7a466e730	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 24	24	4	1	25	0	0		0	PM-10-0025-2024	Cobalqinto ,Francisca	SN 20	RESIDENTIAL		6.25	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	20241112e43a96-7c1d-4cdf-9a4c-eec81fc813db	0	0	0	0	FALSE	23.000
Edit	Copy	Delete DELETE FROM tbl_electric_bill_new1 WHERE `tbl_electric_bill_new1`.`bn_id` = 25	25	4	1	26	0	0		0	PM-10-0026-2024	Dabon ,Hazel M.	SN 07	RESIDENTIAL	WN07	5.5	FALSE	0	0	0		NULL	0	0	0	0	0	0	0	NULL	UNBILLED	NULL	NULL	NULL	202411911d88f7-90a8-4aaf-8d23-b8d3d521d4d1	0	0	0	0	FALSE	23.000

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.