Why am I unable to fetch any data from a mysql table

Question

what error there is in Foreach?

<?php
    $banco = "mysql:dbnmae=banco;host=localhost";
    $user = "root";
    $senha = "";
    try{
       $conn= new PDO($banco,$user,$senha);
       echo "<h1>conectado com sucesso</h1>";
       $sql = " SELECT * FROM banco";
       $linha =$conn->query($sql);

       foreach($linha as $linhas){
           echo $linhas['nome'];
       }
    }
    catch (PDOException $e){
        echo "<h1>Falha ao conectar</h1>";

       $erro = $e->getCode();
      echo $erro;
    }

Answer 1

It’s a clerical error. You wrote dbnmae instead of dbname. Change your variable $banco for:

$banco = "mysql:dbname=banco;host=localhost";