javascript - Multiple CSV files to PHP Array - -

-

i have problems csv files. have 50 csv files, looks same below.

i need import them php array - (later put them js var, , use in diagrams) csv dont looks should (i cant change it) - have data @ top (first 10 lines) - need use them in different places (just show them - "kategoria:";"rolnictwo, leŚnictwo Łowiectwo"; - title)

"okres sprawozdawczy:";"dane roczne"; "kategoria:";"rolnictwo, leŚnictwo Łowiectwo"; "grupa:";"skup produktÓw rolnych"; "podgrupa:";"skup produktów na 1 ha użytków rolnych"; "wymiary:";"wykaz produktów, lata";  "kod";"jednostka terytorialna";"buraki cukrowe";"buraki cukrowe";"buraki cukrowe";"buraki cukrowe"; "2010";"2011";"2012";"2013"; "[kg]";"[kg]";"[kg]";"[kg]"; "1100000000";" ŁÓdzkie";"278";"355";"363";"333"; "1140000000";" mazowieckie";"247";"250";"286";"348"; "2120000000";" maŁopolskie";"67";"87";"114";"127"; "2240000000";" ŚlĄskie";"168";"218";"245";"281"; "3060000000";" lubelskie";"1139";"1170";"1235";"1346"; "3180000000";" podkarpackie";"249";"208";"342";"404"; "3200000000";" podlaskie";"6";"30";"5";"0"; "3260000000";" ŚwiĘtokrzyskie";"479";"482";"337";"534"; "4080000000";" lubuskie";"184";"141";"264";"229"; "4300000000";" wielkopolskie";"1102";"1412";"1485";"1532"; "4320000000";" zachodniopomorskie";"522";"830";"909";"642"; "5020000000";" dolnoŚlĄskie";"1044";"1045";"1274";"1136"; "5160000000";" opolskie";"1392";"1386";"2113";"1660"; "6040000000";" kujawsko-pomorskie";"1588";"2040";"2272";"2252"; "6220000000";" pomorskie";"624";"748";"724";"879"; "6280000000";" warmiŃsko-mazurskie";"153";"150";"163";"167";

how can print them array - looks this:

[0] => array       (       [0] okres sprawozdawczy       [1] dane roczne       ) [1] => array       (       [0] kategoria       [1] rolnictwo, leŚnictwo Łowiectwo       ) [2] => array       (       [0] grupa:       [1] skup produktÓw rolnych       )

etc. first 5 lines of csv lines.

but later line 7 (6 empty) - line 7,8,9 1 header..

"kod" - "1100000000" "jednostka terytorialna" - "ŁÓdzkie"  "buraki cukrowe","2010","[kg]" - "278" "buraki cukrowe","2011","[kg]" - "355" "buraki cukrowe","2012","[kg]" - "363" "buraki cukrowe","2013","[kg]" - "333"
  • 3 headers 1 data, need think that:
[6] => array ([0] buraki cukrowe => array ([0] 2010 => array ([0] kg => array ([0] 278)

where "278" data need use , put in js var. im not sure way this, please me out..

first set file on variable, can use file_get_content() this

$csvdata = file_get_contents('your_file.csv');

you can files need add

after have $csvdata have explode , chunk this

$explodedcsvdata = explode(';',$csvdata); $chuckedcsvdata = array_chunk($explodedcsvdata,2);

Comments

Post a Comment

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

-
any ideas when firefox implement lengthadjust andtextlength?..... working svg application. lengthadjust , textlength working fine in chrome not working in fire fox . <svg viewbox = "0 0 500 300" version = "1.1"> <defs> <path id="s3" d="m 10,90 q 100,15 200,70" /> </defs> <g> <text font-size = "20"> <textpath xlink:href="#s3" textlength="205"> short text</textpath> </text> <use xlink:href="#s3" fill="none" stroke="black" stroke-width="1"/> </g> </svg> this implemented in firefox text elements (not textpath or tspan) in case that's ok though can move attribute text element. <svg viewbox = "0 0 500 300" version = "1.1"> <defs> ...
Read more