Avatar of Daniele Brunengo
Daniele Brunengo
Flag for Italy asked on

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

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.
Web DevelopmentHTMLDatabases

Avatar of undefined
Last Comment
Daniele Brunengo

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Brad Groux

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Daniele Brunengo

ASKER
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 Groux

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 Brunengo

ASKER
Ok, thanks, I'll try that. I'll report back in a few days.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Daniele Brunengo

ASKER
There are a few bumps, but your route is actually the best, so thanks and here's your points.