*************

SQL code: Upload dump Copy Format Clear

CREATE TABLE category ( id int primary key, name varchar(64) ); INSERT INTO category Values (1, 'Cat1'); CREATE TABLE products ( id int primary key, category_id int references category(id), name varchar(64) ); INSERT INTO products Values (1, 1, 'Prod1');

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php // require "config/connect.php"; // Подключаю бд и 2 таблицы $connect = &$mysqli; // $_GET['id'] = 1; $idCategory = (int)$_GET['id']; $categories = mysqli_query($connect, "SELECT * FROM `category` WHERE `id` = '$idCategory'"); $categories = mysqli_fetch_assoc($categories); // var_dump($categories); $products = mysqli_query($connect, "SELECT * FROM `products` WHERE `category_id` = '$idCategory'"); $products = mysqli_fetch_all($products, MYSQLI_ASSOC); // var_dump($products); foreach ($products as $product) { ?> <tr> <th><?= $product['name'] ?></th> <td> <a href="/products/delete.php?id=<?= $product['id']?>"><button class="btn btn-danger btn-sm"><i class="fa fa-trash-alt"></i> Удалить</button></a> </td> </tr> <?php }

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online