What is the recommended approach for parsing HTML files in PHP and storing specific data in a database?

When parsing HTML files in PHP and storing specific data in a database, the recommended approach is to use a combination of PHP libraries like Simple HTML DOM Parser for parsing HTML content and database functions like PDO for interacting with the database. You can extract the required data from the HTML file using the parser and then insert it into the database using PDO prepared statements to prevent SQL injection. 

<?php

// Include the Simple HTML DOM Parser library
include('simple_html_dom.php');

// Load the HTML file
$html = file_get_html('example.html');

// Find specific data in the HTML file
$data = $html->find('div[class=specific-data]', 0)->plaintext;

// Connect to the database using PDO
$pdo = new PDO('mysql:host=localhost;dbname=database_name', 'username', 'password');

// Prepare and execute the SQL query to insert data into the database
$stmt = $pdo->prepare("INSERT INTO table_name (data) VALUES (:data)");
$stmt->bindParam(':data', $data);
$stmt->execute();

// Close the database connection
$pdo = null;

?>

Keywords

HTML parsing PHP database data extraction DOMDocument

Related Questions