[COLOR=#434343][FONT=helvetica]excel to mysql with special characters
Dear All
gone through many articles on uloading excel to mysql
excellent code in
http://phpexcel.codeplex.com/
MY issue is i cannot upload following (this is cut and pasted from an excel file)
where in
t1
is actually t and subscript 1 opposite to (n² i.e. n and superscript 2)
With this text with mathematical symbols cannot be uploaded
[TABLE=“width: 664”]
[TR]
[TD=“align: right”]1001[/TD]
[TD]a[/TD]
[TD=“colspan: 2”]Find the first 3 terms of a sequence whose nth term is n²/(n + 1)[/TD]
[TD]Q[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Given:[/TD]
[TD]For a sequence, t[SUB]n[/SUB] = n[SUP]²[/SUP]/(n+1)[/TD]
[TD][/TD]
[TD]AS1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]To Find:[/TD]
[TD]t[SUB]1[/SUB], t[SUB]2[/SUB], t[SUB]3[/SUB][/TD]
[TD][/TD]
[TD]AS2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Solution:[/TD]
[TD]t[SUB]n[/SUB] = n²/(n+1)[/TD]
[TD]given[/TD]
[TD]AS3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]∴ t[SUB]1[/SUB] = (1)²/ (1 + 1)[/TD]
[TD]substituting n = 1[/TD]
[TD]AS4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]∴ t[SUB]1[/SUB] = 1/ 2[/TD]
[TD][/TD]
[TD]AS5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]∴ t[SUB]2[/SUB] = (2)²/ (2 + 1)[/TD]
[TD]substituting n = 2[/TD]
[TD]AS6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]∴ t[SUB]1[/SUB] = 4/ 3[/TD]
[TD][/TD]
[TD]AS7[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]∴ t[SUB]3[/SUB] = (3)²/ (3 + 1)[/TD]
[TD]substituting n = 3[/TD]
[TD]AS8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]∴ t[SUB]3[/SUB] = 9/ 4[/TD]
[TD][/TD]
[TD]AS9[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ans:[/TD]
[TD]t[SUB]1[/SUB] = 1/2, t[SUB]2[/SUB] = 4/3, t[SUB]3[/SUB] = 9/4[/TD]
[TD]CA[/TD]
[TD]CA[/TD]
[/TR]
[/TABLE]
Please help
Thanks in advance
[/FONT][/COLOR]
Related Article: import an excel file(xls,xlsx) to mysql via php
Authored by djasy in the PHP forum, this related discussion thread currently has 7 replies, was last posted to 3 weeks ago by miatiza and has been tagged with the following keywords: excel, file, to, mysql. It has been marked solved and added to our huge knowledgebase of solved Q&As. It begins, “good evening people,i’m creating an application where i’d like to import and save a list …”