<?php
require('head.php');
require('include.php');
include('header.php');

$imgdir ="admin/images/";
error_reporting(E_ALL); ini_set('display_errors', 1);
?>


<?php
include("includes/db.php");

  $sql = "
  SELECT * FROM artisti where idartista =" .$_GET['id'];

  $result = $con->query($sql);
  if ($result->num_rows >0)
    while ($row = $result->fetch_assoc()):?>

<h2> <?php echo $row['nome'];?> </h2>
<img src="<?php echo $imgdir."img".$row['img'];?>">
<h3>biografia</h3>
<p> <?php echo $row['bio'];?></p>

      <?php
      endwhile;
      ?>

<h3>Concerti</h3>
<table class='home-table' id=''>
<tr>
  <th>Location</th>
  <th>Città</th>
  <th>Data</th>
</tr>


<?php
  $sql = "SELECT * FROM concerti where idartista =" .$_GET['id'];
  $result = $con->query($sql);
  if ($result->num_rows >0)
    while ($row = $result->fetch_assoc()) :?>
 <tr>
 <td> <?php echo $row['location']; ?> </td>
 <td> <?php echo $row['citta']; ?> </td>
 <td> <?php echo $row['data']; ?> </td>
</tr>

    <?php
   endwhile;
    ?>
</table>


<?php include('copyright.php'); ?>