Sign in to follow this  
Followers 0
WoodGrain

Extract text from web page to database

3 posts in this topic

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#booklist

Please 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 itself

For 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!

Share this post


Link to post
Share on other sites



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&amp;jscript=0") 

While GUIGetMsg() <> -3
Wend

8)


NEWHeader1.png

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0