Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE IF NOT EXISTS `product` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
INSERT INTO `product` (`id`, `name`) VALUES (NULL,'godzilla');
INSERT INTO `product` (`id`, `name`) VALUES (NULL,'kong');
<?php
$query = "SELECT name FROM product";
$query = $pdo->prepare($query);
$query->execute();
$response = $query->fetchAll(PDO::FETCH_ASSOC);
if (count($response) > 0) {
var_dump($response);
}
$query = "SELECT name FROM product WHERE name='god'";
$query = $pdo->prepare($query);
$query->execute();
$response = $query->fetchAll(PDO::FETCH_ASSOC);
if (count($response) > 0) {
var_dump($response);
} else {
echo "по данному запросу ничего не найдено";
}