Hello Everyone I'm stuck on a web page that I'm trying to code basically the user will :
- Open a file browser and look for the tex file (done)
- Put the file on a server folder (done)
- Create a database with the name of the file (done)
- Create a table for example : 7 rows like in the example above (done)
- I need to populate that database with the text file information , I really don't know how to do it I was able to put the text file data in to a variable $result using fopen and fget but I'm not sure what to do with that variable if putting the data in to an array which I failed or there is a way to populate a database using some command . Please if anyone can help me I will appreciate it so much.
Example of the data I will upload :
15/08/2010 15:11:35 1507.244 0.535 13.616 43.108 36.459
15/08/2010 15:11:36 1507.401 1.086 14.047 43.080 36.024
15/08/2010 15:11:36 1507.307 1.581 14.203 43.090 35.887
15/08/2010 15:11:36 1507.222 2.123 14.334 43.066 35.743
15/08/2010 15:11:37 1507.212 2.559 14.445 43.138 35.707
15/08/2010 15:11:37 1507.198 3.008 14.541 43.146 35.626
15/08/2010 15:11:37 1507.069 3.676 14.619 43.124 35.534
15/08/2010 15:11:39 1506.923 4.017 14.909 43.070 35.220
15/08/2010 15:11:40 1506.905 3.976 14.937 43.062 35.187
15/08/2010 15:11:41 1507.017 4.054 15.007 43.134 35.190
15/08/2010 15:11:42 1507.120 3.990 15.023 43.134 35.175
15/08/2010 15:11:43 1507.058 3.493 15.037 43.122 35.152
15/08/2010 15:11:45 1506.978 3.546 15.054 43.110 35.126
15/08/2010 15:11:46 1507.026 3.457 15.046 43.112 35.135
15/08/2010 15:11:47 1507.027 3.505 15.048 43.114 35.135
15/08/2010 15:11:48 1506.999 4.098 15.047 43.114 35.135
15/08/2010 15:11:48 1506.732 4.554 15.042 43.050 35.081
15/08/2010 15:11:50 1506.619 5.011 14.990 42.998 35.080
Regards