Salutări, am o platformă de genul PTC și aș dorii să contorizez click-urile date pe o reclamă și adresa IP a utilizatorului, salvând informațiile în baza de date. Cum aș putea face lucrul acesta?
Codul paginii de reclame
@extends('layouts.dashboard')
@section('title', 'View All Available Ads')
@section('content')
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-header card-header-icon" data-background-color="green">
<i class="material-icons">important_devices</i>
</div>
<br>
<h4 class="card-title">All Available Ads</h4>
<div class="card-content">
<br>
@if(count($adverts) > 0)
<div class="table-responsive">
<table class="table">
<thead>
<tr>
<th class="text-center">ID</th>
<th>Ad Title</th>
<th>Ad Rewards</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
@php $id=0;@endphp
@foreach($adverts as $advert)
@php $id++;@endphp
<tr>
<td>{{ $id }}</td>
<td>{{ $advert->ptc->title }}</td>
<td>{{config('app.currency_symbol')}} {{ $advert->ptc->rewards +0 }}</td>
<td>
@if($advert->status == 0)
<span class="btn btn-danger"><i class="material-icons">edit</i> Not Show</span>
@else
<span class="btn btn-primary"><i class="material-icons">edit</i> Viewed</span>
@endif
</td>
<td >
@if($advert->status == 0)
<a href="{{route('userCashLinks.show', $advert->id)}}" type="button" rel="tooltip" class="btn btn-info">
<i class="material-icons">edit</i>
View Ads
</a>
@else
<span class="btn btn-primary"><i class="material-icons">edit</i> Viewed</span>
@endif
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@else
<h1 class="text-center">No Advertisement Right Now</h1>
@endif
<div class="row">
<div class="col-sm-6 col-sm-offset-5">
{{$adverts->render()}}
</div>
</div>
</div>
</div>
</div>
</div>
@endsection
Baza de date: