Ok here is what I need... I need a way to read a excel spreadsheet...

this is how it is setup...

[Name][Phone][Address][City][Zip][Age][Birth-Date]

Ok and there is like 60 or so of them

I need a form that asks for your name and phone and when you log in it returns that rows address, city, age, birthdate...

do you get what I am saying?

Thanks for the help

    There are tools that allow PHP to open and read an Excel file. If you have to do that, then fine. But before you go that route, consider two other options:

    1. You can put those 60 records in a database. PHP is good at reading from databases (especially MySQL but it can also read from Access and a bunch of others). This will take you some time to learn... but no longer to learn than learning to read from an Excel file and find the record you are interested in. Reading from (and writing to) databases is a good skill to have and databases are better suited for this kind of task anyway.

    2. If it's the same 60 addresses over and over and over and they will only change about once a year, then the quick and dirty method would be to put them in an array inside the PHP script so that you don't have to look externally (Excel or database) for the data. Building arrays and reading from arrays is also a good skill to have.

    I would say that since you have to spend some time learning one of these three methods, you might as well learn one of the two that I suggest since they will be very useful skills in future projects. But if you have to go with the Excel method for some reason, then Google for excel php. I found a few solutions on the first page.

      Write a Reply...