Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: pu_recruitment_ardr »Table: payment_bill_desk
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (442 total, Query took 0.0843 seconds.)
SELECT * FROM `payment_bill_desk`
Full textsiduser_idreg_idapp_nopost_idsams_trans_nosams_amountstatusfee_typeyearpost_paramMerchantIDCustomerIDTxnReferenceNoBankReferenceNoTxnAmountBankIDBankMerchantIDTxnTypeCurrencyNameItemCodeSecurityTypeSecurityIDSecurityPasswordTxnDateAuthStatusSettlementTypeAdditionalInfo1AdditionalInfo2AdditionalInfo3AdditionalInfo4AdditionalInfo5AdditionalInfo6AdditionalInfo7ErrorStatusErrorDescriptionresponseCheckSumamount_descriptiondate_modifieddate_created_olddate_created
13 39 2000039 200003901 1 BD2000039REC4155 1000 S 0 2020 IBPONDIUVY|BD2000039REC4155|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000039REC4155 VSBI9448744508 IGAJUSBWD9 00001000.0 SBI NA 01 INR DIRECT NA NA 17.70 10-11-2020 14:51:31 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000039REC4155|VSBI9448744508|IGAJUSB... 3826F17A5E56216C6D6C0F6CCE9254F6A4E25ED01B764E0923... Pondicherry University - Recruitment - Application... 2020-11-10 14:45:09 2020-11-10 14:41:55
14 48 2000048 200004801 2 BD2000048REC1300 1000 S 0 2020 IBPONDIUVY|BD2000048REC1300|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000048REC1300 VSBI9449748420 IGAJUUBOI9 00001000.0 SBI NA 01 INR DIRECT NA NA 17.70 10-11-2020 19:20:24 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000048REC1300|VSBI9449748420|IGAJUUB... 6D0DE42AF136963B50BEB56EB0B520535DC259479F398996A1... Pondicherry University - Recruitment - Application... 2020-11-10 19:14:06 2020-11-10 19:13:00
15 37 2000037 200003701 2 BD2000037REC3652 1000 S 0 2020 IBPONDIUVY|BD2000037REC3652|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000037REC3652 VIOB9449849104 20201110835622 00001000.0 IOB NA 01 INR DIRECT NA NA 17.70 10-11-2020 19:44:21 0300 NA NA NA NA NA NA NA NA NA Y IBPONDIUVY|BD2000037REC3652|VIOB9449849104|2020111... 72DC6DB6E0F711528EF7798411EC31EFE1CF38D0950DBF9960... Pondicherry University - Recruitment - Application... 2020-11-10 19:38:11 2020-11-10 19:36:52
16 49 2000049 200004901 1 BD2000049REC5212 1000 S 0 2020 IBPONDIUVY|BD2000049REC5212|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000049REC5212 VSBI9449907822 IGAJUUILJ9 00001000.0 SBI NA 01 INR DIRECT NA NA 17.70 10-11-2020 19:59:36 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000049REC5212|VSBI9449907822|IGAJUUI... 312F3AF0DE069AF75C11ECC35312571B457D6BDBA50194ACE8... Pondicherry University - Recruitment - Application... 2020-11-10 19:53:23 2020-11-10 19:52:12
17 52 2000052 200005201 2 BD2000052REC3552 2000 S 0 2020 IBPONDIUVY|BD2000052REC3552|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000052REC3552 VSBI9450622738 IGAJUVDQN6 00002000.0 SBI NA 01 INR DIRECT NA NA 17.70 10-11-2020 23:43:16 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000052REC3552|VSBI9450622738|IGAJUVD... E864CD304F4C2659EA91C17C30EDCC036901862CC6B3D47A88... Pondicherry University - Recruitment - Application... 2020-11-10 23:40:08 2020-11-10 23:35:52
18 30 2000030 200003001 2 BD2000030REC3142 2000 S 0 2020 IBPONDIUVY|BD2000030REC3142|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000030REC3142 VSBI9451445543 IGAJUWFXG5 00002000.0 SBI NA 01 INR DIRECT NA NA 17.70 11-11-2020 10:39:08 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000030REC3142|VSBI9451445543|IGAJUWF... AE118054E3B988E6DF8C08C0DA74819873469F23E1921F127B... Pondicherry University - Recruitment - Application... 2020-11-11 10:32:52 2020-11-11 10:31:42
19 8 2000008 200000801 1 BD2000008REC0032 2000 S 0 2020 IBPONDIUVY|BD2000008REC0032|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000008REC0032 VSBI9452528801 IGAJUYDHI6 00002000.0 SBI NA 01 INR DIRECT NA NA 17.70 11-11-2020 15:08:06 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000008REC0032|VSBI9452528801|IGAJUYD... 5BDD2DF7BD15A70885E094023A979858C7E0C62547E1AD8BDF... Pondicherry University - Recruitment - Application... 2020-11-11 15:01:56 2020-11-11 15:00:32
20 12 2000012 200001201 1 BD2000012REC1302 1000 S 0 2020 IBPONDIUVY|BD2000012REC1302|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000012REC1302 VSBI9452573204 IGAJUYFBN7 00001000.0 SBI NA 01 INR DIRECT NA NA 17.70 11-11-2020 15:20:50 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000012REC1302|VSBI9452573204|IGAJUYF... 2E3D015B979D2C87C1865660822174DAB431A8E9609E1076A4... Pondicherry University - Recruitment - Application... 2020-11-11 15:14:42 2020-11-11 15:13:02
21 64 2000064 200006401 1 BD2000064REC5329 2000 S 0 2020 IBPONDIUVY|BD2000064REC5329|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000064REC5329 VUR29453990313 031622363050 2000.00 UR2 608023 03 INR RDDIRECT NA-676970 NA 00000000.00 11-11-2020 22:03:24 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000064REC5329|VUR29453990313|0316223... 97FA6B407CA6EF932C23D4042306A47251AE0267984058F69B... Pondicherry University - Recruitment - Application... 2020-11-11 21:56:46 2020-11-11 21:53:29
22 26 2000026 200002601 2 BD2000026REC0558 1000 S 0 2020 IBPONDIUVY|BD2000026REC0558|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000026REC0558 VHMP9454033652 770660 1000.00 HMP 517286 03 INR MDDIRECT 02-NA NA 00000000.00 11-11-2020 22:17:11 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000026REC0558|VHMP9454033652|770660|... 0659435DB027DC64CB7F3C110A9931A6B9917775CE4F41FF6A... Pondicherry University - Recruitment - Application... 2020-11-11 22:11:27 2020-11-11 22:05:58
23 58 2000058 200005801 1 BD2000058REC2648 1000 S 0 2020 IBPONDIUVY|BD2000058REC2648|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000058REC2648 VCUB9454902620 501120662 00001000.0 CUB NA 01 INR DIRECT NA NA 17.70 12-11-2020 09:34:21 0300 NA NA NA NA NA NA NA NA NA Y IBPONDIUVY|BD2000058REC2648|VCUB9454902620|5011206... 63D899661FAF4C3B936FBDDDE4C6BE3D3B4C0C9482256C06EA... Pondicherry University - Recruitment - Application... 2020-11-12 09:29:18 2020-11-12 09:26:48
24 33 2000033 200003301 1 BD2000033REC3141 2000 S 0 2020 IBPONDIUVY|BD2000033REC3141|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000033REC3141 VHMP9456081038 072095 2000.00 HMP 463917 02 INR DIRECT 05-NA NA 00000022.00 12-11-2020 14:39:53 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000033REC3141|VHMP9456081038|072095|... FAB73FC0BC9C67744D97B62FB4C44FB6BAB1727C6D19A8209C... Pondicherry University - Recruitment - Application... 2020-11-12 14:33:02 2020-11-12 14:31:41
25 75 2000075 200007501 2 BD2000075REC4450 2000 S 0 2020 IBPONDIUVY|BD2000075REC4450|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000075REC4450 VSBI9456332775 IGAJVEFDO8 00002000.0 SBI NA 01 INR DIRECT NA NA 17.70 12-11-2020 15:52:23 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000075REC4450|VSBI9456332775|IGAJVEF... ECFA1D4B1C9F8DFF8D1822943B52C8FEA8CCCB91DFAFE98439... Pondicherry University - Recruitment - Application... 2020-11-12 15:48:50 2020-11-12 15:44:50
26 15 2000015 200001501 1 BD2000015REC2751 1000 S 0 2020 IBPONDIUVY|BD2000015REC2751|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000015REC2751 VSBI9456480133 IGAJVEKLO8 00001000.0 SBI NA 01 INR DIRECT NA NA 17.70 12-11-2020 16:35:53 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000015REC2751|VSBI9456480133|IGAJVEK... E6379BE29855E777D46E33AA95103A52B6B0DDE9595D80986D... Pondicherry University - Recruitment - Application... 2020-11-12 16:29:44 2020-11-12 16:27:51
27 71 2000071 200007101 1 BD2000071REC4419 1000 F 0 2020 IBPONDIUVY|BD2000071REC4419|NA|1000|NA|NA|NA|INR|N... Pondicherry University - Recruitment - Application... 2020-11-12 20:44:19 2020-11-12 20:44:19
28 71 2000071 200007101 1 BD2000071REC2758 1000 F 0 2020 IBPONDIUVY|BD2000071REC2758|NA|1000|NA|NA|NA|INR|N... Pondicherry University - Recruitment - Application... 2020-11-12 21:27:58 2020-11-12 21:27:58
29 71 2000071 200007101 1 BD2000071REC3955 1000 F 0 2020 IBPONDIUVY|BD2000071REC3955|NA|1000|NA|NA|NA|INR|N... Pondicherry University - Recruitment - Application... 2020-11-12 21:39:55 2020-11-12 21:39:55
30 71 2000071 200007101 1 BD2000071REC4228 1000 F 0 2020 IBPONDIUVY|BD2000071REC4228|NA|1000|NA|NA|NA|INR|N... Pondicherry University - Recruitment - Application... 2020-11-12 21:42:28 2020-11-12 21:42:28
31 71 2000071 200007101 1 BD2000071REC4832 1000 S 0 2020 IBPONDIUVY|BD2000071REC4832|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000071REC4832 VPMP9457559922 765590 1000.00 PMP 607093 03 INR RDDIRECT NA NA 00000000.00 12-11-2020 21:57:05 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000071REC4832|VPMP9457559922|765590|... EE1339BAE12FCEC08A2B67FE57BF5375D341D12E40444533B2... Pondicherry University - Recruitment - Application... 2020-11-12 21:50:33 2020-11-12 21:48:32
32 71 2000071 200007102 2 BD2000071REC5632 1000 S 0 2020 IBPONDIUVY|BD2000071REC5632|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000071REC5632 VPMP9457584619 765667 1000.00 PMP 607093 03 INR RDDIRECT NA NA 00000000.00 12-11-2020 22:05:14 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000071REC5632|VPMP9457584619|765667|... 39494DAE551D8637C2980332D361920428D0F40A5A5D2E8B96... Pondicherry University - Recruitment - Application... 2020-11-12 21:58:36 2020-11-12 21:56:32
33 25 2000025 200002501 1 BD2000025REC1837 1000 F 0 2020 IBPONDIUVY|BD2000025REC1837|NA|1000|NA|NA|NA|INR|N... Pondicherry University - Recruitment - Application... 2020-11-13 10:18:37 2020-11-13 10:18:37
34 25 2000025 200002501 1 BD2000025REC1853 1000 S 0 2020 IBPONDIUVY|BD2000025REC1853|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000025REC1853 VHMP9458675742 959959 1000.00 HMP 471287 03 INR VDDIRECT 05-NA NA 00000000.00 13-11-2020 10:27:23 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000025REC1853|VHMP9458675742|959959|... F5257A8C232867F1A8F209E8152E47AE6B6C08059684E1DB79... Pondicherry University - Recruitment - Application... 2020-11-13 10:23:37 2020-11-13 10:18:53
35 73 2000073 200007301 1 BD2000073REC2256 2000 S 0 2020 IBPONDIUVY|BD2000073REC2256|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000073REC2256 VSBI9459138516 IGAJVHZAJ4 00002000.0 SBI NA 01 INR DIRECT NA NA 17.70 13-11-2020 12:30:29 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000073REC2256|VSBI9459138516|IGAJVHZ... F8CBE50ADFD15DC7ADE5D16B4111F1C4693EC4BF8094578253... Pondicherry University - Recruitment - Application... 2020-11-13 12:24:10 2020-11-13 12:22:56
36 73 2000073 200007302 2 BD2000073REC2705 2000 S 0 2020 IBPONDIUVY|BD2000073REC2705|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000073REC2705 VSBI9459154795 IGAJVHZJZ8 00002000.0 SBI NA 01 INR DIRECT NA NA 17.70 13-11-2020 12:34:34 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000073REC2705|VSBI9459154795|IGAJVHZ... E1C23C635CC731F50711012AD333BB629D3EECA829398C1C9A... Pondicherry University - Recruitment - Application... 2020-11-13 12:27:58 2020-11-13 12:27:05
37 96 2000096 200009601 1 BD2000096REC5626 1000 S 0 2020 IBPONDIUVY|BD2000096REC5626|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000096REC5626 VSM29461434068 805709 1000.00 SM2 459200 03 INR VDDIRECT NA NA 00000000.00 14-11-2020 01:05:57 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000096REC5626|VSM29461434068|805709|... E93B6F36429B8814FE2C7A638D27E63D80CB1CE906D346067F... Pondicherry University - Recruitment - Application... 2020-11-14 00:59:00 2020-11-14 00:56:26


mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.