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 `data` (
`id` int(6) unsigned NOT NULL,
`dni` int(6) unsigned NOT NULL,
`nombre` varchar(50) NOT NULL,
`total` int(5) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT INTO `data` (`id`, `dni`,`nombre`,`total`) VALUES
('1', 99991,'Empleado1', 90),
('2', 99992,'Empleado2', 60),
('3', 99993,'Empleado3', 116);
<?php
$num=99991;
$stmt = $pdo->prepare("SELECT * FROM data where dni = ?");
$stmt->execute([$num]);
$dato = $stmt->fetchAll(PDO::FETCH_ASSOC);
var_dump($dato);
echo $nombre = $dato[0]["nombre"];