<?php
$databaseHost = "mysqlstudent";
$databaseName = "xavieralletog7gi";
$databaseUser = "xavieralletog7gi";
$databasePassword = "OhsaeP1ahx6a";

$pdo = new PDO("mysql:host=$databaseHost;dbname=$databaseName", $databaseUser, $databasePassword);
$pdo->exec("SET CHARACTER SET utf8");
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
 if(isset($_POST)) {
   $id = $_GET['id'];
   $sql = "UPDATE ic_likes set likes = likes + 1 where id = $id";
  $stmt = $pdo->prepare($sql);
  $stmt->execute();
}
}

$sql = "SELECT * FROM `ic_items` INNER JOIN `ic_likes` where `ic_items`.id = `ic_likes`.id";
$stmt = $pdo->prepare($sql);
$stmt->execute();
$items = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach($items as $key=>$value) {
    var_dump($key);

}
die;
?>