Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

php driven


  • Please log in to reply

#1
adamdillon

adamdillon

    Member

  • Member
  • PipPip
  • 67 posts
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
  • 0

Advertisements


#2
bdlt

bdlt

    Member

  • Member
  • PipPipPip
  • 875 posts
do you still need help?
  • 0

#3
adamdillon

adamdillon

    Member

  • Topic Starter
  • Member
  • PipPip
  • 67 posts
yes please. I know some basic php now. i have been learning. I'm still a little confused with mysql.
  • 0

#4
IO-error

IO-error

    Member

  • Member
  • PipPipPip
  • 276 posts
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.
  • 0

#5
bdlt

bdlt

    Member

  • Member
  • PipPipPip
  • 875 posts
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
  • 0

#6
adamdillon

adamdillon

    Member

  • Topic Starter
  • Member
  • PipPip
  • 67 posts
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.
  • 0

#7
bdlt

bdlt

    Member

  • Member
  • PipPipPip
  • 875 posts
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?
  • 0

#8
adamdillon

adamdillon

    Member

  • Topic Starter
  • Member
  • PipPip
  • 67 posts
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.
  • 0

#9
Ctrl_Alt_Del

Ctrl_Alt_Del

    Member

  • Member
  • PipPip
  • 74 posts
Do you know that you can save an Excel file as html?
  • 0

#10
bdlt

bdlt

    Member

  • Member
  • PipPipPip
  • 875 posts
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


  • 0

#11
bdlt

bdlt

    Member

  • Member
  • PipPipPip
  • 875 posts
here's standins.zip which contains standings.inc

Attached Files


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP