Click to See Complete Forum and Search --> : Help


ShaunJUK
08-17-2006, 04:06 AM
Ok heres what I want, currently a spreadsheet is saved as a html file and uploaded onto the server, I would like a form the person could access so he can save the spreadsheet as a csv file and upload it to the server into a database using a form, then a php script recreates the table using the data in the database.

Do I make sense?

littlened
08-17-2006, 05:24 AM
Ok heres what I want, currently a spreadsheet is saved as a html file and uploaded onto the server, I would like a form the person could access so he can save the spreadsheet as a csv file and upload it to the server into a database using a form, then a php script recreates the table using the data in the database.

Do I make sense?

You may be best looking into storing the information in an XML file and using and XSL template to display the data within a page. Then it would be easier to convert the data to a csv file.

In the past I've created a database with all the same fields as a spreadsheet, then created a form to upload a csv file. A php script then read the contents of the csv file and stored the data in the database.

If someone wanted to download the data from a database, I would simply call the data and create one big variable to hold all the information and insert commas where needed, the file is then saved on the server and given to the user for download.

If you want to do it that way, you might need to look into the explode and split functions of php.

ShaunJUK
08-17-2006, 07:42 AM
well I save the table as a csv file and this is what I get

Westlands,,,,,,,
Dream Team League Table,,,,,,,
,,,,,,,Updated
,,,,,,,17/8/06
,,,Back To Homepage,,,,2 to End
POS,,TEAM,TOTAL,WEEK,MONTH,Month 10,
,,,,,,,
1,,F & F Utd,1635,42,71,,
2,,Shy Tall Knights,1595,60,84,,
3,,Bam Bam's Boomers!!,1564,58,93,,2nd
4,,Harry Haddock's Allstars,1550,48,70,,
5,,The Lodger,1509,52,63,,
6,,Toon Army,1500,15,35,,
7,,L.E.C. 5T,1499,43,73,,
8,,Scouses Forever,1480,38,58,,
9,,Celtic,1477,35,57,,
10,,P.D. 14,1472,49,67,#REF!,
11,,Davo's Team,1469,29,39,,
12,,Bellmaine,1441,35,49,,
13,,GSN,1429,36,51,,
14,,Roladan's XI,1403,37,48,,
15,,Simon's Super 11,1397,26,40,,
16,,Wrighty's Warriors,1385,41,50,,
17,,Mick's Marvels,1380,62,86,,5th
,,Micky T's XI,1380,52,65,,
19,,Mariners reserves,1375,39,57,,
20,,Bob's *****es FC,1374,37,57,,
21,,Red Machine In Full Effect,1371,40,57,,
22,,Ricky's T's XI,1370,62,94,,1st
23,,All Or Nothing,1366,43,57,,
24,,Taxi For Bally!,1356,33,54,,
25,,Bangkok Bent Frogs,1337,37,48,,
26,,Liam's Allstars,1333,26,61,,
,,Danny's Dreamers,1333,33,45,,
28,,Benjamin's Team,1323,53,56,,
29,,Shim Tite,1316,36,64,,
30,,Jacko's Jokers,1300,55,75,,
31,,The Bakers,1296,48,63,,
32,,JYB's Winning Virus,1277,51,70,,
33,,Pete's XI,1259,35,41,,
34,,Olivers Army,1258,58,82,,
35,,Al' Dude's,1253,44,86,,5th
36,,Liverbirds,1250,34,46,,
37,,Jacko's Big Balls…..Up,1245,52,84,,
38,,Newton Heath,1236,35,41,,
39,,5 Time Winners,1221,37,60,,
40,,Top Ten This Year Daz?,1214,35,49,,
41,,AC Villa,1204,39,48,,
42,,Mean And Levein,1196,50,85,,
43,,Bellybusters,1186,42,61,,
44,,Non - Starters,1181,43,70,,
45,,No Smoking At The Bar,1179,44,60,,
46,,Up The Spurs,1161,23,36,,
47,,Bin Liner Nomads,1133,55,87,,4th
48,,Treble Seven,1111,35,46,,
49,,Manc's On The March,1109,36,93,,2nd
50,,Denno's Devils,1098,26,37,,
51,,Recipe Meals Top Dog,1095,26,42,,
52,,Looprevil.CF,1041,33,45,,
53,,Shaw's Sharp Shooters,1037,18,24,,
54,,No Way Back Fordy!,1027,16,24,,
55,,OAP's Eleven,958,25,57,,
56,,"""Inter****ty Utd""",956,27,42,,
57,,Paying Up Again Daz!,948,18,24,,
58,,Eyresy's Yids,802,18,40,,

ShaunJUK
08-19-2006, 05:52 AM
Any help please?

I need to have it set up for Fantasy Football and it starts today