pritmadlani Posted December 6, 2008 Share Posted December 6, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/135842-php-and-excel/ Share on other sites More sharing options...
MadTechie Posted December 7, 2008 Share Posted December 7, 2008 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']; Quote Link to comment https://forums.phpfreaks.com/topic/135842-php-and-excel/#findComment-708188 Share on other sites More sharing options...
Mark Baker Posted December 7, 2008 Share Posted December 7, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/135842-php-and-excel/#findComment-708431 Share on other sites More sharing options...
pritmadlani Posted December 7, 2008 Author Share Posted December 7, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/135842-php-and-excel/#findComment-708462 Share on other sites More sharing options...
pritmadlani Posted December 18, 2008 Author Share Posted December 18, 2008 anyone else got any ideas? Quote Link to comment https://forums.phpfreaks.com/topic/135842-php-and-excel/#findComment-718830 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.