WoodGrain Posted October 18, 2007 Share Posted October 18, 2007 Hi guys,What I'm wanting to do is provide a daily bible verse to subscribers to my web site.Is there a way to extract specific text from a series of hyperlinked web pages into a database?Is it possible to extract the bible text and store it into a database, or create a text file that contains SQL insert commands (probably better/easyer?) such that it retains it's correct structure?http://www.biblegateway.com/versions/index...;vid=9#booklistPlease note that the linked bible is public domain.So that each verse would:- have it's own DB record (or insert)- record it's book name (eg, Genesis), it's chapter number and it's verse number separately from the verse itselfFor example, the SQL structure might look like: [book][chap][verse][verseText]Realistically I think extracting to an SQL insert file would make more sense, but given the size of the completed file I imagine it would make more sense to perform the extraction such that each book creates it's own insert file.Thanks! Link to comment Share on other sites More sharing options...
Valuater Posted October 18, 2007 Share Posted October 18, 2007 Daily verse with sound... Just for fun #include <GUIConstants.au3> $oIE = ObjCreate("Shell.Explorer.2") GUICreate ( "Daily bible Verse... With Sound", 600, 360) $GUIActiveX = GUICtrlCreateObj( $oIE, 0, 0 , 600 , 360) GUISetState() $oIE.navigate("http://www.biblegateway.com/usage/votd/votd2html.php?version=9&jscript=0") While GUIGetMsg() <> -3 Wend 8) Link to comment Share on other sites More sharing options...
Valuater Posted October 18, 2007 Share Posted October 18, 2007 Cut out the web site #include <GUIConstants.au3> $oIE = ObjCreate("Shell.Explorer.2") GUICreate ( "Daily bible Verse... With Sound", 600, 75) $GUIActiveX = GUICtrlCreateObj( $oIE, 0, 0 , 600 , 360) GUISetState() $oIE.navigate("http://www.biblegateway.com/usage/votd/votd2html.php?version=9&jscript=0") While GUIGetMsg() <> -3 Wend 8) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now