PHP and Excel

[pritmadlani]

Hi,

 

I am looking to create a PHP database website and am wondering if I can link it to Microsoft Excel spreadsheet.  Also, I am looking to create a website whereby users can search for specific things.  E.g.  I need to create a database where I put people's names in such as FIRST NAME - "JOE" SURNAME "BLOGGS" AGE "25".  If a search is done under the FIRST NAME for "JOE", the neccessary details will be displayed on the website.  Any help is much appreciated.

 

Thank you in advance.

[MadTechie]

You could save the excel file as a CSV then import it.. as for your search request that can be done providing you have the fields in your SELECT statment

ie

$query = "SELECT * FROM table WHERE firstname='JOE' ";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
echo "name:".$row['Firstname']."-".$row['Lastname']." - Age".$row['Age'];

[Mark Baker]

I am looking to create a PHP database website and am wondering if I can link it to Microsoft Excel spreadsheet.

If you need to read from or write to an Excel workbook, you can try PHPExcel

[pritmadlani]

Thanks for both replies.  Are there any easy to use guides to create the tables and link it to PHP?  The question that I have asked seems to be fairly simple (as I am only testing things at the moment), but need a good starting point?

 

Thanks in advance.

[pritmadlani]

anyone else got any ideas?