How can PHP be used to extract specific content from a webpage and store it in a MySQL database?

To extract specific content from a webpage and store it in a MySQL database using PHP, you can use a combination of web scraping techniques and MySQL queries. First, you need to use PHP to fetch the webpage content using functions like file_get_contents or cURL. Then, you can use libraries like DOMDocument or SimpleHTMLDom to parse the HTML and extract the specific content you need. Finally, you can insert the extracted data into a MySQL database using SQL queries. 

<?php
// Fetch webpage content
$url = 'https://example.com';
$html = file_get_contents($url);

// Parse HTML content
$dom = new DOMDocument();
@$dom->loadHTML($html);

// Extract specific content
$elements = $dom->getElementsByTagName('h1');
$content = $elements->item(0)->nodeValue;

// Store content in MySQL database
$mysqli = new mysqli('localhost', 'username', 'password', 'database');
$stmt = $mysqli->prepare("INSERT INTO table_name (content) VALUES (?)");
$stmt->bind_param('s', $content);
$stmt->execute();

echo "Content extracted and stored in database successfully!";
?>

Keywords

PHP web scraping MySQL database data extraction DOM parsing

Related Questions