How can PHP be used to automatically update a table with data from an external website?

To automatically update a table with data from an external website using PHP, you can use cURL to fetch the external data, parse it, and then update the table in your database with the retrieved information. You can schedule this PHP script to run at regular intervals using a cron job to keep the table updated with the latest data. 

<?php
// Set up cURL to fetch external data
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://externalwebsite.com/data');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$data = curl_exec($ch);
curl_close($ch);

// Parse the retrieved data
$externalData = json_decode($data, true);

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

// Update the table with the external data
$stmt = $pdo->prepare("UPDATE your_table SET column1 = :value1, column2 = :value2 WHERE id = :id");
foreach ($externalData as $row) {
    $stmt->execute(array(':value1' => $row['value1'], ':value2' => $row['value2'], ':id' => $row['id']));
}
?>

Keywords

PHP web scraping cURL database automation

Related Questions