mano2991 Posted March 20, 2013 Share Posted March 20, 2013 Hi friends i am learning to create a database with the help of xampp and Php i just learned to connect my Mysql database with Php. now the following are the table in my data base i just need to call them with php and i want to remove the delimits"/" in the table and i need to display them like table 2 Table 1. SI.No Donor ID Disease Status Age(yrs.) /Sex Nucleotide Change Amino acid Change Location in gene Location in Protein Mutation in other allele Clinical Features Biochemical Data Geographical Location Ethnic gr. Familial / Sporadic References 1/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25 AS_5*/AS_4*/AS_8*/AS_7*/AS_10*/PM_1*/AS_9*/Family 5_II:3/AS_14*/AS_15*/PM_4*/PM_3*/PM_2*/AS_16*/Family 4_IV:1/AS_25*/Family 13_IV:1/Family7_V:5/PD_1*/AS_1*/AS_2*/AS_3*/Family 6_IV:3/AS_4*/ Family 8_II: patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ patient/ NA/NA// NA/NA// Since Birth/NA// NA/NA/ Since Birth/NA// NA/NA// NA/NA// 3/M NA/NA// Since Birth/NA// NA/NA// NA/NA// NA/NA// NA/NA// Since birth/M / NA/NA// Since birth/M / Since birth/M / NA/NA// Since Birth/NA// Since Birth/NA// Since Birth/NA// Since birth/F / NA/NA// 5/M c.1253G>A /c.1418T>G /c.1466C>T /c.1751C>A /c.2264G>A /c.2411G>A /c.2263C>T /c.2318C>T /c.2470G>A /c.2605C>T /c.2606G>A /c.2605C>T /c.2498C>T /c.2605C>T /c.2618T>C /c.2264G>A /c.374G>A /c.478G>A /c.427G>A /c.625C>T /c.638C>T /c.697C>T /c.806C>T /c.1202C>A /c.1156T>C p.G418D /p.L473R /p.S489L /p.T584K /p.R755Q /p.R804H /p.R755W /p.P773L /p.V824M /p.R869C /p.R869C /p.R869C /p.T833M /p.R869C /p.L873P /p.R755Q /p.R125H /p.A160T /p.E143K /p.R209W /p.S213L /p.R233C /p.A269V /p.T401L /p.C386R Exon 10 /Exon 11 /Exon 12 /Exon 13 /Exon 17 /Exon 17 /Exon 17 /Exon 17 /Exon 18 /Exon 18 /Exon 18 /Exon 18 /Exon 18 /Exon 18 /Exon 19 /Exon 20 /Exon 4 /Exon 4 /Exon 4 /Exon 5 /Exon 5 /Exon 6 /Exon 7 /Exon 9 /Exon 9 TMD 2/TMD 4/NA/TMD 6/NA/NA/TMD 11/TMD 11/NA/NA/NA/NA/NA/NA/TMD 14/NA/N-terminalcytoplasmic domain/N-terminal cytoplasmic domain/N-terminal cytoplasmic domain/N-terminal cytoplasmic domain/N-terminal cytoplasmic domain/N-terminal cytoplasmic domain/NA/NA/TMD 1 p.G418D /p.T401L /p.S489L /p.R112X /p.R875X /c.1704_1705delCT /p.R755W /p.Q836X /p.V824M /p.R869C/Uncharacterised/Uncharacterised /c.2420delTinsGG /p.R869C /p.L873P /p.R875X /p.R125H /p.A160T/Uncharacterised /p.R209W /p.S213L /p.R233C /p.A269V /p.L473R /p.C386R NA/NA/NA/NA/NA/NA/NA/IOP (OD/OS mm): 18/20/NA/NA/NA/NA/NA/NA/Intermittent squint with 30° of exotropia, IOP (OD/OS mm): 28/25/NA/NA/Corticosteroidinduced cataract IOP (OD/OS mm): 15/21/NA/NA/NA/NA/Pigments on lens anterior capsule, IOP (OD/OS mm): 15/12/NA/Epithelial iron line, IOP (OD/OS mm): 12/10 NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA South India*/ South India*/ South India*/ South India*/ South India*/ NA/South India*/ South India/South India*/ South India*/ NA/NA/NA/South India*/ South India/South India*/ South India/South India/NA/ South India*/ South India*/ South India*/ South India/ South India*/ South India NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA/NA PMID:17679935 /PMID:17679935 /PMID:17679935 /PMID:17679935 /PMID:17679935 pubmed:11302728 /PMID:17679935 pubmed:18474783 /PMID:17679935 /PMID:17679935 pubmed:11302728 pubmed:11302728 pubmed:11302728 /PMID:17679935 pubmed:18474783 /PMID:17679935 pubmed:18474783 pubmed:18474783 pubmed:11302728 /PMID:17679935 /PMID:17679935 /PMID:17679935 pubmed:18474783 /PMID:17679935 pubmed:18474783 Table 2 SI.No Donor ID Disease Status Age(yrs.) /Sex Nucleotide Change Amino acid Change Location in gene Location in Protein Mutation in other allele Clinical Features Biochemical Data Geographical Location Ethnic gr. Familial / Sporadic References 1 AS_5* Patient NA/NA c.1253G>A p.G418D Exon 10 TMD 2 p.G418D NA NA South India* NA NA PMID:17679935 2 AS_4* Patient NA/NA c.1418T>G p.L473R Exon 11 TMD 4 p.T401L NA NA South India* NA NA PMID:17679935 3 AS_8* Patient Since Birth/NA c.1466C>T p.S489L Exon 12 NA p.S489L NA NA South India* NA NA PMID:17679935 4 AS_7* Patient NA/NA c.1751C>A p.T584K Exon 13 TMD 6 p.R112X NA NA South India* NA NA PMID:17679935 5 AS_10* Patient Since Birth/NA c.2264G>A p.R755Q Exon 17 NA p.R875X NA NA South India* NA NA PMID:17679935 6 PM_1* Patient NA/NA c.2411G>A p.R804H Exon 17 NA c.1704_1705delCT NA NA NA NA NA pubmed:11302728 7 AS_9* Patient NA/NA c.2263C>T p.R755W Exon 17 TMD 11 p.R755W NA NA South India* NA NA PMID:17679935 8 Family 5_II:3 Patient 3/M c.2318C>T p.P773L Exon 17 TMD 11 p.Q836X IOP (OD/OS mm): 18/20 NA South India NA NA pubmed:18474783 9 AS_14* Patient NA/NA c.2470G>A p.V824M Exon 18 NA p.V824M NA NA South India* NA NA PMID:17679935 10 AS_15* Patient Since Birth/NA c.2605C>T p.R869C Exon 18 NA p.R869C NA NA South India* NA NA PMID:17679935 11 PM_4* Patient NA/NA c.2606G>A p.R869C Exon 18 NA Uncharacterised NA NA NA NA NA pubmed:11302728 12 PM_3* Patient NA/NA c.2605C>T p.R869C Exon 18 NA Uncharacterised NA NA NA NA NA pubmed:11302728 13 PM_2* Patient NA/NA c.2498C>T p.T833M Exon 18 NA c.2420delTinsGG NA NA NA NA NA pubmed:11302728 14 AS_16* Patient NA/NA c.2605C>T p.R869C Exon 18 NA p.R869C NA NA South India* NA NA PMID:17679935 15 Family 4_IV:1 Patient Since birth/M c.2618T>C p.L873P Exon 19 TMD 14 p.L873P Intermittent squint with 30° of exotropia, IOP (OD/OS mm): 28/25 NA South India NA NA pubmed:18474783 16 AS_25* Patient NA/NA c.2264G>A p.R755Q Exon 20 NA p.R875X NA NA South India* NA NA PMID:17679935 17 Family 13_IV:1 Patient Since birth/M c.374G>A p.R125H Exon 4 N-terminal cytoplasmic domain p.R125H NA NA South India NA NA pubmed:18474783 18 Family 7_V:5 Patient Since birth/M c.478G>A p.A160T Exon 4 N-terminal cytoplasmic domain p.A160T Corticosteroidinduced cataract IOP (OD/OS mm): 15/21 NA South India NA NA pubmed:18474783 19 PD_1* Patient NA/NA c.427G>A p.E143K Exon 4 N-terminal cytoplasmic domain Uncharacterised NA NA NA NA NA pubmed:11302728 20 AS_1* Patient Since Birth/NA c.625C>T p.R209W Exon 5 N-terminal cytoplasmic domain p.R209W NA NA South India* NA NA PMID:17679935 21 AS_2* Patient Since Birth/NA c.638C>T p.S213L Exon 5 N-terminal cytoplasmic domain p.S213L NA NA South India* NA NA PMID:17679935 22 AS_3* Patient Since Birth/NA c.697C>T p.R233C Exon 6 N-terminal cytoplasmic domain p.R233C NA NA South India* NA NA PMID:17679935 23 Family 6_IV:3 Patient Since birth/F c.806C>T p.A269V Exon 7 NA p.A269V Pigments on lens anterior capsule, IOP (OD/OS mm): 15/12 NA South India NA NA pubmed:18474783 24 AS_4* Patient NA/NA c.1202C>A p.T401L Exon 9 NA p.L473R NA NA South India* NA NA PMID:17679935 25 Family 8_II:1 Patient 5/M c.1156T>C p.C386R Exon 9 TMD 1 p.C386R Epithelial iron line, IOP (OD/OS mm): 12/10 NA South India NA NA pubmed:18474783 can any one help me with this And i have attached my Php code which i used to connect my Database with php c.php Quote Link to comment https://forums.phpfreaks.com/topic/275911-hi-friends-i-am-new-to-php-i-just-need-to-know-how-can-remove-my-delimits-in-my-database-and-need-to-show-them-as-a-tabl/ Share on other sites More sharing options...
requinix Posted March 20, 2013 Share Posted March 20, 2013 PHPFreaks.com Questions, Comments, & Suggestions This is NOT a help forum! Do not post topics asking for help not related to the website. It's easier to read code if it's posted directly in the thread. Can you do that? And repost your table data but with [code] tags this time. Quote Link to comment https://forums.phpfreaks.com/topic/275911-hi-friends-i-am-new-to-php-i-just-need-to-know-how-can-remove-my-delimits-in-my-database-and-need-to-show-them-as-a-tabl/#findComment-1419874 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.