[adamdillon]

I have a site that i want a page to pull data from a excel spreadsheat. I have a linux dedicated server so i can use php. Can someone point me in the right direction?

The page is a stat page so i will be updating it weekly. I would rather do it on excel and just upload that page instead of doing it on the html. Thanks ahead

[Advertisements]

do you still need help?

[bdlt]

do you still need help?

[adamdillon]

yes please. I know some basic php now. i have been learning. I'm still a little confused with mysql.

[IO-error]

With MYSQL, put the code in ONE line, don't use multiple lines, it's simply not working that way.

If that's not the problem, then what is?
SQL isn't hard to understand or to use, except using the SQL Query syntax in a correct way.

[bdlt]

let's start with more info on what you are attempting to do.

given - the excel file changes each week

1. you want to extract data from this file and display it on your site, correct?

I'm not sure how to read the excel file directly, however, php is capable of reading text files.

php can be used to generate the html code for your site.

2. how many pages of data are in the excel file?

3. mysql was not mentioned in your original post. do you want the stats transferred to a database?

please post your answers and provide any other important details.

............................................................

here's how I can help:
provide php code to read text files
provide php code to generate html code
once that is accomplished, we can look at mysql code

[adamdillon]

Yes the excel file will change everyweek.

1. yes.
2. for each web page there will be one excel page.
3. If it would be easier to use mysql and setup the tables in it then i will. Can mysql read excel spreadsheets and convert them into mysql tables?

It will not be alot of data just stats for a football team.

[bdlt]

mysql handles databases, not excel files.

if you want past data available, we can store each week's stats in a database.

please attach a sample excel file with your next reply.

one way to transfer the data to your site:
1. copy and paste the excel data to a text file
2. read the text file using php code
3. generate html code using php to display new stats each week

are you interested in proceeding with a text file solution?

[adamdillon]

I do have access and I know how to use it to. I dont know if mysql works with access. I attached a spreadsheet of a rooster. I will be updating it until the season starts but once the season starts i wont have to update it anymore. Its set up the same way the stats will be. If we can't get the excel or acces sheet to work then i will be fine using the text file. Thanks for you help again.

[Ctrl_Alt_Del]

Do you know that you can save an Excel file as html?

[bdlt]

attached files:
standings.inc has code that can be used for a text file solution

sqlPhp.zip has mysql and php code

warning: the mysql code is crude

Attached Files

•  sqlPhp.zip   5.5KB   169 downloads

[bdlt]

here's standins.zip which contains standings.inc

Attached Files

•  standings.zip   1.27KB   171 downloads