hyster Posted December 21, 2010 Share Posted December 21, 2010 i have a html page which is derived from an excel spreedsheet. is it possable to use php to search the page and pull a row of data from it and store them as $vars ? sort of treat it as a database. if so can you point me in the right direction. i tryed google with no luck. cheers Link to comment https://forums.phpfreaks.com/topic/222342-search-a-html-page/ Share on other sites More sharing options...
denno020 Posted December 22, 2010 Share Posted December 22, 2010 You can export your excel spreadsheet as a CSV file, and then use PHP to parse through it, grabbing what it wants, and ignoring what it doesn't. Don't ask me how to do that, I just know that it can be done lol. Other than that, I'm not sure there is much else that can be done. Denno Link to comment https://forums.phpfreaks.com/topic/222342-search-a-html-page/#findComment-1150144 Share on other sites More sharing options...
dreamwest Posted December 22, 2010 Share Posted December 22, 2010 load the file into a string then preg_match the search term Link to comment https://forums.phpfreaks.com/topic/222342-search-a-html-page/#findComment-1150169 Share on other sites More sharing options...
tibberous Posted December 22, 2010 Share Posted December 22, 2010 Are you able to use something other than an html file? Saving it as a tab delimited file and reading it into a 2 dimensional array is probably your easiest bet - but it really depends on what you are trying to do. Hell, if you have WAMP setup and Navicat, you can just import it into a mysql table and go from there. Link to comment https://forums.phpfreaks.com/topic/222342-search-a-html-page/#findComment-1150179 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.