Can anybody tell me how to write some php script to grab the directories from this page: http://www.hkhangfong.com/freedirectory.php and then write them into excel? Thanks a lot.
use a regular experession to pull all the links, write to a csv file. Cheers for the directory list, didn't know about that one
using a regular expression to pull all the links would either mean he'd to first strip the content of html tags and afterwards use a regular expression to fetch the links ( knowing that they have http:// in front of them - I can provide you with a regular expression for this ). After that I suggest taking a look at the PHP PEAR Excel writer ( just google it and you'll come up with some nice tutorials you could follow. ) Hope this helps.
yeah, but there are more links on that page - and I'm assuming he's only interested in the actual links on the page and not the "Submit here" links .. that's why I suggested he'd first have to strip the html tags...
I don't get one thing though .. why you want to get that list from there .. isn't that your site ? you seem to have it in your signature ... anyway, if anyone is interested in the list just PM me.
u can also just write it as a csv but name it xyz.xls excel opens it and shows it as a excel if u save it prompts u on format