Jump to content

mano2991

New Members
  • Posts

    1
  • Joined

  • Last visited

mano2991's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.