Training, Open Source computer languages

This is page http://www.wellho.net/forum/The-MySQ ... abase/convert-php-mysql-page-to-html.html

Our email: info@wellho.net • Phone: 01144 1225 708225

 
For 2023 (and 2024 ...) - we are now fully retired from IT training.
We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.

Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!

I am also active in many other area and still look after a lot of web sites - you can find an index ((here))
convert php / mysql page to html

Posted by bschultz (bschultz), 20 June 2003
I'd like to clean out my db's and convert all pages that call the db to html pages.  Is there an easier way to do this than to call up the page in a browser and copy the info and paste it into Dreamweaver?

Thanks.

Brian

Posted by John_Moylan (jfp), 20 June 2003
Hello Brian.

Do you have access to a linux shell? yes...good!

you can use GET or wget.

GET on the command line will spit the html that the page produced to the screen.
You can redirect this to a file.
usage:
[john@john john]$ GET http://www.sports.com/index_ie.php > something.html

somthing.html will now exist.

But better then that (I think) is wget.
usage:
[john@john john]$ wget http://www.php.net

The index page of php.net will be saved to your dir, all you need to do is rename the extention to html.

Im pretty sure you can pass in a command line option to wget to make it crawl through you directory tree, though would need to read the man page to check...but its a start I hope.

Cheers
jfp

Posted by John_Moylan (jfp), 20 June 2003
just looked, there is a -r (recursive) option to wget.

Final thought though, intra page/site links will still be to *.php, you will have to write a regex to replace relative links to .html, but thats another question

jfp

Posted by John_Moylan (jfp), 20 June 2003
This will replace .php with .html on all relative links, it will leave absolute links alone.

Yes its in perl s/// but the regex is correct... I think.
s/(href\s*=\s*"?(?!http[^">?#]+)\.php?([">?#\s]|$)/$1.html$2/gi;

(last edit....bloody smileys!)

Posted by bschultz (bschultz), 20 June 2003
Thanks, JFP

This board is full of REALLY smart people.

Posted by John_Moylan (jfp), 20 June 2003
>>This board is full of REALLY smart people.

Standing on the shoulders of Giants, and theft, (I mean code reuse)  



This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

© WELL HOUSE CONSULTANTS LTD., 2024: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho