Web Scraping is a technique used to extract large amounts of data from websites extracted and saved them to a local file in your computer or to a database or can be used as API. Data displayed by most websites can be viewed by using a web browser only. They do not offer the functionality to save a copy of this data for use. Thus the only option is to copy and paste the selected data that is required, which in reality, is a very tedious job and may take hours complete. In other terms, Web Scraping is the technique of automating such a process, in place of manual work, the Web Scraping software performs the same task within seconds.
<div class="table-responsive">
<table class="table table-striped" style="background:#f7f7f7">
<tr>
<td>S.No</td>
<td>Website url</td>
<td>Heading Selector</td>
<td>Thumbnail Selector</td>
<td>Details Page url selector</td>
<td>Action</td>
</tr>
<!-- loop start -->
<?php
global $wpdb;
$result = $wpdb->get_results("SELECT * FROM wp_websites");
foreach ($result as $key => $print) {
?>
<tr>
<td width='25%'><?php echo $key+1; ?></td>
<td width='25%'><?php echo $print->website_url; ?></td>
<td width='25%'><?php echo $print->heading_selector; ?></td>
<td width='25%'><?php echo $print->thumb_selector; ?></td>
<td width='25%'><?php echo $print->details_page_url; ?></td>
<td width='25%'>
<a href='admin.php?page=event-edit&id=<?php echo $print->id; ?>'>
<button class='btn btn-success btn-sm' type='button'>Edit</button></a>
<a href='admin.php?page=crud.php&del=<?php echo $print->id; ?>'>
<button class='btn btn-danger btn-sm' type='button'>DELETE</button>
</a>
</td>
</tr>
<?php
}
?>
<!-- loop end -->
</table>
</div>
