how parse html in server

hello guys, we want to create a parser which looking to elements value and separate the special data from that table and then store to DB .

for example we have a form and we upload a html file which include a table and we expect the data in special td cells store to the DB .

so could somebody please tell me how that can possible ? how I can read the td cell value and is there any tool in Laravel for this ?

Level 102

Why would you ever upload data as an html file? That sounds like one of the worst file types to store data in.. Why not use csv or even xlsx?

1 like

Level 1

@Sinnbeck because it's a task for company not a real project :" )))))

they just give me a html file that contains a table they specify some columns and I should write an importer that take special data to DB

Best Answer

Level 102

@dev.khosromanesh Ok. Sounds like you need to do some DOM parsing then. Luckily php has a build in dom parser called DOMDocument

1 like

Level 1

i got error that Class 'Modules\Importer\Http\Controllers\DOMDocument' not found

could you please give me some advise on this ?

used PHP version 7.4.27

1 like

Level 102

@dev.khosromanesh You need to either import it with use DOMDocument or just add a \ in front of it \DOMDocument

Level 1

@Sinnbeck i wish i could set the two answers as the best : )

good luck man

Level 102

@dev.khosromanesh Just happy to help :)

1 like

Level 3

@Sinnbeck Please note PHP DOMDocument::loadHTML only parse html 4 and for html5 cannot be safely used for sanitizing HTML

Please or to participate in this conversation.