We help IT Professionals succeed at work.

Create a searchable online database out of a single, huge html page

489 Views
Last Modified: 2014-08-27
Hello, so I was tasked with creating a searchable database out of this single, humongous web page:

http://www.formatoql.it/wp-content/uploads/2011/06/rule-cards.html

This page contains a list of thousands of cards related to a card-game. The site's owner would like to convert it to a dynamic searchable database where you search for a card's name and you get a page with the card's data.

Before starting, I thought I'd ask some of you guys since online databases and search engines are fairly new to me.

So what do you think would be the best course of action to convert the page, and which kind of database would you choose? My first thought was MySQL, but maybe it would be overkill?

Thanks guys.
Comment
Watch Question

Senior Manager (Wintel Engineering)
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Daniele BrunengoIT Consultant, Web Designer

Author

Commented:
I had read something about json, mostly forgot about it, but I think you may have hit the jackpot.

The problem I think I may have is with those Notes at the end of each card: some have one or more, some have none.
Brad GrouxSenior Manager (Wintel Engineering)

Commented:
There is no reason you can't have an entry for multiple notes and only call those on the cards that need it, and/or make a single note section and just delaminate each multiple note as they are now, with a carriage return, paragraph or bullet.
Daniele BrunengoIT Consultant, Web Designer

Author

Commented:
Ok, thanks, I'll try that. I'll report back in a few days.
Daniele BrunengoIT Consultant, Web Designer

Author

Commented:
There are a few bumps, but your route is actually the best, so thanks and here's your points.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.