<?php
$affectedRow = 0;
$url1 = 'https://wordpress.org/plugins/sitemap-2.xml';
$xml = simplexml_load_file("$url1") or die('Sorry');
foreach ($xml->children() as $row) {
$link = $row->loc;
echo $link;
echo '</br>';
if (! empty($result)) {
$affectedRow ++;
} else {
$error_message = mysqli_error($conn) . "\n";
}
}
if ($affectedRow > 0) {
$message = $affectedRow . " URLs have been crawled. It will index in the next crawl date";
} else {
$message = "No records inserted";
}
?>
<div class="affected-row"><?php echo $message; ?></div>
<?php if (! empty($error_message)) { ?>
<div class="error-message"><?php echo nl2br($error_message); ?></div>
<?php } ?>