Hi! Could we please enable some services and cookies to improve your experience and our website?

PHPize Online / SQLize Online  /  SQLtest Online

A A A
Login    Share code      Blog   FAQ

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Copy Format Clear
create table category ( id int not null primary key auto_increment, name varchar(64) ); insert into category (name) values ('Cat 1'), ('Cat 2');

Stuck with a problem? Got Error? Ask AI support!

Copy Clear
Copy Format Clear
<?php $id = 1; $name = 'Cat 2'; //Выбираем все категории с базы данных $stmt = $pdo->prepare("SELECT * FROM category WHERE id=:id OR name=:name"); $stmt->execute(['id'=> $id, 'name'=> $name]); $res = $stmt->fetchAll(PDO::FETCH_ASSOC); //Выводим категории по колонке имени в базе foreach ($res as $row) { echo '<a href="/"><b>' . $row['id'] . '</b></a><br>' . PHP_EOL; }
Copy Clear