# Module A – Memorizálandó minták

## Starter feladatok

### 01 – Starter Task 01: Front-end Skeleton

```js
function render() {
  clock.textContent = new Date().toLocaleTimeString();
}

render();
setInterval(render, 1000);
```

### 02 – Starter Task 02: Back-end Skeleton

```php
<?php $info = ['Server time' => date('Y-m-d H:i:s'), 'PHP version' => PHP_VERSION]; ?>
<table>
  <?php foreach ($info as $label => $value): ?>
    <tr><th><?= htmlspecialchars($label) ?></th><td><?= htmlspecialchars($value) ?></td></tr>
  <?php endforeach ?>
</table>
```

### 03 – Starter Task 03: Back-end with Database

```php
$file = fopen(__DIR__ . '/records.csv', 'r');
fgetcsv($file); // skip the header row

$insert = $db->prepare('INSERT INTO records (id, name, category, price, stock, created_at) VALUES (?, ?, ?, ?, ?, ?)');
while (($row = fgetcsv($file)) !== false) {
  $row[2] = $row[2] === '' ? null : $row[2];
  $insert->execute($row);
}
```

## Design

### 04 – A07-M Skeleton Loading Cards

```css
.sk { position: relative; overflow: hidden; background: #e2e8f0; }
.sk::after {
  content: "";
  position: absolute;
  inset: 0;
  transform: translateX(-100%);
  background: linear-gradient(90deg, transparent, #ffffff99, transparent);
  animation: shimmer 1.4s linear infinite;
}
@keyframes shimmer { to { transform: translateX(100%); } }
```

### 05 – A12-M 3D Image Carousel

```css
.a3d {
  --w: 17.5em;
  --r: calc((var(--w) + var(--gap)) / 2 / tan(.5turn / var(--n)));
  transform-style: preserve-3d;
  animation: spin 18s linear infinite;
}
.card {
  transform: rotateY(calc(var(--i) * 1turn / var(--n))) translateZ(var(--r));
  backface-visibility: hidden;
}
@keyframes spin { to { transform: rotateY(1turn); } }
```

### 06 – A23-E Focus Card

```css
.card-content {
  opacity: 0;
  transform: translateY(24px);
  transition: .3s ease;
}
.card:hover .card-content { opacity: 1; transform: translateY(0); }
.container:hover .card:not(:hover) {
  filter: blur(4px);
  transform: scale(.9);
}
```

### 07 – A25-E Button

```css
button {
  color: #725ac1;
  border: 2px solid #725ac1;
  transition: .3s ease;
}
button:hover {
  color: white;
  box-shadow: inset 0 -100px 0 0 #725ac1;
}
button:active { transform: scale(.9); }
```

## Frontend

### 08 – B08-E Favourite Tracks

```js
const favourites = [...playlist.querySelectorAll('.track--fav')];
favCount.textContent = favourites.length;
sessionStorage.setItem(
  STORAGE_KEY,
  JSON.stringify(favourites.map((track) => track.dataset.id)),
);
```

### 09 – B19-H Slide CAPTCHA

```js
handle.addEventListener('pointermove', (e) => {
  if (!dragging) return;
  pieceX = Math.max(0, Math.min(MAX_X, startX + e.clientX - startPointerX));
  setPosition();
});
```

### 10 – B30-E Font Hover Effect

```js
const distance = Math.hypot(e.clientX - centerX, e.clientY - centerY);
const ratio = Math.min(distance / MAX_DISTANCE, 1);
const weight = 900 - ratio * 700;
letter.style.fontWeight = weight;
```

### 11 – B40-E Scroll Ticker

```js
const position = ((index + offset) % COUNT + COUNT) % COUNT - HALF;
const distance = Math.abs(position);
item.style.opacity = Math.max(0, 1 - distance / HALF);
```

## Backend

### 12 – C06-M SQL: March Box Office Revenue

```sql
SELECT m.title AS movie_title, ROUND(SUM(b.seats * s.price_per_seat), 2) AS total_revenue
FROM movies m
JOIN screenings s ON s.movie_id = m.id
JOIN bookings b ON b.screening_id = s.id
WHERE b.status = 'completed' AND s.starts_at >= '2026-03-01' AND s.starts_at < '2026-04-01'
GROUP BY m.id, m.title
HAVING SUM(b.seats * s.price_per_seat) > 500
ORDER BY total_revenue DESC, movie_title ASC;
```

### 13 – C08-M Job Search & Pagination

```php
$filtered = array_values(array_filter($jobs, fn($job) =>
  $search === '' ||
  stripos($job['title'], $search) !== false ||
  stripos($job['company'], $search) !== false
));
$data = array_slice($filtered, ($page - 1) * 10, 10);
```

### 14 – C09-M Room Booking Conflict Checker

```php
$conflict = $booking['room_id'] == $body['room_id']
  && $booking['date'] === $body['date']
  && $body['start'] < $booking['end']
  && $body['end'] > $booking['start'];
```
