SELECT
p.product_id,
p.image
FROM oc_product_to_category c
INNER JOIN oc_product p ON p.product_id = c.product_id
AND p.image IS NOT NULL
WHERE c.id_categor = :categoryId
LIMIT 1
$period = new DatePeriod(
new DateTime('2019-01-21'),
new DateInterval('P1D'),
new DateTime('2019-01-28')
);
$dates = [];
foreach($period as $date){
$dates[] = $date->format("Y-m-d");
}
$where = " WHERE p.date IN ('" . implode(",'", $dates) . "')";
$data[$product][$price][] = $date;
////.......
foreach($data[$product][$price] as $datesInDb){
$missing = array_diff($dates, $datesInDb);
}
INSERT IGNORE INTO prices (columns)
VALUES (valueList),
(valueList),
...
<?php
#region DB Connection
$dbName = "test";
$dbHost = "127.0.0.1";
$dbUser = "root";
$dbPassword = "";
$dbCharset = 'UTF8';
$connection = new PDO("mysql:host={$dbHost};dbname={$dbName};charset={$dbCharset}", $dbUser, $dbPassword);
#endregion
#region Pagination
$limit = empty($_GET['limit']) ? 10 : ((int)$_GET['limit']);
$offset = empty($_GET['page']) ? 0 : (($_GET['page'] - 1) * $limit);
#endregion
#region GetTypes
$query = " SELECT
`id`,
`type`
FROM `type`";
$result = $connection
->query($query)
->fetchAll(PDO::FETCH_ASSOC);
$types = array_combine(array_column($result, 'id'), array_column($result, 'type'));
#endregion
#region GetVIIII
$query = " SELECT
`id`,
`added_date`,
`title`,
`type`
FROM `viiii`
ORDER BY `id`
LIMIT {$offset},{$limit}";
$result = $connection
->query($query)
->fetchAll(PDO::FETCH_ASSOC);
#region Render
$output = "<table>";
foreach ($result as $row){
$typeList = explode(',',$row['type']);
$typeList = array_intersect_key($types, array_flip($typeList));
$threatType = implode(", ", $typeList);
$output.=" <tr>
<td>{$row['added_date']}</td>
<td>{$row['title']}</td>
<td>{$threatType}</td>
</tr>";
}
$output.= "</table>";
echo $output;
#endregion