$sql = "SELECT name FROM users WHERE id=:id"; $stmt = $pdo->prepare($sql); $stmt->execute(['id' => 1]); $user = $stmt->fetch(PDO::FETCH_ASSOC); echo $user['name'];
$sql = "SELECT name FROM users WHERE id=1"; $result = $mysqli->query($sql); $user = $result->fetch_assoc(); echo $user['name'];Based on the use of PDO and mysqli, it seems like the package library used might be either the PHP Data Objects (PDO) extension or the MySQL Improved Extension (mysqli).