materiel.uk / 127.0.0.1 / materiel / core_user

There are no favourite tables.

Customise 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.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise 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 :

No bookmarks

Label: Target database: Share this bookmark

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 Bookmark Query failed Database : Queried time :

Browse mode

Customise 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 (208 total, Query took 0.0031 seconds.) [alamat_keluarga_poskod: ... - ...]

SELECT * FROM `core_user` ORDER BY `alamat_keluarga_poskod` ASC

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

Filter rows:

Sort by key:

			ID	nombor_tentera	pangkat	pangkat_id	nama	nama_panggilan	call_sign	email	nombor_telefon	email_verified_at	email_verified_value	email_verification_token_hash	email_verification_expires_at	email_verification_last_sent_at	email_verification_grace_used_at	password	role	status	unit	unit_id	skn_caw_bhg	branch_id	reset_token_hash	reset_token_expires	alamat	alamat_keluarga_lokasi	alamat_keluarga_poskod 1	alamat_keluarga_daerah	alamat_keluarga_negeri	alamat_semasa_lokasi	alamat_semasa_poskod	alamat_semasa_daerah	alamat_semasa_negeri	tarikh_lahir	tarikh_tauliah	status_perkahwinan	agama	bangsa	jantina	profile_picture	profile_identity_locked	jawatan	bahagian	section_id	tred	kepakaran	allow_maklumat_lesen	updated_at	mapping_verified_at
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 28	28	730345	SJN U	18	MOHD NORFARIHAN BIN IBRAHIM		NULL	[email protected]	01110109257	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$TcBkK7XKaezC3l0HUZC//.BC.4iPtzmIoSQ1jphC6Ux...	user	active	INSPRA	26		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 30	30	375221	KAPT TUDM	8	MUHAMAD AIZARIZAL BIN ZAINAL		NULL	[email protected]	0189777835	NULL	NULL	NULL	NULL	NULL	2026-06-09 12:25:39	$2y$10$08SfWjkyJ.ZLP7GYe2swEeL0Bv.fe10/lKaSOgBtWSx...	user	active	MTU	1		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 31	31	730407	KPL U	19	MUHAMMAD AZROIN BIN AZIZ		NULL	[email protected]	0139757110	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$K3tgb2jN.6GYzpVAd.co9Oscdl6c/cGNx.bykz3/bgW...	user	active	INSPRA	26		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 34	34	733095	KPL U	19	AKMAL RAZIN BIN ZULKAFFLI		NULL	[email protected]	0106501194	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$IGwkXHtS2cPZwFm76gQbXu5wsvhIeV/m0PaeQR1tsWY...	user	active	MAWILUD 1	5		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 39	39	729032	KPL U	19	MUHAMMAD ZULFAEEZ BIN RAMLI		NULL	[email protected]	0167262779	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$BncYLrVA5QMC/E4b2a1BOOn1A/7.eDHtVFn5rKsHxkL...	user	active	MAWILUD 1	5		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 42	42	728576	KPL U	19	MUHAMMAD AFENDI BIN ABDUL RAHMAN		NULL	[email protected]	0148216533	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$GudRFScD3qP0I2X5ur/pDOqlH2jUlWicdcmgRULkkr9...	user	active	MAWILUD 1	5		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 45	45	726637	FSJN	17	MOHD FIRDAUS BIN NISAB		NULL	[email protected]	01123049354	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$zBqFBAfxZrEvC3rWGSGiVO8dePL7X7/zF9TgXpWIFd0...	user	active	INSPRA	26		NULL	NULL	NULL	No.82 Lorong 5 Taman Seri Mahkota Aman 25150 Kuant...	No.82 Lorong 5 Taman Seri Mahkota Aman 25150 Kuant...	NULL	NULL	NULL	NULL	NULL	NULL	NULL	14/03/1985	NULL	NULL	NULL	NULL	NULL	NULL	0	PTTK DOMESTIK		NULL	MATERIEL	MAT	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 46	46	9001078	SJN U	18	MOHAIMIN BIN RUSMAN		NULL	[email protected]	0132685846	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$Smg0IT8mrKjBt2KSjsF6W.cMmmdh.jc5F7bgw4ge0yA...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 47	47	731972	KPL U	19	MOHAMAD ZULHELMI BIN CHE PA		NULL	[email protected]	0149133447	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$AtujlIZbgFzqXNwjsrK2SeWrnSW71hDsP.Ja6sYhI/G...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 49	49	726356	SJN U	18	MOHD SYAZWAN NAZMI BIN BAHARUM		NULL	[email protected]	01161716931	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$G1/fKz.BYjp1CC3fdMOS0.oFVPbh7mY2s/6p2aohVWg...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 50	50	740904	LUK	20	MUHAMMAD HELMI ZIKRI BIN BUKHARI		NULL	[email protected]	01124131522	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$xwnaIKetZmFSI8TsUcXEQ.HWYNC12nHZtIfTrxX9dCD...	user	active	PU KUANTAN	8		NULL	NULL	NULL	PT 84294 (B) PADANG GARUDA BATU JLN GAMBANG KUANTA...	PT 84294 (B) PADANG GARUDA BATU JLN GAMBANG KUANTA...	NULL	NULL	NULL	NULL	NULL	NULL	NULL	31/10/2001	NULL	NULL	NULL	NULL	NULL	NULL	0	PEMANDU AM		NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 51	51	729085	KPL U	19	UWAIS ALQARNI BIN ISMAIL		NULL	[email protected]	0165251817	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$qy4jxYcgSgBBaKa4ukXXxOHq1s34xXlMb89m48ojIuG...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 53	53	732732	KPL U	19	MUHAMAD IBRAHIM SHAMIL BIN HASHIM		NULL	[email protected]	01135752732	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$SxmixGzuyw0hqxRE8jFH.uLxTz28AvdDb3yaQzeUE57...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 54	54	734253	KPL U	19	MOHAMMAD HAFIS BIN AMIT		NULL	[email protected]	0148605735	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$vADmGBnDUYvZ6oEwkO77zeMIADAOX0/df3dy/on/M4K...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 60	60	726829	FSJN	17	DANN HANDSON ANAK DENING		NULL	[email protected]	0145350875	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$jatwzdzwFeUiwn0blH83hO3stC3.67GF/NymvDNCRal...	user	active	PU KUCHING	12		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-07-21 15:07:10	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 61	61	725094	FSJN	17	MOHD HARIS BIN AHMAD		NULL	[email protected]	0105221788	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$Ya.LFAP9YYgRzwoJOiST5uHxp3sIFlDxzhHl7L5xohY...	user	active	MPOU	2		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-07-21 15:07:15	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 64	64	740726	LUK	20	ALEXANDER JONES ANAK JITEN		NULL	[email protected]	0135071723	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$Eag6oJcKUgcw2Q31UpjGQOW7qOIXHPHn1rY1nhflfr8...	user	active	MAWILUD 1	5		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 65	65	740564	LUK	20	MUHAMMAD HAIKAL BIN SHAHARUDIN		NULL	[email protected]	0182883556	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$Ul22S6ERVfimJXaP4ay/4e5lPIQ3v1jLqO1x3vuHUgR...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 66	66	740514	LUK	20	MUHAMMAD AMIRUL BIN MOHD FUAAD		NULL	[email protected]	0185740645	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$pUQsGPqw1yPeRjSIzGP6neYWwbplp0xXOeyUPc3CQr9...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 67	67	727220	SJN U	18	MD NURULFAISHAM BIN MD RIPIN		NULL	[email protected]	0199130316	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$8EMkTopnJRPyAvTt0ug4FednCgte92Zna9ncrLMBbEL...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 68	68	728543	KPL U	19	MOHD ZAKWAN BIN MD TAHIR		NULL	[email protected]	0105233520	NULL	NULL	5442832faddf73b0c24eb35678bf95a5e8ccc10b4eac0ddc7b...	2026-07-21 10:18:08	2026-07-21 09:48:08	2026-07-21 09:47:20	$2y$10$oxJQ5rGmM5TmUnENmYBPhesCYjyvEfzrJa9O4Ucgd.....	user	active	MAWILUD 1	5		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-07-21 09:48:08	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 69	69	740585	LUK	20	MUHAMMAD KHAIRUL SYAFIQ BIN AZHAR		NULL	[email protected]	01169353031	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$fBjbb18nrrGRLZn36BxeMeXtZxt2jOfj/oPu/bPwaJo...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 70	70	9000354	FSJN	17	RAMLI BIN WAHAB		NULL	[email protected]	0199039531	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$R0zBOK5lRrcuuEIY5N2as.rCgz3ufTwBYNXSFldGUHY...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 71	71	723702	PW U II	16	AMMY BIN AHMAD RAZALI		NULL	[email protected]	0122066171	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$dXdFxrmwJ.BFc0zxbntvr.IKrIh58cYZ5uAMAcfw9L3...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59
Edit	Copy	Delete DELETE FROM core_user WHERE `core_user`.`ID` = 72	72	733881	KPL U	19	AKMAL KHUZAIRI BIN ABD KARIM		NULL	[email protected]	0172730681	NULL	NULL	NULL	NULL	NULL	NULL	$2y$10$VVzuzYdZkInN1GCvrIRMYue7tkW/E.bL7VmCN6Jp1fH...	user	active	PU KUANTAN	8		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0			NULL	NULL	NULL	0	2026-06-19 14:53:59	2026-06-19 14:53:59

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view