Jump to content
Sign in to follow this  

Extract text from web page to database

Recommended Posts

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?


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.


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)


While GUIGetMsg() <> -3



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  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...