digi-gov.com / 127.0.0.1 / accounting / law_client

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 - 23 (24 total, Query took 0.0329 seconds.)

SELECT * FROM `law_client`

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

Filter rows:

			patient_id	pp_code	company_name	trade_name	prefix	fname	lname	mname	suffix	address	phone	sex	birth_date	blood_group	contact_person	ts	status	save_type
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 1	1	0	NULL	NULL	NULL	Maria Evon	Mirafuentes	Laput	NULL	Purok Tres Inayagan City of Naga Cebu	0976 657 4536	Female	1990-11-01	NULL	[email protected]	2019-11-26 08:26:25	CANCELLED	ClientPerson
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 2	2	0	NULL	NULL	NULL	Angelina	Cabriana	Banzon	NULL	Purok Dos East Poblacion City of Naga Cebu	0987 567 5463	Female	1990-11-01	NULL	[email protected]	2019-11-26 08:28:00	ACTIVE	ClientPerson
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 3	3	0	NULL	NULL	NULL	May Kay	Dela Cruz	Montecillo	NULL	Purok Daisy North Poblacion City of Naga Cebu	0978 657 2345	Female	1990-01-01	NULL	[email protected]	2019-11-26 08:29:44	ACTIVE	ClientPerson
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 4	4	45	NULL	NULL	NULL	Myrna	Ubay	Villafuerte	NULL	East Poblacion City of Naga Cebu	0927 876 3654	Female	1989-01-21	NULL	[email protected]	2019-11-26 08:30:22	ACTIVE	ClientPerson
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 5	5	5	NULL	NULL	NULL	Andresito	Canonigo	Villafuerte	NULL	East Poblacion City of Naga Cebu	0912 678 2767	Male	1989-01-21	NULL	[email protected]	2019-11-26 08:31:08	CANCELLED	ClientPerson
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 6	6	NULL	ABC Company	ABC Company	NULL	NULL	NULL	NULL	NULL	East Poblacion City of Naga Cebu	0976 567 3546	NULL	NULL	NULL	Richard Sator Ubas	2019-11-26 08:38:26	CANCELLED	ClientCompany
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 7	7	NULL	XYZ Corporation	XYZ Corporation	NULL	NULL	NULL	NULL	NULL	East Poblacion City of Naga Cebu	0987 657 7890	NULL	NULL	NULL	Maria Leny Lapuy	2019-11-26 08:39:41	ACTIVE	ClientCompany
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 8	8	NULL	EFG General Services	EFG General Services	NULL	NULL	NULL	NULL	NULL	North Poblacion City of Naga Cebu	0987 546 4532	NULL	NULL	NULL	Kenneth Batongbakal	2019-11-26 08:40:52	ACTIVE	ClientCompany
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 9	9	NULL	Search and Be Found General Services	Search and Be Found General Services	NULL	NULL	NULL	NULL	NULL	West Poblacion City of Naga Cebu	0987 456 1234	NULL	NULL	NULL	David Johnson	2019-11-26 08:43:11	ACTIVE	ClientCompany
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 10	10	31	NULL	NULL	NULL	Bryan	Sator	Villafuerte	NULL	East Poblacion City of Naga Cebu	0978 456 1234	Male	1989-01-21	NULL	[email protected]	2019-11-26 08:50:29	CANCELLED	ClientPerson
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 11	11	NULL	Measured Results Marketing	Measured Results Marketing	NULL	NULL	NULL	NULL	NULL	East Poblacion City of Naga Cebu	0923 456 7890	NULL	NULL	NULL	Braille Cañete	2019-11-26 08:53:21	CANCELLED	ClientCompany
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 12	12	41	NULL	NULL	NULL	Cafe	Christy Robelle	Villafuerte	NULL	East Poblacion City of Naga Cebu	0987 567 5432	Female	1989-01-21	NULL	Mary Grace Partulan	2019-11-26 09:06:32	CANCELLED	OPPONENT
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 13	13	71	NULL	NULL	NULL	Sotto	Maria Dizan	Villafuerte	NULL	East Poblacion City of Naga Cebu	0978 654 1234	Female	1989-01-21	NULL	Maria May Sotto	2019-11-26 09:07:13	CANCELLED	OPPONENT
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 14	14	0	NULL	NULL	NULL	Banzon	Deejay	Enad	NULL	East Poblacion City of Naga Cebu	0987 657 5462	Female	1990-01-21	NULL	Richard Banzon	2019-11-26 09:08:04	CANCELLED	OPPONENT
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 15	15	211	NULL	NULL	Atty	Elizabeth	Alferez	Villafuerte	CPA	East Poblacion City of Naga Cebu	0987 543 1321	Female	1989-01-21	NULL	Diosdado Dejan	2019-11-26 09:09:09	ACTIVE	OPPONENT
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 16	16	821	NULL	NULL	Dr.	Lovely Shane	Manubag	Villafuerte	CPA	East Poblacion City of Naga Cebu	0978 345 8798	Female	1989-01-21	NULL	Susan Dela Cruz	2019-11-26 09:10:39	ACTIVE	OPPONENT
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 17	17	819	NULL	NULL	NULL	Chua	Hannah Debb	Villafuerte	NULL	East Poblacion City of Naga Cebu	0987 654 7896	Female	1989-01-21	NULL	Hannah Marie Chua	2019-11-26 09:14:16	ACTIVE	OPPONENT
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 18	18	NULL	Ferdz Auto Shop	Ferdz Auto Shop	NULL	NULL	NULL	NULL	NULL	South Poblacion City of Naga Cebu	0987 654 6780	NULL	NULL	NULL	Ferdz Salonga	2019-11-26 09:17:17	CANCELLED	OpponentCompany
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 19	19	NULL	A+ Electronics	A+ Electronics	NULL	NULL	NULL	NULL	NULL	West Poblacion City of Naga Cebu	0987 675 8968	NULL	NULL	NULL	Arialle Deguma	2019-11-26 09:18:24	CANCELLED	OpponentCompany
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 20	20	NULL	Castle Realty	Castle Realty	NULL	NULL	NULL	NULL	NULL	West Poblacion City of Naga	0917 567 4658	NULL	NULL	NULL	Leslie Duran	2019-11-26 09:21:18	ACTIVE	OpponentCompany
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 21	21	NULL	Envirotecture Design Service	Envirotecture Design Service	NULL	NULL	NULL	NULL	NULL	East Poblacion City of Naga Cebu	0974 868 8993	NULL	NULL	NULL	Mary Jane Sator	2019-11-26 09:22:15	ACTIVE	OpponentCompany
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 22	22	NULL	SalesSmarts	SalesSmarts	NULL	NULL	NULL	NULL	NULL	West Poblacion City of Naga Cebu	0987 567 1234	NULL	NULL	NULL	Sally Laput	2019-11-26 09:32:01	ACTIVE	OpponentCompany
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 23	23	767	NULL	NULL	Dr.	Myrna	Uy	Villafuerte		East Poblacion City of Naga Cebu	091221312	Female	1989-01-21	NULL	asdasd	2019-11-26 11:05:26	ACTIVE	ClientPerson
Edit	Copy	Delete DELETE FROM law_client WHERE `law_client`.`patient_id` = 24	24	767	NULL	NULL	NULL	Myrna	Uy	Villafuerte	NULL	East Poblacion City of Naga Cebu	0987 786 7865	Female	1989-01-21	NULL	Richard Sator Dela Torre	2019-11-27 09:05:47	ACTIVE	OPPONENT

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.